python3 异步写入MySQL
十分想念顺店杂可。。。
pipelines.py
# pipelines.py
from .settings import MY_SETTINGS
from pymysql import cursors
# twisted 网络框架
# API 接口
from twisted.enterprise import adbapi
class SaveToMysqlAsynPipeline(object):
# 从配置文件中读取配置
@classmethod
def from_settings(cls, settings):
asyn_mysql_settings = MY_SETTINGS
asyn_mysql_settings['cursorclass'] = cursors.DictCursor
dbpool = adbapi.ConnectionPool("pymysql", **asyn_mysql_settings)
return cls(dbpool)
def __init__(self, dbpool):
self.dbpool = dbpool
if os.path.exists("job.state"):
bloom = Bloomfilter("job.state")
else:
bloom = Bloomfilter(1000000)
self.bloom = bloom
query = self.d