Activity

1. HenryDashwood

   added

   questionFurther information is requestedFurther information is requested

   on Jul 17, 2022
2. antont commented on Jul 18, 2022

   

   antont

   on Jul 18, 2022

   More actions

   I think it can only be a version difference, maybe you have different versions of the libraries on the different machines. Maybe different SQLAlchemy and you hit this, #315

   Reacted by Henry Dashwood
3. HenryDashwood commented on Aug 25, 2022

   

   HenryDashwood

   on Aug 25, 2022

   Author

   More actions

   Spent this evening putting together a minimal viable reproduction of the error and just saw your comment. Downgrading SQLAlchemy to 1.4.35 does indeed resolve the issue.

   In case it's useful, running pytest on the code below will pass on MacOS (M1) but fail on Ubuntu. There is a much smaller and cleaner code example in the issue you linked to though

   from typing import List, Optional
   
   import pytest
   from fastapi import Depends, FastAPI
   from fastapi.testclient import TestClient
   from sqlmodel import Field, Relationship, Session, SQLModel, create_engine, select
   from sqlmodel.pool import StaticPool
   
   
   app = FastAPI()
   
   engine = create_engine("sqlite://", echo=False, connect_args={"check_same_thread": False})
   
   
   def get_session():
       with Session(engine) as session:
           yield session
   
   
   class SourceBase(SQLModel):
       name: Optional[str] = Field(nullable=True)
   
   
   class Source(SourceBase, table=True):
       id: Optional[int] = Field(default=None, primary_key=True)
       articles: List["Article"] = Relationship(back_populates="source")
   
   
   class SourceRead(SourceBase):
       id: int
   
   
   class ArticleBase(SQLModel):
       title: str = Field(nullable=False)
       source_id: Optional[int] = Field(default=None, foreign_key="source.id")
   
   
   class ArticleCreate(SQLModel):
       title: str = Field(nullable=False)
       source_name: str = Field(nullable=False)
   
   
   class Article(ArticleBase, table=True):
       id: Optional[int] = Field(default=None, primary_key=True)
       source: Source = Relationship(back_populates="articles")
   
   
   class ArticleGet(ArticleBase):
       id: int
   
   
   class ArticleGetWithSource(ArticleGet):
       source: Optional[SourceRead] = None
   
   
   @pytest.fixture(name="session")
   def session_fixture():
       engine = create_engine("sqlite://", connect_args={"check_same_thread": False}, poolclass=StaticPool)
       SQLModel.metadata.create_all(engine)
       with Session(engine) as session:
           yield session
   
   
   @pytest.fixture(name="client")
   def client_fixture(session: Session):
       def get_session_override():
           return session
   
       app.dependency_overrides[get_session] = get_session_override
       client = TestClient(app)
   
       yield client
       app.dependency_overrides.clear()
   
   
   @app.post("/add", response_model=ArticleGetWithSource)
   def add_article(*, session: Session = Depends(get_session), payload: ArticleCreate) -> Article:
       source = session.exec(select(Source).where(Source.name == payload.source_name)).first()
       source_id = source.id if source else None
       article = Article(title=payload.title, source_id=source_id)
       session.add(article)
       session.commit()
       return session.exec(select(Article).where(Article.id == article.id)).first()
   
   
   def test_create_article(session: Session, client: TestClient):
       source = Source(name="The Way Of The Dodo")
       session.add(source)
       session.commit()
   
       response = client.post("/add", json={"title": "All This Useless Beauty", "source_name": "The Way Of The Dodo"})
       data = response.json()
   
       assert response.status_code == 200
       assert data["title"] == "All This Useless Beauty"
       assert data["source_id"] is not None
       assert data["id"] is not None
       assert data["source"] is not None
       assert data["source"]["id"] is not None
       assert data["source"]["name"] == "The Way Of The Dodo"
       assert data["id"] == data["source"]["id"]
4. YuriiMotov

   closed this as completedon Aug 8, 2025