Home | History | Annotate | Download | only in sqlite3 
      1 import sqlite3
      2 import string
      3 
      4 def char_generator():
      5     for c in string.ascii_lowercase:
      6         yield (c,)
      7 
      8 con = sqlite3.connect(":memory:")
      9 cur = con.cursor()
     10 cur.execute("create table characters(c)")
     11 
     12 cur.executemany("insert into characters(c) values (?)", char_generator())
     13 
     14 cur.execute("select c from characters")
     15 print(cur.fetchall())
     16