def saveData2DB(datalist,dbpath):
init_db('movietest.db')
conn = sqlite3.connect(dbpath)
cur = conn.cursor()
for data in datalist:
for index in range(len(data)):
if index == 4 or index == 6:
continue
data[index] = '"'+data[index]+'"'
sql = '''
insert into movie250
(
id,info_link,pic_link,cname,ename,score,rated,instroduction,info)
values(%s)'''%','.join(data) #data列表 每一个都用逗号连接起来
print(sql)
cur.execute(sql)
conn.commit()
cur.close()
conn.close()
def init_db(path):
sql = '''
create table movie250
(
id integer primary key autoincrement,
info_link text,
pic_link text,
cname varchar,
ename varchar,
score numeric,
rated numeric,
instroduction text,
info text
)
''' #创建数据表
conn = sqlite3.connect(path)
cursor = conn.cursor()
cursor.execute(sql)
conn.commit()
conn.close()
saveData2DB()
中的dbpath
和init_db('movietest.db')
中的movietest.db
是一样的吗?
是不是sql语句那里写多了一个id字段