/Doc/includes/sqlite3/executemany_2.py
http://unladen-swallow.googlecode.com/ · Python · 15 lines · 11 code · 4 blank · 0 comment · 1 complexity · 0717c019409e9592c979752a0e040271 MD5 · raw file
- import sqlite3
- def char_generator():
- import string
- for c in string.letters[:26]:
- 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()