sequelize-pg-utilities

const { configure } = require('sequelize-pg-utilities'); const { Sequelize } = require('sequelize'); // Assuming Sequelize is installed // Mock a config/config.json structure const appConfig = { development: { username: process.env.DB_USER ?? 'my-dev-user', password: process.env.DB_PASS ?? 'my-dev-password', database: process.env.DB_NAME ?? 'my-project-development' }, test: { /* ... */ }, production: { /* ... */ } }; // To simulate different environments for quickstart process.env.NODE_ENV = 'development'; async function initializeDatabase() { try { const { name, user, password, options, dbNew } = await configure(appConfig); console.log(`Database '${name}' initialized. New database created: ${dbNew}`); console.log(`Attempting to connect with user: ${user}`); const sequelize = new Sequelize(name, user, password, options); await sequelize.authenticate(); console.log('Database connection has been established successfully.'); // Example: Run a simple query const [results] = await sequelize.query('SELECT 1+1 AS solution'); console.log('Query result:', results[0].solution); await sequelize.close(); console.log('Database connection closed.'); } catch (error) { console.error('Unable to connect to the database or an error occurred:', error); process.exit(1); } } initializeDatabase();