def get_book_info(self,text):
more_book_list =[]
for i in range(20):
book_info = {}
book_info["booksit"] = url_book_list[i] if boname_list else None
book_info["boname"] = boname_list[i] if boname_list else None
book_info["auname"] = auname_list[i] if auname_list else None
book_info["subname"] = subname_list[i] if subname_list else None
book_info["subtype"] = subtype_list[i] if subtype_list else None
book_info["bointro"] = bointro_list[i] if bointro_list else None
book_info["charnu"] = charnu_list[i] if charnu_list else None
book_info["uping"] = uping_list[i] if uping_list else None
book_info["burl"] = burl_list[i] if burl_list else None
more_book_list.append(book_info)
return more_book_list
def ins_to_sql(self,sql):
conn=MySQLdb.connect("127.0.0.1", "root", "usbw", "carwbook", 3307 )
cursor=conn.cursor()
for book_info in sql:
cursor.execute('INSERT INTO booktable(boname,auname,subname,subtype,bointro,charnu,uping,burl) VALUES (book_info["boname"],book_info["auname"],book_info["subname"],book_info["subtype"],book_info["bointro"],book_info["charnu"],book_info["uping"],book_info["burl"])')
conn.commit()
conn.close()
if name == '__main__':
url = 'https://www'
text = book.get_html(url)
sql = book.get_book_info(text)
如何把上面的list 中的字典 循环 存储到下面的表中
表的字段jie'gou"booksit","boname","auname","subname","subtype","bointro","charnu","uping","burl"
def ins_to_sql(self,sql):中我好像循环不出来,到sql中,感觉 没有从列表中把字典拿出来,谁能帮我再看看,谢谢!