diff options
Diffstat (limited to 'tools/purge.sql')
| -rw-r--r-- | tools/purge.sql | 35 |
1 files changed, 0 insertions, 35 deletions
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); |