root
33 lines
781 B
Bash
Executable File
33 lines
781 B
Bash
Executable File
#!/usr/bin/env bash
|
|
set -euo pipefail
|
|
|
|
DB="/opt/appfactory/data/appfactory/appfactory.db"
|
|
|
|
echo "Clearing runtime logs..."
|
|
|
|
sqlite3 "$DB" <<'SQL'
|
|
DELETE FROM job_logs;
|
|
DELETE FROM jobs;
|
|
DELETE FROM deployments;
|
|
DELETE FROM deployment_locks;
|
|
DELETE FROM service_health;
|
|
DELETE FROM alert_events;
|
|
DELETE FROM service_incidents;
|
|
|
|
VACUUM;
|
|
SQL
|
|
|
|
echo
|
|
echo "Runtime logs cleared."
|
|
echo
|
|
echo "Current counts:"
|
|
|
|
sqlite3 "$DB" <<'SQL'
|
|
SELECT 'job_logs', count(*) FROM job_logs;
|
|
SELECT 'jobs', count(*) FROM jobs;
|
|
SELECT 'deployments', count(*) FROM deployments;
|
|
SELECT 'deployment_locks', count(*) FROM deployment_locks;
|
|
SELECT 'service_health', count(*) FROM service_health;
|
|
SELECT 'alert_events', count(*) FROM alert_events;
|
|
SELECT 'service_incidents', count(*) FROM service_incidents;
|
|
SQL |