blob: 84c230b6b0be7c2ce739f1a2da93db28aad5f3b4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
#!/usr/bin/python
import sqlite3
con = sqlite3.connect("test.db")
con.execute("PRAGMA journal_mode=wal")
cur = con.cursor()
cur.execute("CREATE TABLE 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()
|
