Enums are not autocompleted & gives error

[jd-solanki]

First Check

• I added a very descriptive title to this issue.
• I used the GitHub search to find a similar issue 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

class EnumAccessStatus(Enum):
    PENDING = "pending"
    APPROVED = "approved"
    REJECTED = "rejected"
    REVOKED = "revoked"

class Temp(SQLModel):
    py_type: EnumAccessStatus
    access_status = Field(
        sa_column=Column(
            sqlAlchemyEnum(EnumAccessStatus)
        )
    )

Description

• Create an instance of Temp class by Temp() and hit space between brackets to get autocompletion
• Even If we add parameter by our self Temp(py_type=EnumAccessStatus.REJECTED, access_status=EnumAccessStatus.REJECTED) it throws "No parameter named access_status"

Operating System

Linux

Operating System Details

Ubuntu 21.10 64-bit

SQLModel Version

0.0.6

Python Version

3.10.2

Additional Context

[masreplay]

As mentioned in python docs you have to inherit from both Enum and the value that will set in orinal like str

class MyEnum(str, Enum):
    Pending= "pendding"

[jd-solanki]

It is still not working.

[YuriiMotov]

it throws "No parameter named access_status"

This is because you didn't specify the type of this parameter.

sa_column is only for SQLAlchemy. You still need to add type annotations for this field for Pydantic to be able to create the init method:

    access_status: EnumAccessStatus = Field(
        sa_column=Column(
            sqlAlchemyEnum(EnumAccessStatus)
        )
    )