/Doc/includes/sqlite3/executemany_1.py
http://unladen-swallow.googlecode.com/ · Python · 24 lines · 18 code · 6 blank · 0 comment · 1 complexity · 591c1ad6757d2a37a86398aedea32a8d MD5 · raw file
- import sqlite3
- class IterChars:
- def __init__(self):
- self.count = ord('a')
- def __iter__(self):
- return self
- def next(self):
- if self.count > ord('z'):
- raise StopIteration
- self.count += 1
- return (chr(self.count - 1),) # this is a 1-tuple
- con = sqlite3.connect(":memory:")
- cur = con.cursor()
- cur.execute("create table characters(c)")
- theIter = IterChars()
- cur.executemany("insert into characters(c) values (?)", theIter)
- cur.execute("select c from characters")
- print cur.fetchall()