setup_db.js

const mysql = require('mysql2/promise');
const fs = require('fs');
const path = require('path');

async function setupDatabase() {
    const config = {
        host: '172.29.0.11',
        port: 3306,
        user: process.argv[2],
        password: process.argv[3],
        multipleStatements: true
    };

    try {
        console.log('Connecting to MySQL Server...');
        const connection = await mysql.createConnection(config);
        
        console.log('Connected! Reading schema...');
        const schemaSql = fs.readFileSync(path.join(__dirname, 'schema.sql'), 'utf8');
        
        console.log('Executing schema...');
        await connection.query(schemaSql);
        
        console.log('Database setup completed successfully!');
        console.log('Created DB: ods_db');
        console.log('Created Tables: users, orders');
        console.log('Default Admin: admin / admin123');
        
        await connection.end();
    } catch (err) {
        console.error('Error:', err.message);
        process.exit(1);
    }
}

if (process.argv.length < 4) {
    console.log('Usage: node setup_db.js <user> <password>');
    process.exit(1);
}

setupDatabase();