import sqlite3

db_path = r"C:\ProgramData\Jellyfin\Server\data\jellyfin.db"

print("Connecting to database...")
conn = sqlite3.connect(db_path)
cur = conn.cursor()

print("Running integrity check...")
print(cur.execute("PRAGMA integrity_check;").fetchall())

print("WAL Checkpoint...")
cur.execute("PRAGMA wal_checkpoint(TRUNCATE);")
conn.commit()

print("Cleaning old activity logs...")
cur.execute("DELETE FROM ActivityLogs WHERE DateCreated < datetime('now', '-30 days');")
conn.commit()

print("Reindexing...")
cur.execute("REINDEX;")
conn.commit()

print("Analyzing...")
cur.execute("ANALYZE;")
conn.commit()

print("Running VACUUM (this may take time)...")
cur.execute("VACUUM;")

conn.commit()
conn.close()
print("!Maintenance complete!")