#!/usr/bin/env bash
set -euo pipefail

DB_FILE="/opt/appfactory/data/appfactory/appfactory.db"

echo "Deleting deployments older than 90 days..."

sqlite3 "$DB_FILE" "
DELETE FROM deployments
WHERE started_at < datetime('now','-90 day');
"

echo "Done."