require('dotenv').config();
const fs = require('fs');
const path = require('path');
const pool = require('../server/db');

async function main() {
  const sqlPath = path.join(__dirname, '../db/migrate-search.sql');
  const sql = fs.readFileSync(sqlPath, 'utf8');
  await pool.query(sql);
  console.log('Catalog search indexes ready');
  await pool.end();
}

main().catch((err) => {
  console.error(err);
  process.exit(1);
});