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