/Doc/includes/sqlite3/executemany_1.py

 1import sqlite3
 2
 3class IterChars:
 4    def __init__(self):
 5        self.count = ord('a')
 6
 7    def __iter__(self):
 8        return self
 9
10    def next(self):
11        if self.count > ord('z'):
12            raise StopIteration
13        self.count += 1
14        return (chr(self.count - 1),) # this is a 1-tuple
15
16con = sqlite3.connect(":memory:")
17cur = con.cursor()
18cur.execute("create table characters(c)")
19
20theIter = IterChars()
21cur.executemany("insert into characters(c) values (?)", theIter)
22
23cur.execute("select c from characters")
24print cur.fetchall()