def add_foreign_keys_process():
dump_date = get_dump_date(MYSQL, ARCHIVES_BASE_FOLDER)
mysql = MySQL(dump_date)
mysql.optimize_load()
foreign_key_file = open(FOREIGN_KEYS_FILE, 'r').read()
mysql.execute_file(foreign_key_file)
mysql.disconnect()
def create_indexes_process():
dump_date = get_dump_date(MYSQL, ARCHIVES_BASE_FOLDER)
dump_indexes_file = os.path.join(
get_dump_folder_endpoint(ARCHIVES_BASE_FOLDER, MYSQL, dump_date),
f'{INDEXES}.sql')
change_content_in_file(GHTORRENT, f"{GHTORRENT}-{dump_date}",
dump_indexes_file)
copy_file(dump_indexes_file, INDEXES_FILE)
change_content_in_file(f"{GHTORRENT}-{dump_date}", GHTORRENT,
dump_indexes_file)
indexes_files = open(INDEXES_FILE, 'r').read()
mysql = MySQL(dump_date)
mysql.execute_file(indexes_files)
mysql.disconnect()