Integer array field in postgress is not handled by flask admin properly

[remort]

Integer array field in my table in postgres exists and work perfectly. I can create/apdate/insert/delete it with numbers.
Flask-admin sees and interprets that field by SQLAlchemy model. Field shows up with its content in edit form in flask-admin.
But whenever I try to save the form (regardless of editing or leaving contents of array field as is) I got error 500. Postgres throws an error:
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column "courses_ids" is of type integer[] but expression is of type text[]
So it seems that flask-admin interprets my int array field as text array.
Is there any solution on how to instruct Flask-Admin that the array field is of type int ?

Sqlalchemy field declaration: courses_ids = Column(ARRAY(Integer))

[aaron-nall]

A workaround:

class Select2IntegerTagsField(Select2TagsField):
    def process_formdata(self, valuelist):
        super().process_formdata(valuelist)
        self.data = [int(x) for x in self.data]


class StudentView(ModelView):
    def scaffold_form(self):
        form_class = super().scaffold_form()
        form_class.course_ids = Select2IntegerTagsField("Course Ids", save_as_list=True)
        return form_class

admin.add_view(StudentView(Student, session))

[antonyc]

Hi. Will this be systematically fixed without workarounds?

[chen-zhuohan]

thanks! it's help me a lot

[Shir-AH]

A workaround:

class Select2IntegerTagsField(Select2TagsField):
    def process_formdata(self, valuelist):
        super().process_formdata(valuelist)
        self.data = [int(x) for x in self.data]


class StudentView(ModelView):
    def scaffold_form(self):
        form_class = super().scaffold_form()
        form_class.course_ids = Select2IntegerTagsField("Course Ids", save_as_list=True)
        return form_class

admin.add_view(StudentView(Student, session))

what is the Select2TagsField Class you're inheriting from?

[catalintrif]

Please review this fix #2003

[ovyan]

For future generations.

what is the Select2TagsField Class you're inheriting from?

from flask_admin.form.fields import Select2TagsField