I need some help with an issue regarding enumerations in Flask.

[nonozone]

I need some help with an issue regarding enumerations in Flask.

My model is as follows:

class ApprovalStatus(PyEnum):

PENDING = 'pending'

APPROVED = 'approved'

REJECTED = 'rejected'

class Approval(db.Model):

id = db.Column(db.Integer, primary_key=True)

content_type = db.Column(db.String(50), nullable=False)

content_id = db.Column(db.Integer, nullable=False)

field_name = db.Column(db.String(50), nullable=False)

new_value = db.Column(db.Text, nullable=False)

status = db.Column(SQLAlchemyEnum(ApprovalStatus), default=ApprovalStatus.PENDING)

submitter_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

submit_time = db.Column(db.DateTime, default=current_time)

reviewer_id = db.Column(db.Integer, db.ForeignKey('user.id'))

review_time = db.Column(db.DateTime, default=current_time)

review_comment = db.Column(db.Text)

submitter = db.relationship('User', foreign_keys=[submitter_id])

reviewer = db.relationship('User', foreign_keys=[reviewer_id])

__table_args__ = (UniqueConstraint('content_type', 'content_id'),)

[u/property](https://www.reddit.com/user/property/)

def content(self):

model = getattr(models, self.content_type)

return model.query.get(self.content_id)

However, I keep encountering the following error:

LookupError: 'pending' is not among the defined enum values. Enum name: approvalstatus. Possible values: PENDING, APPROVED, REJECTED

[nonozone]

I have already queried the database, and all the enum values in it are lowercase. However, theoretically, no matter what I change the name on the left side of the enum to, it should not affect the operation of the database. But in reality, now I can only run normally if I keep both sides of the enum in consistent case.

[ThiefMaster]

Please post correctly indented Python code, that's not been copy-pasted from what looks like a reddit post. You also failed to include the full traceback of your exception.

[ThiefMaster]

Oh I see you reposted it in pallets/flask#5600 with correct formatting and the missing details even though it's not a flask question. Next time edit your original one.