Files

10 lines
498 B
JavaScript

const Database = require('better-sqlite3');
const db = new Database('D:\\Projects\\ai-review\\server\\data\\ai-review.db');
const tables = db.prepare("SELECT name FROM sqlite_master WHERE type='table' ORDER BY name").all();
console.log('Tables:', tables.map(t=>t.name).join(', '));
const projects = db.prepare('SELECT * FROM projects').all();
console.log('Projects:', projects.length);
const entries = db.prepare('SELECT * FROM entries').all();
console.log('Entries:', entries.length);
db.close();