Files

14 lines
266 B
Bash
Executable File

#!/usr/bin/env bash
set -euo pipefail
DB_FILE="/opt/appfactory/data/appfactory/appfactory.db"
echo "Deleting service health records older than 5 days..."
sqlite3 "$DB_FILE" "
DELETE FROM service_health
WHERE checked_at < datetime('now','-5 day');
"
echo "Done."