Defining SQLAlchemy enum column with Python enum raises “ValueError: not a valid enum”

by

The column type should be sqlalchemy.types.Enum. You’re using the Python Enum type again, which was valid for the value but not the column type. Back in 2016, when the question was written, this was necessary:

class MyTable(db.Model):
    id = db.Column(db.Integer, primary_key = True)
    fruit_type = db.Column(db.Enum(FruitType))

However, this is not the case anymore.

Leave a Comment