def debug_sql(self, sql):
if Config.getConf("public", "debug_sql") == "True":
pass
def getInstance(db_name):
try:
if isinstance(db_name, unicode):
db_name = db_name.encode("utf8")
if DBPool.pool.get(db_name):
return DBPool.pool.get(db_name)
else:
# print Config.getConf('db_'+db_name,"dbhost")
tmp_pool = PooledDB(MySQLdb, \
int(Config.getConf("dbpool_config", "db_mincached")), \
int(Config.getConf("dbpool_config", "db_maxcached")), \
int(Config.getConf("dbpool_config", "db_maxshared")), \
int(Config.getConf("dbpool_config", "db_maxconnections")), \
int(Config.getConf("dbpool_config", "db_blocking")), \
int(Config.getConf("dbpool_config", "db_maxusage")), \
["SET NAMES utf8", "SET CHARACTER SET utf8"], \
host=Config.getConf('db_' + db_name, "dbhost"), \
user=Config.getConf('db_' + db_name, "dbuser"), \
passwd=Config.getConf('db_' + db_name, "dbpass"), \
db=Config.getConf('db_' + db_name, "dbname"), \
charset=Config.getConf('db_' + db_name, "charset"), \
port=int(Config.getConf('db_' + db_name, "dbport")))
tmp_pool.charset = Config.getConf('db_' + db_name, "charset")
DBPool.pool[db_name] = tmp_pool
return DBPool.pool[db_name]
except Exception, e:
func_ext.error_log(e)
time.sleep(5)
return DBPool.getInstance(db_name)
