SQLModel ValueError: hat keinen passenden SQLalchemy -Typ ⇐ Python

[Anonymous]

Angesichts dieser Klassen und 1-zu-N-Beziehungen erhalte ich Kompilierungszeitfehler: ValueError: hat keinen passenden SQLAlchemy-Typ auf die Kategorie.py Feld Todos: List ["toto"] , während der Beziehung Held/Team funktioniert. in beiden Klassen ohne Erfolg.

Code: Select all

# hero.py (works)
class Hero(SQLModel, table=True):
id: int | None = Field(default=None, primary_key=True)
....

team_id: int | None = Field(default=None, foreign_key="team.id")
team: Team | None = Relationship(back_populates="heroes")

# team.py (works)
class Team(SQLModel, table=True):
id: int | None = Field(default=None, primary_key=True)
.....

heroes: list["Hero"] = Relationship(back_populates="team")

# todo.py (does not work)
class Todo(SQLModel, table=True):

id: UUID | None = Field(
default=uuid4(),
primary_key=True,
)

......

category_id: UUID | None = Field(default=None, foreign_key="category.id")
category: Category | None  = Relationship(back_populates="todos")

# category.py  (does not work => ValueError: )
class Category(SQLModel, table=True):
id: UUID | None = Field(default=uuid4(), primary_key=True)
.....

todos: list["Todo"] = Relationship(back_populates="category")
< /code>
Vollständiger Fehlerprotokoll: < /p>
import todo.models.category
File ".../todo/models/category.py", line 9, in 
class Category(SQLModel, table=True):
File ".../lib/python3.12/site-packages/sqlmodel/main.py", line 559, in __new__
col = get_column_from_field(v)
^^^^^^^^^^^^^^^^^^^^^^^^
File "../lib/python3.12/site-packages/sqlmodel/main.py", line 708, in get_column_from_field
sa_type = get_sqlalchemy_type(field)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "../lib/python3.12/site-packages/sqlmodel/main.py", line 697, in get_sqlalchemy_type
raise ValueError(f"{type_} has no matching SQLAlchemy type")
ValueError:  has no matching SQLAlchemy type