#!/bin/bash
set -o errexit
set -o nounset
set -o pipefail

TRUNCATE_FROM="$(date --date='36 hours ago' --iso-8601=seconds)"
cat <<SQL | sqlite3 /data/pds/sequencer.sqlite >/dev/null
PRAGMA wal_autocheckpoint = 0;
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;

DELETE FROM repo_seq WHERE seq IN (SELECT seq FROM repo_seq WHERE "sequencedAt" < '$TRUNCATE_FROM' ORDER BY seq ASC LIMIT 20000);
SQL