migrate_add_platform.js

Go to the documentation of this file.

/**
 * Migration script: Add platform column to agents table
 * Run with: node scripts/migrate_add_platform.js
 */
 
const pool = require('../services/db');
 
/**
 *
 */
async function migrate() {
  try {
    console.log('Adding platform column to agents table...');
    
    await pool.query(`
      ALTER TABLE agents ADD COLUMN IF NOT EXISTS platform VARCHAR(50);
    `);
    
    console.log('✅ Migration successful');
    
    // Update existing agents
    const result = await pool.query(`
      UPDATE agents SET platform = 'unknown' WHERE platform IS NULL;
    `);
    
    console.log(`✅ Updated ${result.rowCount} existing agents`);
    
    process.exit(0);
  } catch (err) {
    console.error('❌ Migration failed:', err);
    process.exit(1);
  }
}
 
migrate();