从收藏夹中删除produсt时出错(我自己创建了愿望列表系统)

// 示例前端代码
document.getElementById('deleteButton').addEventListener('click', function() {
    const productId = this.dataset.productId;
    fetch(`/api/products/${productId}`, {
        method: 'DELETE',
        headers: {
            'Content-Type': 'application/json',
            'Authorization': 'Bearer ' + localStorage.getItem('token')
        }
    })
    .then(response => response.json())
    .then(data => {
        if (data.success) {
            alert('Product deleted successfully');
            // 更新UI，移除已删除的product
        } else {
            alert('Failed to delete product: ' + data.message);
        }
    })
    .catch(error => {
        console.error('Error:', error);
        alert('An error occurred while deleting the product');
    });
});

# 示例后端代码（Python/Flask）
from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///database.db'
db = SQLAlchemy(app)

class Product(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), nullable=False)

@app.route('/api/products/<int:product_id>', methods=['DELETE'])
def delete_product(product_id):
    product = Product.query.get(product_id)
    if not product:
        return jsonify({'success': False, 'message': 'Product not found'}), 404
    
    db.session.delete(product)
    db.session.commit()
    
    return jsonify({'success': True}), 200

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

-- 示例SQL语句
DELETE FROM products WHERE id = ?;

# 示例权限检查
def check_permission(user_id, product_id):
    # 这里可以添加具体的权限检查逻辑
    return True