def createEngine(self):
_config = get_config_db_mysql()
if _config == None:
logging.error("MySQL is not configed.")
return None
db_string = "mysql+mysqlconnector://%s:%s@%s/%s?charset=utf8" % (self.dbuser,
self.dbpassword,
self.dbhost,
self.dbname)
if self.dbengine == None:
engine = create_engine(db_string, echo_pool=True)
self.dbengine = engine
# it will create a thread local session for every single web request
return self.dbengine
def __init__(self):
_config = get_config_db_mysql()
if _config == None:
logging.error("MySQL is not configed.")
return
DB_NAME = _config.get("db_name")
DB_PASS = _config.get("db_pass")
DB_USER = _config.get("db_user")
DB_HOST = _config.get("db_host")
self.dbhost = DB_HOST
self.dbname = DB_NAME
self.dbuser = DB_USER
self.dbpassword = DB_PASS
super(SqlInstance, self).__init__()
return
