| 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() |