python中executemany和生成器的应用

一 代码

import sqlite3
import string
def char_generator():
    for c in string.ascii_lowercase:
        yield(c)
conn=sqlite3.connect(":memory:")
cur=conn.cursor()
cur.execute("CREATE TABLE character(c)")
cur.executemany("INSERT INTO character(c) VALUES(?)",char_generator())
cur.execute("SELECT c FROM character")
print(cur.fetchall())

 

二 运行结果

y =======

[('a',), ('b',), ('c',), ('d',), ('e',), ('f',), ('g',), ('h',), ('i',), ('j',), ('k',), ('l',), ('m',), ('n',), ('o',), ('p',), ('q',), ('r',), ('s',), ('t',), ('u',), ('v',), ('w',), ('x',), ('y',), ('z',)]