import sqlite3

conn = sqlite3.connect(':memory:')
conn.execute('create table test (number int)')
conn.commit()

c = conn.cursor()

c.executemany('insert into test(number) values (?)', xrange(100))
conn.commit()

conn.close()

c.executemany('insert into test(number) values (?)', ((i, ) for i in xrange(100)))