aboutsummaryrefslogtreecommitdiff
path: root/test.py
blob: 821bf62c8e4eb88d15fdb6ff22b36486b96186a5 (plain)
1
2
3
4
5
6
7
8
import sqlite3

con = sqlite3.connect("test.db")
cur = con.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS cards (idx INTEGER PRIMARY KEY, weight INTEGER, key STRING, val STRING)")
for i in range(10**8):
    cur.execute("INSERT INTO cards VALUES(?, ?, ?, ?)", (i, 1, i, i))
con.commit()