mysql 避免重复请求

import uuid
import mysql.connector

def create_order(user_id, product_id):
    # 生成唯一标识符
    request_id = str(uuid.uuid4())
    
    # 连接数据库
    conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
    cursor = conn.cursor()
    
    try:
        # 检查请求标识符是否已存在
        cursor.execute("SELECT COUNT(*) FROM orders WHERE request_id = %s", (request_id,))
        count = cursor.fetchone()[0]
        
        if count == 0:
            # 插入新订单
            cursor.execute("INSERT INTO orders (user_id, product_id, request_id) VALUES (%s, %s, %s)", (user_id, product_id, request_id))
            conn.commit()
            print("Order created successfully.")
        else:
            print("Duplicate request ignored.")
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    finally:
        cursor.close()
        conn.close()

# 示例调用
create_order(1, 101)