# Option A: read from git cache
cat .git/opencode

# Option B: compute it yourself (run from the repo)
git rev-list --max-parents=0 --all | sort | head -1

bun -e "
const { Database } = require('bun:sqlite');
const d = new Database('$HOME/.local/share/opencode/opencode.db', {readonly: true});

// All sessions grouped by project_id and directory
const rows = d.query('SELECT project_id, directory, COUNT(*) as c FROM session GROUP BY project_id, directory ORDER BY c DESC').all();
rows.forEach(r => console.log(r.project_id, '|', r.directory, '|', r.c, 'sessions'));
"

bun -e "
const { Database } = require('bun:sqlite');
const d = new Database('$HOME/.local/share/opencode/opencode.db');

const PROJECT_ID = '<git-root-commit-sha>';  // from: git rev-list --max-parents=0 --all
const DIRECTORY  = '<your-project-path>';     // e.g. /home/user/my-project

const before = d.query(\`SELECT COUNT(*) as c FROM session WHERE project_id = 'global' AND directory = '\${DIRECTORY}'\`).get();
console.log('Sessions to migrate:', before.c);

d.run(\`UPDATE session SET project_id = '\${PROJECT_ID}' WHERE project_id = 'global' AND directory = '\${DIRECTORY}'\`);

const after = d.query(\`SELECT COUNT(*) as c FROM session WHERE project_id = '\${PROJECT_ID}'\`).get();
console.log('Sessions under new project_id:', after.c);
d.close();
"

bun -e "
const { Database } = require('bun:sqlite');
const d = new Database('$HOME/.local/share/opencode/opencode.db');

const DIRECTORY = '<your-directory-path>';  // e.g. /home/user/notes

const before = d.query(\`SELECT COUNT(*) as c FROM session WHERE project_id = 'global' AND directory = '\${DIRECTORY}'\`).get();
console.log('Sessions to fix:', before.c);

d.run(\`UPDATE session SET directory = '/' WHERE project_id = 'global' AND directory = '\${DIRECTORY}'\`);
console.log('Fixed. Sessions now accessible under global project.');
d.close();
"

bun -e "
const { Database } = require('bun:sqlite');
const d = new Database('$HOME/.local/share/opencode/opencode.db', {readonly: true});

const orphans = d.query(\"SELECT project_id, directory, COUNT(*) as c FROM session WHERE project_id = 'global' AND directory != '/' GROUP BY project_id, directory\").all();
if (orphans.length === 0) {
  console.log('No orphaned sessions. All good.');
} else {
  console.log('Remaining orphans:');
  orphans.forEach(o => console.log(o.directory, ':', o.c, 'sessions'));
}
d.close();
"