import { pool } from './src/db/migrate.js';

async function main() {
  const result = await pool.query(`
    UPDATE dispensaries
    SET
      menu_url = $1,
      scraper_template = $2,
      updated_at = CURRENT_TIMESTAMP
    WHERE id = $3
    RETURNING id, name, menu_url, scraper_template
  `, [
    'https://best.treez.io/onlinemenu/?customerType=ADULT',
    'treez',
    149
  ]);

  console.log('Updated BEST Dispensary:');
  console.log(JSON.stringify(result.rows[0], null, 2));

  await pool.end();
}

main().catch(console.error);