| Line | |
|---|
| 1 | import sqlite3
|
|---|
| 2 |
|
|---|
| 3 | class 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 |
|
|---|
| 16 | con = sqlite3.connect(":memory:")
|
|---|
| 17 | cur = con.cursor()
|
|---|
| 18 | cur.execute("create table characters(c)")
|
|---|
| 19 |
|
|---|
| 20 | theIter = IterChars()
|
|---|
| 21 | cur.executemany("insert into characters(c) values (?)", theIter)
|
|---|
| 22 |
|
|---|
| 23 | cur.execute("select c from characters")
|
|---|
| 24 | print cur.fetchall()
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.