mysql 循环save

import mysql.connector
from mysql.connector import pooling

db_config = {
    "host": "localhost",
    "user": "user",
    "password": "password",
    "database": "database_name"
}

connection_pool = mysql.connector.pooling.MySQLConnectionPool(pool_name="mypool", pool_size=5, **db_config)

def save_data(data):
    connection = connection_pool.get_connection()
    cursor = connection.cursor()
    query = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
    cursor.executemany(query, data)
    connection.commit()
    cursor.close()
    connection.close()

data_to_save = [
    ("value1", "value2"),
    ("value3", "value4"),
    # ...
]
save_data(data_to_save)

def save_data_with_transaction(data):
    connection = connection_pool.get_connection()
    cursor = connection.cursor()
    query = "INSERT INTO table_name (column1, column2) VALUES (%s, %2)"
    try:
        connection.start_transaction()
        cursor.executemany(query, data)
        connection.commit()
    except mysql.connector.Error as err:
        connection.rollback()
        print(f"Error: {err}")
    finally:
        cursor.close()
        connection.close()