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()