如何仅当具有相同ID时才能修改状态

from flask import Flask, request, jsonify
import mysql.connector

app = Flask(__name__)

# 连接MySQL数据库
db = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 定义接口路由，处理状态修改请求
@app.route('/update_status', methods=['POST'])
def update_status():
    # 获取请求参数
    user_id = request.json['id']
    new_status = request.json['status']
    
    # 检查用户权限，可以根据实际情况进行认证和授权
    
    # 查询数据库，检查是否存在具有相同ID的记录
    cursor = db.cursor()
    query = "SELECT * FROM User WHERE ID = %s"
    cursor.execute(query, (user_id,))
    result = cursor.fetchone()
    
    if result is None:
        return jsonify({'message': '无法修改状态，用户ID不存在'})
    
    # 更新状态
    update_query = "UPDATE User SET Status = %s WHERE ID = %s"
    cursor.execute(update_query, (new_status, user_id))
    db.commit()
    
    return jsonify({'message': '状态已成功修改'})

if __name__ == '__main__':
    app.run()