import pymysql
from doubanmovie import settings*这有问题爬出来的数据存不到数据库里
class DoubanmoviePipeline(object):
def init(self):
self.connect = pymysql.connect(
host=settings.MYSQL_HOST,
db=settings.MYSQL_DBNAME,
user=settings.MYSQL_USER,
passwd=settings.MYSQL_PASSWD,
charset='utf8',
use_unicode=True)
self.cursor = self.connect.cursor()
def process_item(self, item, spider):
try:
self.cursor.execute(
"""insert into doubantop250(title,movieInfo,star,quote)
value (%s,%s,%s,%s)""",
(item['title'],
item['movieInfo'],
item['star'],
item['quote']))
self.connect.commit()
except Exception as err:
print("重复插入了==>错误信息为:" + str(err))
return item
应该是这样吧
def process_item(self, item, spider):
try:
self.cursor.execute(
"""insert into doubantop250(title,movieInfo,star,quote)
value (%s,%s,%s,%s)""" %
(item['title'],
item['movieInfo'],
item['star'],
item['quote']))
self.connect.commit()
except Exception as err:
print("重复插入了==>错误信息为:" + str(err))
return item