SqlAlchemy Database Model: Access Column Enum value

Viewed 53

In model I have:

class GenderEnum(enum.Enum):
    man = "ﻡﺭﺩ"
    woman = "ﺰﻧ"

class Users(db.Model, UserMixin):

    __tablename__ = 'Users'

    id = db.Column(db.Integer, primary_key=True)
    # Gender
    gender = db.Column(db.Enum(GenderEnum), unique=False, default="man")

Then I am trying to define a custom converter for mode_form method which extract the enum value as a label used to show a field in WTForm

@converts('Enum')
def conv_Enum(self, column, field_args, **extra):
    if 'choices' not in field_args:
        field_args['choices'] = [(e, e) for e in column.type.enums]
        assert False, field_args["choices"] 
    return f.SelectField(**field_args)

However, I don't know how to access the values (مرد , زن) here to populate (key, value) for choices

0 Answers
Related