/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

  1. import sqlite3
  2. def char_generator():
  3. import string
  4. for c in string.letters[:26]:
  5. yield (c,)
  6. con = sqlite3.connect(":memory:")
  7. cur = con.cursor()
  8. cur.execute("create table characters(c)")
  9. cur.executemany("insert into characters(c) values (?)", char_generator())
  10. cur.execute("select c from characters")
  11. print cur.fetchall()