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