import { DatabaseSync } from 'node:sqlite';
const db = new DatabaseSync(process.argv[2]+'/userdata/statev2.sqlite',{readOnly:true});
console.log('Runtime: Node '+process.version+' / SQLite '+db.prepare('select sqlite_version() as version').get().version);
for (const [label,table,column] of [['Project','projection_projects','default_model_selection_json'],['Thread','projection_threads','model_selection_json']]) {
 const row=db.prepare(`select ${column} as selection, json_type(${column}, '$.options') as optionsType from ${table}`).get();
 console.log(label+' options JSON type: '+row.optionsType);
 console.log(label+' selection: '+row.selection);
}
const row=db.prepare("select json_extract(payload_json,'$.modelSelection') as selection from orchestration_v2_projection_threads where thread_id='thread-legacy'").get();
console.log('Hydrated V2 thread model selection: '+row.selection);
db.close();
