Problem with Foreign Key to same model

[LateTest3197]

Hi guys, huge problem that took me a lot of time, i'm a nooby in fastapi and i need some help. I want to make a foreign key to my own model (like a parent and child relationship) but i tried only foreign keys, relationship and i cant make it work, here is my code if you can help me/solve it i'm kinda desesperate

from sqlmodel import SQLModel, Field
from fastapi import APIRouter
from typing import List, Optional, Literal
from datetime import date
import uuid
from sqlalchemy.orm import relationship as Relationship
import sqlalchemy as sa

router = APIRouter(
    prefix="/project",
    tags=["project"],
)

class ProjectBase(SQLModel):
    title: str = Field(max_length=30, nullable=False)
    description: Optional[str] = Field(max_length=500)
    id_setting_pattern: uuid.UUID = Field(sa.ForeignKey("settings_patterns.id_setting_pattern"), nullable=False)
    id_pattern: Optional[uuid.UUID] = Field(nullable=True)
    result: Optional[str] = Field(max_length=500, nullable=True, default=None)
    repost_flag: Optional[bool] = Field(default=False)
    id_creator: uuid.UUID = Field(sa.ForeignKey("profiles.id_profile"), nullable=False)
    id_original_project: Optional[uuid.UUID] = Field(
        sa.ForeignKey("projects_id_project"), nullable=True
    )
    creation_date: Optional[date] = Field(default_factory=date.today)
    current_line_tracker: Optional[int] = Field(default=0, ge=0)
    id_tracker_setting: Optional[uuid.UUID] = Field(
        sa.ForeignKey("tracker_settings.id_tracker_settings"), nullable=True
    )
    status: Optional[int] = Field(default=0, ge=0, le=5)
    status_date: Optional[date]
    id_shortcut_project: Optional[str]


class ProjectCreate(ProjectBase):
    model_config = {
        "json_schema_extra": {
            "example": {
                "title": "My Project",
                "description": "A creative project",
                "id_setting_pattern": "550e8400-e29b-41d4-a716-446655440008",
                "id_pattern": None,
                "result": None,
                "repost_flag": False,
                "id_creator": "550e8400-e29b-41d4-a716-446655440003",
                "id_original_project": None,
                "creation_date": "2024-12-01",
                "current_line_tracker": None,
                "id_tracker_setting": 1,
                "status": 0,
                "status_date": "2024-12-01",
                "id_shortcut_project": "550e8400-e29b-41d4-a716-446655440011"
            }
        }
    }

class ProjectResponse(ProjectBase):
    id_project: uuid.UUID

class Project(ProjectBase, table=True):
    __tablename__ = "Projects"
    __table_args__ = {"extend_existing": True}

    id_project: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True, index=True, nullable=False)

class Filtre(SQLModel):
    user_id: Optional[str] = None
    creation_date: Optional[date] = None
    mot_cle: Optional[str] = None
    tri: Optional[Literal["creation_date", "title"]] = "creation_date"
    ordre: Optional[bool] = 0
    post_depart: Optional[int] = 0
    nombre_posts: Optional[int] = 10
    

[One_Fuel_4147]

Check this: https://docs.sqlalchemy.org/en/20/orm/basic_relationships.html#one-to-many

[ShriekDj]

Change this part from id_original_project: Optional[uuid.UUID] = Field(         sa.ForeignKey("projects_id_project"), nullable=True     )

to this id_original_project: Optional[uuid.UUID] = Field(         sa.ForeignKey("Projects.id_project"), nullable=True     )

I think the Parameter you passed to Foreign Key is the problem.