如何定义"ENUM“类型并将值放入回送模型本身？

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    role ENUM('admin', 'editor', 'user') NOT NULL
);

from enum import Enum

class Role(Enum):
    ADMIN = 'admin'
    EDITOR = 'editor'
    USER = 'user'

# 使用枚举
user_role = Role.ADMIN

from flask import Flask, jsonify
from enum import Enum

app = Flask(__name__)

class Role(Enum):
    ADMIN = 'admin'
    EDITOR = 'editor'
    USER = 'user'

class User:
    def __init__(self, id, username, role):
        self.id = id
        self.username = username
        self.role = role

users = [
    User(1, 'admin_user', Role.ADMIN),
    User(2, 'editor_user', Role.EDITOR),
    User(3, 'normal_user', Role.USER)
]

@app.route('/users', methods=['GET'])
def get_users():
    user_list = []
    for user in users:
        user_list.append({
            'id': user.id,
            'username': user.username,
            'role': user.role.value
        })
    return jsonify(user_list)

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

SELECT id, username, FIELD(role, 'admin', 'editor', 'user') AS role FROM users;