scripts/check-duplicates.ts

import db from '../src/lib/db';

const duplicates = db.prepare(`
  SELECT yuque_id, count(*) as count, group_concat(id) as ids
  FROM documents 
  GROUP BY yuque_id 
  HAVING count > 1
`).all();

console.log('Duplicates by yuque_id:', duplicates);

const duplicatesBySlug = db.prepare(`
  SELECT slug, count(*) as count, group_concat(id) as ids
  FROM documents 
  GROUP BY slug 
  HAVING count > 1
`).all();

console.log('Duplicates by slug:', duplicatesBySlug);

const allDocs = db.prepare('SELECT count(*) as count FROM documents').get();
console.log('Total documents:', allDocs);