apply_platform_migration.js

Go to the documentation of this file.

#!/usr/bin/env node
/**
 * Apply platform column migration to production database
 * Run this on a machine that has access to the production database
 */
 
const { Pool } = require('pg');
require('dotenv').config();
 
const pool = new Pool({
  connectionString: process.env.DATABASE_URL,
  ssl: process.env.DB_SSL === 'true' ? { rejectUnauthorized: false } : false
});
 
async function applyMigration() {
  const client = await pool.connect();
  
  try {
    console.log('🔄 Applying platform column migration...');
    
    await client.query(`
      ALTER TABLE agents 
      ADD COLUMN IF NOT EXISTS platform VARCHAR(20);
    `);
    
    await client.query(`
      COMMENT ON COLUMN agents.platform IS 'Operating system platform (win32, linux, darwin)';
    `);
    
    console.log('✅ Migration applied successfully!');
    console.log('   - Added platform column to agents table');
    
  } catch (err) {
    console.error('❌ Migration failed:', err.message);
    process.exit(1);
  } finally {
    client.release();
    await pool.end();
  }
}
 
applyMigration();