Truncates the PDS sequencer DB to retain only events in the last 36hrs
tom.sherman.is
truncate-pds-sequencer.pds
1#!/bin/bash
2set -o errexit
3set -o nounset
4set -o pipefail
5
6TRUNCATE_FROM="$(date --date='36 hours ago' --iso-8601=seconds)"
7cat <<SQL | sqlite3 /data/pds/sequencer.sqlite >/dev/null
8PRAGMA wal_autocheckpoint = 0;
9PRAGMA journal_mode = WAL;
10PRAGMA synchronous = NORMAL;
11
12DELETE FROM repo_seq WHERE seq IN (SELECT seq FROM repo_seq WHERE "sequencedAt" < '$TRUNCATE_FROM' ORDER BY seq ASC LIMIT 20000);
13SQL