Python MySQL.optimize_load Examples

Example #1

File: mysql_users_dumps.py Project: Bluewaree/dev-data

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

Example #2

def restore_users_schema_process():
    dump_date = get_dump_date(MONGO, ARCHIVES_BASE_FOLDER)
    if is_dump_date_valid(dump_date):
        csv_file = os.path.join(ARCHIVES_BASE_FOLDER,
                                f"{MONGO}-{USERS}-{dump_date}.csv")
        mysql = MySQL(USERS_TEMP)
        mysql.optimize_load()
        mysql.restore_users_schema(csv_file, USERS)
        mysql.commit()
        mysql.create_index_users_login()
        mysql.disconnect()

Example #3

def process(table):
    global dump_date
    global file_destination

    mysql = MySQL(dump_date)
    mysql.optimize_load()
    print(f"processing table {table}")
    csv_file = f"{file_destination}/{table}.csv"
    mysql.restore_db(csv_file, table)
    print(f"finished processing file {table}")
    mysql.commit()
    mysql.disconnect()