src/db/config.js

const { Pool } = require('pg');
const fs = require('fs');
const path = require('path');
require('dotenv').config();

const config = {
    user: process.env.DB_USER || "avnadmin",
    password: process.env.DB_PASSWORD || "AVNS_8YN2lShyUCy56qezi-_",
    host: process.env.DB_HOST || "staging-photobrex-3b7a.j.aivencloud.com",
    port: parseInt(process.env.DB_PORT || "10838"),
    database: process.env.DB_NAME || "defaultdb",
    ssl: {
        rejectUnauthorized: false,
    },
};

const pool = new Pool(config);


pool.on('connect', () => {
    console.log('✅ Connected to PostgreSQL database');
});

pool.on('error', (err) => {
    console.error('❌ Unexpected error on idle client', err);
    process.exit(-1);
});

module.exports = pool;