// Clears the local SQLite database (all payments.db* files).
// Usage: npm run reset-db
// Stop the server first, then run this — db.js recreates an empty table on next start.
const fs = require('fs');
const path = require('path');

const dataDir = path.join(__dirname, '..', 'data');
let removed = 0;

if (fs.existsSync(dataDir)) {
  for (const file of fs.readdirSync(dataDir)) {
    if (file.startsWith('payments.db')) {
      fs.rmSync(path.join(dataDir, file), { force: true });
      removed++;
    }
  }
}

console.log(removed ? `Cleared ${removed} database file(s).` : 'No database files to clear.');