# Created on savesnippets.com · https://savesnippets.com/4HehUdXBczdIb6
import sqlite3

def bulk_insert(db: sqlite3.Connection, table: str, rows: list[dict]) -> int:
    if not rows:
        return 0
    cols = list(rows[0].keys())
    placeholders = ", ".join(f":{c}" for c in cols)
    col_list     = ", ".join(cols)
    db.executemany(f"INSERT INTO {table} ({col_list}) VALUES ({placeholders})", rows)
    return len(rows)

with sqlite3.connect("app.db") as db:
    db.execute("CREATE TABLE IF NOT EXISTS events (id INTEGER PRIMARY KEY, user_id INTEGER, name TEXT)")
    bulk_insert(db, "events", [
        {"user_id": 1, "name": "login"},
        {"user_id": 1, "name": "view_page"},
        {"user_id": 2, "name": "signup"},
    ])