我现在有一个二维数组,一个一维数组(对应数据库中的一列),我想要分别将他们插入数据库,目前二维数据可以插入,但是一维数组插入的时候不是从数据库的第一行开始插入,而是从尾部插入。下面是相关代码,不知道要怎么修改了
def init_db(dbpath):
sql = '''
create table lndz
(id integer primary key autoincrement,
datetime date,
date date,
time text ,
dongjing numeric,
beiwei numeric,
zhenzhong text,
zhenji numeric
)
''' # 创建数据表
conn = sqlite3.connect(dbpath)
cursor = conn.cursor()
cursor.execute(sql)
conn.commit()
conn.close()
def savedb(datalist, dbpath):
init_db(dbpath)
conn = sqlite3.connect(dbpath)
cur = conn.cursor()
for i, row in enumerate(datalist):
cur.execute('INSERT INTO lndz (date, time, dongjing, beiwei,zhenzhong, zhenji) VALUES (?, ?, ?, ?, ?, ?)', row)
conn.commit()
cur.close()
conn.close()
def savetime(data1d, dbpath):
conn = sqlite3.connect(dbpath)
cur = conn.cursor()
for item in data1d:
cur.execute('INSERT INTO lndz (datetime) VALUES (?)', (item,))
conn.commit()
cur.close()
conn.close()
if __name__ == '__main__':
datalist = shaixuan()
timelist = get_time()
dbpath = "lndz.db"
savedb(datalist, dbpath)
savetime(timelist, dbpath)
print("成功")