1  -- Migration 064: Cleanup test DBs cron job
 2  -- Deletes leftover test SQLite files (*.db) from tests/ and /tmp that are
 3  -- older than 1 hour. These accumulate when test after() hooks don't fire
 4  -- (e.g. test crashes, SIGKILL, timeout).
 5  --
 6  -- Runs daily at 3 AM (low-traffic window, after log rotation at 2 AM).
 7  
 8  INSERT OR REPLACE INTO cron_jobs
 9    (name, task_key, description, handler_type, handler_value,
10     interval_value, interval_unit, enabled)
11  VALUES
12    ('Cleanup Test DBs', 'cleanupTestDbs',
13     'Delete stale test SQLite files from tests/ and /tmp older than 1 hour',
14     'function', 'cleanupTestDbs', 1, 'days', 1);