25 lines
615 B
JavaScript
25 lines
615 B
JavaScript
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);
|
|
});
|
|
|