18 lines
818 B
JavaScript
18 lines
818 B
JavaScript
const Database = require('better-sqlite3');
|
|
const db = new Database('data/ai-review.db');
|
|
const tables = db.prepare("SELECT name FROM sqlite_master WHERE type='table'").all();
|
|
console.log('Tables:', tables.map(t => t.name));
|
|
const s = db.prepare('SELECT * FROM standards').all();
|
|
s.forEach(st => {
|
|
const dims = JSON.parse(st.dimensions || '[]');
|
|
console.log('Standard:', st.name, '(' + dims.length + ' dims)');
|
|
dims.forEach((d, i) => console.log(' [' + i + ']', d.name, '(' + d.maxScore + ')'));
|
|
});
|
|
const e = db.prepare('SELECT * FROM entries LIMIT 2').all();
|
|
e.forEach(ent => {
|
|
const snap = JSON.parse(ent.standard_snapshot || '[]');
|
|
console.log('Entry:', ent.title, '- snapshot dims:', snap.length);
|
|
snap.forEach((d, i) => console.log(' [' + i + ']', d.name, '(' + d.maxScore + ')'));
|
|
});
|
|
db.close();
|