def createEngine(self): _psql = get_config_db_psql() if _psql == None: logging.error("PSQL not configed.") reutrn None db_string = "postgresql+psycopg2://%s:%s@%s/%s" % (self.dbuser, self.dbpassword, self.dbhost, self.dbname) if self.dbengine == None: self.dbengine = create_engine(db_string, echo_pool=True) # it will create a thread local session for every single web request return self.dbengine
def __init__(self): _psql = get_config_db_psql() if _psql == None: logging.error("PSQL not configed.") reutrn DB_NAME = _psql.get("db_name") DB_PASS = _psql.get("db_pass") DB_USER = _psql.get("db_user") DB_HOST = _psql.get("db_host") self.dbhost = DB_HOST self.dbname = DB_NAME self.dbuser = DB_USER self.dbpassword = DB_PASS super(SqlInstance, self).__init__() return