import { query } from '../db/index.js';

async function main() {
  const tables = (await query("SELECT name FROM sqlite_master WHERE type='table' ORDER BY name")).rows.map(
    (r) => r.name
  );
  console.log('tables', tables);

  const counts = ['formex_materials', 'formex_variants', 'formex_dimensions', 'finishes', 'products', 'suppliers'];
  for (const t of counts) {
    try {
      const r = await query(`SELECT COUNT(*) as c FROM ${t}`);
      console.log(t, r.rows[0]?.c);
    } catch {
      console.log(t, '(missing)');
    }
  }
}

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