def from_settings(cls, settings):
dbparms = dict(
host = settings["MYSQL_HOST"],
db = settings["MYSQL_DBNAME"],
user = settings["MYSQL_USER"],
passwd = settings["MYSQL_PASSWORD"],
charset='utf8',
cursorclass=pymysql.cursors.DictCursor,
use_unicode=True,
)
dbpool = adbapi.ConnectionPool("pymysql", **dbparms)
return cls(dbpool)
python类ConnectionPool()的实例源码
def __init__(self):
self.dbpool = adbapi.ConnectionPool(
dbapiName = 'MySQLdb',
host = 'localhost',
db = 'sina_spider_db',
user = 'root',
passwd = 'gongli',
cursorclass = MySQLdb.cursors.DictCursor,
charset = 'utf8mb4',
)
def __init__(self):
self.dbpool = adbapi.ConnectionPool(
dbapiName='MySQLdb',
host=settings.DB_HOST,
db=settings.DB,
user=settings.DB_NAME,
passwd=settings.DB_PASSWD,
cursorclass= MySQLdb.cursors.DictCursor,
charset = 'utf8',
use_unicode = False
)
def __init__(self):
self.dbpool = adbapi.ConnectionPool(
dbapiName='MySQLdb',
host=settings.DB_HOST,
db=settings.DB,
user=settings.DB_NAME,
passwd=settings.DB_PASSWD,
cursorclass= MySQLdb.cursors.DictCursor,
charset = 'utf8',
use_unicode = False
)
def from_settings(cls, settings):
dbparms = dict(
host=settings["MYSQL_HOST"],
db=settings["MYSQL_DBNAME"],
user=settings["MYSQL_USER"],
passwd=settings["MYSQL_PASSWORD"],
charset='utf8',
cursorclass=MySQLdb.cursors.DictCursor,
use_unicode=True,
)
dbpool = adbapi.ConnectionPool("MySQLdb", **dbparms)
return cls(dbpool) # dbpool???__init__
# ??twisted?mysql????????
def __init__(self):
self.dbpool=adbapi.ConnectionPool('MySQLdb',
host='127.0.0.1',
db='liaohong_test',
user='root',
passwd='liaohong',
cursorclass=MySQLdb.cursors.DictCursor,
charset='utf8',
use_unicode=True)
def __init__(self, info):
self.info = info
self.dbpool = adbapi.ConnectionPool(**self.info)
def __setstate__(self, state):
self.__dict__ = state
self.info['password'] = getpass.getpass('Database password for %s: ' % (self.info['user'],))
self.dbpool = adbapi.ConnectionPool(**self.info)
del self.info['password']
def from_settings(cls, settings):
dbargs = dict(
host=settings['MYSQL_HOST'],
db=settings['MYSQL_DBNAME'],
user=settings['MYSQL_USER'],
passwd=settings['MYSQL_PASSWD'],
charset='utf8',
cursorclass = MySQLdb.cursors.DictCursor,
use_unicode= True,
)
dbpool = adbapi.ConnectionPool('MySQLdb', **dbargs)
return cls(dbpool)
def __init__(self):
self.dbpool = adbapi.ConnectionPool('MySQLdb', db='spiders',
user='root', passwd='build.ns', cursorclass=MySQLdb.cursors.DictCursor,
charset='utf8', use_unicode=True)
def adb_connect_db(db_type,**kwargs):
'''
db_type-->"MySQLdb"
'''
dbpool = adbapi.ConnectionPool(db_type, **kwargs)
return dbpool
def adb_connect_db(db_type,**kwargs):
'''
db_type-->"MySQLdb"
'''
dbpool = adbapi.ConnectionPool(db_type, **kwargs)
return dbpool
def adb_connect_db(db_type,**kwargs):
'''
db_type-->"MySQLdb"
'''
dbpool = adbapi.ConnectionPool(db_type, **kwargs)
return dbpool
