import { Client } from 'pg';

const db = new Client({
    user: 'user',
    host: 'localhost',
    database: 'dbName',
    password: 'P@ss',
    port: 2232,
});
export default db ;

import db from 'file1';

var client =  await db.connect();
export async function GET() {


    try {
        client = await db.connect();
        console.log("client is NOW connected!");
    } catch (error) {
        console.log("client is already connected - "+error ) ; // Terminal responded : client is already connected - Error: Client has already been connected. You cannot reuse a client.
    }
    
    
    try {
        console.log("try is fired"); // Terminal responded : try is fired
        console.log("client: " + client); // Terminal responded : client: undefined
        console.log("db: " + db); // Terminal responded : db: [object Object]
        console.log("db.user: " + db.user); // Terminal responded : db.user: user
        await client.query(`BEGIN`); // Terminal error "TypeError: Cannot read properties of undefined (reading 'query')"
///////// also tried await client.sql(`BEGIN`); // Terminal error "TypeError: Cannot read properties of undefined (reading 'sql')"

        await client.query(`COMMIT`);

        return Response.json({ message: 'success' });
    } catch (error) {
        console.log("error")
        await client.query(`ROLLBACK`);
        return Response.json({ error }, { status: 500 });
    }
    
}