如何接收mysql的枚举类型数据

ENUM('value1', 'value2', ..., 'valueN')

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    gender ENUM('Male', 'Female', 'Other')
);

from sqlalchemy import create_engine, Column, Integer, Enum
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    gender = Column(Enum('Male', 'Female', 'Other'))

engine = create_engine('mysql://user:password@host/dbname')
Session = sessionmaker(bind=engine)
session = Session()

user = session.query(User).filter_by(id=1).first()
print(user.gender)  # 输出: Male

const { Sequelize, DataTypes } = require('sequelize');
const sequelize = new Sequelize('mysql://user:password@host/dbname');

const User = sequelize.define('User', {
    gender: DataTypes.ENUM('Male', 'Female', 'Other')
});

(async () => {
    await sequelize.sync();
    const user = await User.findOne({ where: { id: 1 } });
    console.log(user.gender);  // 输出: Male
})();

ALTER TABLE users MODIFY COLUMN gender ENUM('Male', 'Female', 'Other', 'Unknown');

CREATE INDEX idx_gender ON users(gender);