Select with enum filter returns asyncpg.exceptions.InvalidTextRepresentationError\'>: invalid input value for enum

[ramki88]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

import enum
from sqlmodel import SQLModel, Field, Column, Enum

class Color(str, enum.Enum):
    red = "red"
    blue = "blue"
    green = "green"

class Model(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    variant: Color = Field(sa_column=Column(Enum(Color)))
    version: str

result = session.exec(select(Model).filter(Model.variant == Color.red).all())

Description

Executing the above results in the below error:

raise translated_error from error
│ └ InvalidTextRepresentationError('invalid input value for enum variant: "red"')
└ Error('<class 'asyncpg.exceptions.InvalidTextRepresentationError'>: invalid input value for enum variant: "red"')

Operating System

Linux, macOS

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

3.12.2

Additional Context

No response