sqlite2duckdb.py

import duckdb

sqlite_file = "data/apscheduler_events.db"
duckdb_file = "data/apscheduler_events.duckdb"

con = duckdb.connect(duckdb_file)

con.execute("INSTALL sqlite;")
con.execute("LOAD sqlite;")

# get tables
tables = con.execute(
    f"""
    SELECT name
    FROM sqlite_scan('{sqlite_file}', 'sqlite_master')
    WHERE type='table'
"""
).fetchall()

for (table,) in tables:
    print(f"Copying {table}")
    con.execute(
        f"""
        CREATE TABLE "{table}" AS
        SELECT * FROM sqlite_scan('{sqlite_file}', '{table}');
    """
    )

con.close()

print("✅ Conversion complete")