SQLModel Relationships not present in Pydantic model_dump

[konkyrkos]

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

class Club(SQLModel, table=True):  
    __tablename__ = "clubs"

    updated_at: datetime = Field(sa_type=DateTime, sa_column_kwargs={"server_default": utcnow()})
    id: Optional[int] = Field(nullable=True, index=True, unique=True)
    uid: str = Field(nullable=False, sa_type=String, primary_key=True, sa_column_kwargs={"autoincrement":False})
    name: Optional[str] = Field(default=None, nullable=True)

    members: List[Member] = Relationship(back_populates="club", sa_relationship_kwargs=dict(cascade="all"))

class Member(SQLModel, table=True):  # type: ignore
    __tablename__ = "members"
    id: int = Field(nullable=False, sa_type=Integer, primary_key=True, sa_column_kwargs={
        "autoincrement": False
    })
    club_uid: str = Field(nullable=False, foreign_key="clubs.uid", index=True)

    club: "Club" = Relationship(back_populates="members")

Description

We are trying to update to pydantic v2 (from v1) and latest versions of sqlmodel and sqlalchemy. We have two models connected by a relationship. We want to get a model as a dict along with its relationships (as keys of the dict too). We use club.model_dump(inlcude={'id', 'uid', 'name', 'members'}). In the past instead of .model_dump we used .dict() with the same parameters it worked. Now model_dump method does not work and does not return the relationships as keys of the dict. We have tried various options of the method but nothing did the trick.
Any help and interest in the issue is welcome!
Thank you in advance.

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.21

Python Version

3.10.5

Additional Context

No response

[theblazehen]

@konkyrkos Any chance you may have figured this out?

[monchin]

Would you please offer a minimal reproducible example? An example that uses sqlite and can be directly run, and print the result, and you can tell us what result you expected.

I guess this is because sqlmodel dosen't validate data, so maybe #1041 could work, but I need an example to try.