[WIP] sqlalchemy_utils for ColorType, JSONType, PasswordType, ScalarListType

[colin99d]

This PR attempts to add the remaining sqlachemy_utils data types. Complete list here: https://sqlalchemy-utils.readthedocs.io/en/latest/data_types.html#module-sqlalchemy_utils.types.choice. Notes for each one appear below:

• ArrowType: already implemented
• ChoiceType: got this to work, but implementation is not super user friendly. Would love suggestions for a better implementation
• CompositeType: postgres specific and I use mysql (:, skipping
• ColorType: implemented
• CountryType, CurrencyType, LocalType, WeekDaysType: currently breaks if nothing is sent to the form, this seems to be common among all forms using Babel. @aminalaee do you have any suggestion on how I could fix this?
• : already implemented
• EmailType: Did in Handling for sqlalchemy_utils EmailType and IPAddressType #150
• EncryptedType: currently this uses a binary encryption which is not practical to type into a form. Based on their documentation this will be changed to a string implementation in the future and we can implement then.
• JSONType: implemented
• LtreeType: postgres specific and I use mysql (:, skipping
• IPAddressType: Did in Handling for sqlalchemy_utils EmailType and IPAddressType #150
• PasswordType: implemented
• PhoneNumberType: This uses composite type, how do we want to implement it?
• ScalarListType: implemented, however adding an item does not work well (I still think a bad implementation is better than the presence of the field crashing the server)
• TimezoneType: implemented
• TSVectorType: postgres specific and I use mysql (:, skipping
• URLType: already implemented
• UUIDType: already implemented

[aminalaee]

Any updates?

[colin99d]

Yeah, was hoping for your thoughts on ChoiceType, CountryType, CurrencyType, LocalType and WeekDaysType. Then I was going to move on from there.

[aminalaee]

Thanks for the PR.

[aminalaee]

https://github.com/flask-admin/flask-admin/blob/7cff9c742d44d42a8d3495c73a6d71381c796396/flask_admin/contrib/sqla/form.py#L301

[colin99d]

Hey man, I did my best to implement choices like you suggested but ran into errors. Any way I could get some help?

[aminalaee]

@colin99d Thanks, I think the pipeline is failing for the black formatting, but if you see it's a blocker, just leave it outside the PR so we can pick it up later.

And also please rename the PR so it's clear what types are added.

[colin99d]

So I should just exclude choices for now?

[aminalaee]

Yes please.

[aminalaee]

Are you still interested in updating this?

[colin99d]

Sorry kinda spaced it! Do you just need me to get CI to pass?