python中executemany和生成器的应用

一 代码

import sqlite3import stringdef 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',)]