python sqlite数据库一对多_使用Python将多个类型插入到SQLite数据库中

(一个月后)，两个步骤：

1例如，将DAS lats lons times展平为一个长列表，比如18 long

2生成“Insert into tablename xx(？)？,?,... 18个问号)，然后执行。在Test = 1

def flatten( *args ):

""" 1, (2,3), [4,5] -> [1 2 3 4 5] """

# 1 level only SO [python] [flatten] zzz

all = []

for a in args:

all.extend( a if hasattr( a, "__iter__" ) else [a] )

if Test: print "test flatten:", all

return all

def sqlinsert( db, tablename, *args ):

flatargs = flatten( *args ) # one long list

ncol = len(flatargs)

qmarks = "?" + (ncol-1) * ",?"

insert = "Insert into tablename %s values (%s)" % (tablename, qmarks)

if Test: print "test sqlinsert:", insert

if db:

db.execute( insert, flatargs )

# db.executemany( insert, map( flatargs, rows ))

return insert

#...............................................................................

if __name__ == "__main__":

print sqlinsert( None, "Table", "hidiho", (4,5), [6] )