def __init__(self, filename='../resources/db_properties.ini'): if self.INSTANCE is not None: raise ValueError("An instantiation already exists!") else: db_config = read_db_config(filename) self.__cnxPool = MySQLConnectionPool(pool_name="myPool", pool_size=10, **db_config)
class Config: environ = read_db_config(filename='../resources/user_properties.ini') print(environ) # Database config db_user = environ.get('user') db_password = environ.get('password') db_host = environ.get('host') db_port = environ.get('port') db_name = environ.get('database')
def __backup_data(self, data_dir='restore_backup/backup', sql_filename='resources/select_sql.ini'): self.__check_exists_dir(data_dir) sql_info = read_db_config(sql_filename) print(sql_info) for table_name, table_sql in sql_info.items(): self.__backup_query(data_dir, table_sql, table_name) print("OK")
def __load_data(self, con=None, sql_filename='resources/insert_sql.ini'): _db = read_db_config(sql_filename) print("__load_data ", _db) try: cursor = con.cursor() for table_name, table_sql in _db.items(): print('==============__load_data', table_name, table_sql) cursor.execute(table_sql) con.commit() print("OK") except mysql.connector.Error as err: raise err finally: cursor.close()
def __init__(self, db_conf=None): self.db_conf = db_conf self._db = read_db_config(db_conf)
def __init__(self, filename='insert_sql.ini', db_con_info=None): print(filename) self._db = read_db_config(filename) self._db_con_info=db_con_info print(self._db)