Support for choice option in Integer Field too

[sumitsharansatsangi]

Piccolo currently supports choice option only for Varchar Column type , It will be good , if it can support for Integer Type too.

[sinisaos]

@sumitsharansatsangi Sorry if I don't understand well, but you can already use choices in Integer column. Example from Piccolo Admin.

[sumitsharansatsangi]

Piccolo Supports Choice for IntegerField. It was my mistake. I have not checked it properly.

[dantownsend]

If you have this:

class MyTable(Table):
    class Choices(int, Enum):
        choice_1 = 1
        choice_2 = 2

    my_column = Integer(choices=Choices)

In Piccolo Admin the options are shown as choice 1, choice 2 etc (i.e. the enum keys), and not the values (1, 2) which is what's stored in the database.

If you wanted the choices to be numbers from 1 to 3 in Piccolo Admin, and show them as '1', '2', '3' ... you should use this:

https://github.com/piccolo-orm/piccolo/blob/master/piccolo/columns/choices.py

I'm not sure if it's in the docs, but it will let you do this:

from piccolo.columns.choices import Choice

class MyTable(Table):
    class Choices(Enum):
        choice_1 = Choice(1, '1')
        choice_2 = Choice(2, '2')
        choice_3 = Choice(3, '3')

    my_column = Integer(choices=Choices)

[sumitsharansatsangi]

@dantownsend , Thanks for suggesting the second method, I was not aware of this, and it's not in the docs. I think the second method has more use cases than the first one. Please add it in the docs.