#保存数据到数据库
def saveData():
db = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='movies' , charset='utf8')
cursor = db.cursor()
#使用cursor 创建游标
#调用getData,获得爬取数据
datalist = getData(baseurl)
for data in datalist():
for i in range(len(data)):
if i == 2 or i == 3:
continue
data[i] = '"'+data[i]+'"'
sql = '''
INSERT INTO msg(murl,mname,mgrade,mdata,mdescribe)VALUES(%s)
''' %",".join(data) #join 把data数据用“,”连接起来
cursor.execute(sql)
db.commit()
cursor.close()
db.close()
saveData()**
Traceback (most recent call last):
File "D:\PycharmProjects\pythonProject\main.py", line 86, in
saveData()
File "D:\PycharmProjects\pythonProject\main.py", line 73, in saveData
for data in datalist():
TypeError: 'NoneType' object is not callable
getData(baseurl)返回了空值,检查这个函数吧
把datalist()括号去掉看看