setup-db.js

const { Client } = require('pg');

// Connect to the Postgres Container
const client = new Client({
    connectionString: 'postgres://admin:password123@localhost:5432/flashflow'
});

async function createTables() {
    try {
        await client.connect();
        console.log('🔌 Connected to Postgres');

        // 1. Create Orders Table
        await client.query(`
            CREATE TABLE IF NOT EXISTS orders (
                id SERIAL PRIMARY KEY,
                user_id VARCHAR(50) NOT NULL,
                item VARCHAR(100) NOT NULL,
                price DECIMAL(10, 2) NOT NULL,
                status VARCHAR(20) DEFAULT 'SUCCESS',
                created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
            );
        `);
        
        console.log('✅ Tables Created Successfully!');
    } catch (err) {
        console.error('❌ Error:', err);
    } finally {
        await client.end();
    }
}

createTables();