const { Client } = require('pg');
const client = new Client('postgres://postgres:csh%402018@localhost:5432/ai_pharmacy');
client.connect().then(async () => {
  await client.query("UPDATE products SET mrp = 30.00 WHERE brand_name = 'Dolo'");
  await client.query("UPDATE products SET mrp = 115.00 WHERE brand_name = 'Benadryl DR'");
  console.log('Prices updated');
  process.exit(0);
}).catch(console.error);