ManyToMany fields for multiple py files

[hgalytoby]

Example Code

api.py

from sqlmodel import Field, Relationship

from app.models.link import ApiLinkModel


class ApiBase(SQLModel):
    ...


class ApiModel(ApiBase, table=True):
    uri: str = Field(
        title='Api',
        description='Api',
        max_length=128,
        nullable=False,
    )
    description: str = Field(
        title='description',
        description='description',
        max_length=32,
        nullable=False,
    )
    role_list: list['RoleModel'] = Relationship(  # type: ignore
        back_populates='api_list',
        link_model=ApiLinkModel,
        sa_relationship_kwargs={'lazy': 'selectin'},
    )

link.py

from sqlmodel import Field, Relationship


class ApiLinkBase(SQLModel):
    api_id: UUID = Field(
        title='Api ID',
        description='Api ID',
        foreign_key='Api.id',
        primary_key=True,
    )
    role_id: UUID = Field(
        title='角色 ID',
        description='角色 ID',
        foreign_key='Role.id',
        primary_key=True,
    )

    api: ApiModel = Relationship(
        back_populates='role_list',
    )
    role: RoleModel = Relationship(
        back_populates='api_list',
    )


class ApiLinkModel(ApiLinkBase, table=True):
    __table_args__ = {
        'comment': 'Api, Role',
    }

role.py

from sqlmodel import Field, Relationship

from app.models.link import ApiLinkModel


class RoleBase(SQLModel):
    name: str = Field(
        title='rule name',
        description='rule name',
        max_length=32,
        unique=True,
    )

class RoleModel(
    BaseCreatedAtModel,
    BaseUpdatedAtModel,
    RoleBase,
    BaseUUIDModel,
    table=True,
):
    is_protected: bool = Field(default=False, description='is_protected')
    api_list: list['ApiModel'] = Relationship(  # type: ignore
        back_populates='role_list',
        link_model=ApiLinkModel,
        sa_relationship_kwargs={'lazy': 'selectin'},
    )

Description

I would like to split the many-to-many models into different .py.

Error

 File "C:\Users\duduru\AppData\Local\pypoetry\Cache\virtualenvs\backend-Clwg8yIO-py3.10\lib\site-packages\sqlmodel\main.py", line 658, in get_sqlalchemy_type
    if issubclass(type_, Enum):
TypeError: issubclass() arg 1 must be a class

I am using pydantic 1.10 with SQLModel 0.0.8.

Now I upgraded to pydantic 2.8 with SQLModel 0.0.21 and I have problems.

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.21

Python Version

3.10.11

Additional Context

File "C:\Code\Python\ACS\backend\app\models\link.py", line 30, in <module>
    class ApiLinkModel(BaseCreatedAtModel, ApiLinkBase, table=True):
  File "C:\Users\duduru\AppData\Local\pypoetry\Cache\virtualenvs\backend-Clwg8yIO-py3.10\lib\site-packages\sqlmodel\main.py", line 559, in __new__
    col = get_column_from_field(v)
  File "C:\Users\duduru\AppData\Local\pypoetry\Cache\virtualenvs\backend-Clwg8yIO-py3.10\lib\site-packages\sqlmodel\main.py", line 710, in get_column_from_field
    sa_type = get_sqlalchemy_type(field)
  File "C:\Users\duduru\AppData\Local\pypoetry\Cache\virtualenvs\backend-Clwg8yIO-py3.10\lib\site-packages\sqlmodel\main.py", line 658, in get_sqlalchemy_type
    if issubclass(type_, Enum):
TypeError: issubclass() arg 1 must be a class