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)