使用自动递增Ids将数据从MySQL迁移到谷歌数据存储？

mysqldump -u [username] -p [database_name] > dump.sql

import json
import re

def parse_mysql_dump(file_path):
    with open(file_path, 'r') as file:
        lines = file.readlines()

    data = []
    current_entry = {}
    in_insert_statement = False

    for line in lines:
        line = line.strip()
        if line.startswith('INSERT INTO'):
            in_insert_statement = True
            current_entry = {}
        elif line.startswith(');'):
            in_insert_statement = False
            data.append(current_entry)
        elif in_insert_statement and ',' in line:
            columns, values = line.split('(', 1)
            columns = columns.split(',')
            values = values.rstrip(')').split('","')
            for col, val in zip(columns, values):
                current_entry[col.strip('"')] = val.strip('"')

    return data

def convert_to_json(data):
    return json.dumps(data, indent=4)

if __name__ == "__main__":
    file_path = 'dump.sql'
    data = parse_mysql_dump(file_path)
    json_data = convert_to_json(data)
    with open('data.json', 'w') as file:
        file.write(json_data)

gcloud datastore import --input-url=file://data.json

from google.cloud import datastore

def import_data_to_datastore(json_file_path):
    client = datastore.Client()

    with open(json_file_path, 'r') as file:
        data = json.load(file)

    for entry in data:
        entity = datastore.Entity(client.key('EntityKind'))  # Replace 'EntityKind' with your entity kind
        entity.update(entry)
        client.put(entity)

if __name__ == "__main__":
    json_file_path = 'data.json'
    import_data_to_datastore(json_file_path)