123456789101112131415161718192021222324252627282930 |
- # -*- coding: utf-8 -*-
- import MySQLdb
- # Define your item pipelines here
- #
- # Don't forget to add your pipeline to the ITEM_PIPELINES setting
- # See: http://doc.scrapy.org/en/latest/topics/item-pipeline.html
- class ShlibPipeline(object):
- #对数据保存操作,数据库/写文件/发邮件等
- def process_item(self, item, spider):
- DBKWARGS = spider.settings.get('DBKWARGS')
- MySQLdb.connect(**DBKWARGS)
- cur = con.cursor()
- sql = ("insert into proxy(IP,PORT,TYPE,POSITION,SPEED,LAST_CHECK_TIME) "
- "values(%s,%s,%s,%s,%s,%s)")
- lis = (item['IP'],item['PORT'],item['TYPE'],item['POSITION'],item['SPEED'],
- item['LAST_CHECK_TIME'])
- try:
- cur.execute(sql,lis)
- except Exception,e:
- print "Insert error:",e
- con.rollback()
- else:
- con.commit()
- cur.close()
- con.close()
- return item
-
|