summaryrefslogtreecommitdiff
path: root/scripts/clear-cache
blob: 624a0689818b31cd230c30e6a64f940e0728ba83 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
#!/bin/bash
# Clear all cached data from the production database.
# Usage: ./scripts/clear-cache
# Deletes: cards, boards, tasks, calendar_events, cache_metadata, sync_tokens

DB=/site/doot.terst.org/data/dashboard.db

sqlite3 "$DB" "
DELETE FROM cards;
DELETE FROM boards;
DELETE FROM tasks;
DELETE FROM calendar_events;
DELETE FROM cache_metadata;
DELETE FROM sync_tokens;
"

echo "Cache cleared."