爬虫实战 - SQLite - 插入函数技巧 

 1 def save_database(para_datalist, para_dbpath):
 2     conn = sqlite3.connect(para_dbpath)
 3     c = conn.cursor()
 4 
 5     for data in para_datalist:
 6         for index in range(0, len(data)):
 7             if index == 4:
 8                 continue
 9             data[index] = '"' + data[index] + '"'  # 加上引号，为后面插入数据做准备
10 
11         sql = '''
12         insert into Top_movie250(
13         movie_link, img_link, chinese_name, other_name, rating, rating_people, quote, background
14         ) values (%s)
15         ''' % ','.join(data)
16 
17         c.execute(sql)
18         conn.commit()
19 
20     conn.commit()
21     conn.close()

 

posted @ 2021-04-17 15:48  vosoland  阅读(88)  评论(0)    收藏  举报