migrate-wordpress-tables.js

Go to the documentation of this file.

const pool = require('./services/db');
const fs = require('fs');
const path = require('path');
 
const migrationFile = path.join(__dirname, 'migrations', 'add-wordpress-monitoring-tables.sql');
const sql = fs.readFileSync(migrationFile, 'utf8');
 
pool.query(sql)
  .then(() => {
    console.log('✓ WordPress monitoring tables created successfully');
    process.exit(0);
  })
  .catch(err => {
    console.error('✗ Migration failed:', err.message);
    process.exit(1);
  });