/**
 * One-off cleanup: wipe ride history accumulated before the operating-window
 * gate was added to the sampler. Safe to re-run; truncates only the two
 * sample-related tables, leaves park_days untouched.
 */
import Database from "better-sqlite3";
import path from "path";

const dbPath = path.join(__dirname, "..", "data", "parks.db");
const db = new Database(dbPath);

const before = {
  samples: (db.prepare("SELECT COUNT(*) AS c FROM ride_wait_samples").get() as { c: number }).c,
  rides: (db.prepare("SELECT COUNT(*) AS c FROM rides").get() as { c: number }).c,
};
console.log("Before:", before);

db.exec("DELETE FROM ride_wait_samples; DELETE FROM rides;");

const after = {
  samples: (db.prepare("SELECT COUNT(*) AS c FROM ride_wait_samples").get() as { c: number }).c,
  rides: (db.prepare("SELECT COUNT(*) AS c FROM rides").get() as { c: number }).c,
};
console.log("After: ", after);

db.close();