[BUG] SQLAlchemy Exception when using Enums and jsonable_encoder

[ebreton]

Issue added for reference.

• Full description in appropriate repo: jsonable_encoder does not take the Config into account for Enums fastapi#196
• Exception thrown: sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTextRepresentation) invalid input value for enum YOUR-TYPE: "YOUR-VALUE"

[tiangolo]

Thanks, I'll check it.

[AnneNamuli]

I am having almost the same issue.. I keep getting validation errors when i use enum type

[ebreton]

I am working on it, and got it running with CrudBase. I will update #23 accordingly asap.

I still have one limit though, which is using the same string for name and value.

• value because it is used by pydantic
• name because it is used by SQLalchemy

I keep you posted...

[AnneNamuli]

Thanks!!

[tiangolo]

I think this was solved in your PR right @ebreton ? 🤓 🚀

May we close it?

[ebreton]

You are right @tiangolo, thanks for the clean-keeping work. And for the whole fastapi ecosystem. It rocks 🌟 💎