migrations/002_add_reposted_column_v1.py at 5f5b5f1720edbb991c4a1e139b755979a984a9a3 · zenfyr.dev/xpost

zenfyr.dev / xpost

social media crossposting tool. 3rd time's the charm

mastodon misskey crossposting bluesky

xpost / migrations / 002_add_reposted_column_v1.py

at 5f5b5f1720edbb991c4a1e139b755979a984a9a3 360 B view raw

 1import sqlite3
 2
 3
 4def migrate(conn: sqlite3.Connection):
 5    columns = conn.execute("PRAGMA table_info(posts)")
 6    column_names = [col[1] for col in columns]
 7    if "reposted_id" not in column_names:
 8        _ = conn.execute("""
 9            ALTER TABLE posts
10            ADD COLUMN reposted_id INTEGER NULL REFERENCES posts(id) ON DELETE SET NULL
11        """)