import { Pool } from 'pg';
import 'dotenv/config';

if (!process.env.DB_URL) throw new Error('DB_URL is required');

const pool = new Pool({
  connectionString: process.env.DB_URL,
  ssl: { rejectUnauthorized: false },
});

try {
  await pool.query(`ALTER TABLE simo_machines ADD COLUMN IF NOT EXISTS location TEXT`);
  console.log('✅ Migration v3: location column added to simo_machines');
} catch (e) {
  console.error('❌ Migration v3 failed:', e);
  process.exit(1);
} finally {
  await pool.end();
}