Doc/includes/sqlite3/executemany_2.py
import sqlite3 import string def char_generator(): for c in string.lowercase: yield (c,) con = sqlite3.connect(":memory:") cur = con.cursor() cur.execute("create table characters(c)") cur.executemany("insert into characters(c) values (?)", char_generator()) cur.execute("select c from characters") print cur.fetchall() |