How can I create a model of a table with an enum in peewee 2?

Question

I'm trying to create a model to describe a table with an enum field in peewee.

I'm seeing that EnumField was removed from the peewee.py file before the 2.0 version, and I can't find anything in the current docs that outlines how to implement it. Does anyone know if I can just use CharField?

Did you ever implement an ENUM field using a custom peewee field? If so, would you mind sharing that solution with us? — kramer65, Aug 06 '14 at 14:32

score 5 · Answer 1 · answered Nov 20 '14 at 17:07

5

Here is a working solution for PostgreSQL:

https://gist.github.com/b1naryth1ef/607e92dc8c1748a06b5d

answered Nov 20 '14 at 17:07

Mathieu Rodic

6,637
2
43
49

Why the downvote? With some feedback, I could maybe improve my answer... – Mathieu Rodic Oct 18 '17 at 14:43

score 4 · Accepted Answer · answered Jan 05 '13 at 01:16

4

there was not an EnumField prior to 2.0, but there are docs on implementing a custom field: http://peewee.readthedocs.org/en/latest/peewee/models.html#creating-a-custom-field

I hope this helps.

answered Jan 05 '13 at 01:16

coleifer

24,887
6
60
75

coleifer should that be part of standard peewee fields? I see `choices` option but if it doesn't validate value. I remember sqlobject used to support such field. – Shekhar Mar 10 '15 at 11:55

How can I create a model of a table with an enum in peewee 2?

2 Answers2