import sqlite3

db_path = r"F:\Virtual MX Dropbox\Nicolas Millot\_Private_Working_Files\_DEV\MTG\_social-analytics\social-analytics\data\app.db"

conn = sqlite3.connect(db_path)
cur = conn.cursor()

cur.execute("DELETE FROM platform_posts")
cur.execute("DELETE FROM canonical_posts")
cur.execute("DELETE FROM metrics_snapshots")

conn.commit()
conn.close()

print("Purged canonical_posts, platform_posts, metrics_snapshots")