From fc3501382c2aa3ef5b692f4f55c2616f9cade3f5 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Fri, 25 Apr 2025 12:18:00 +0200 Subject: Move toolbox scripts to a "bin" directory. Add a super "rtt" command to run the scripts. --- tools/purge.sql | 35 ----------------------------------- 1 file changed, 35 deletions(-) delete mode 100644 tools/purge.sql (limited to 'tools/purge.sql') diff --git a/tools/purge.sql b/tools/purge.sql deleted file mode 100644 index 2a95f01..0000000 --- a/tools/purge.sql +++ /dev/null @@ -1,35 +0,0 @@ --- Prune game snapshot and game state data to save database space. - -attach database 'db' as live; - -pragma live.busy_timeout=10000; - -create temporary view prune_snap_list as - select - distinct game_id - from - live.game_snap - where - game_id in ( - select game_id from live.games - where status=2 and date(mtime) < date('now', '-7 days') - ) - ; - -create temporary view prune_all_list as - select - distinct game_id - from - live.games - where - game_id in ( - select game_id from live.games - where status=2 and date(mtime) < date('now', '-28 days') - ) - ; - -select 'PURGE SNAPS FROM ' || count(1) from prune_snap_list; -delete from live.game_snap where game_id in (select game_id from prune_snap_list); - -select 'PURGE ALL FROM ' || count(1) from prune_all_list; -update live.games set status = 3 where game_id in (select game_id from prune_all_list); -- cgit v1.2.3