Files
cannaiq/backend/archive/update-best-dispensary.ts
Kelly d91c55a344 feat: Add stale process monitor, users route, landing page, archive old scripts
- Add backend stale process monitoring API (/api/stale-processes)
- Add users management route
- Add frontend landing page and stale process monitor UI on /scraper-tools
- Move old development scripts to backend/archive/
- Update frontend build with new features

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
2025-12-05 04:07:31 -07:00

25 lines
540 B
TypeScript

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);