Repository navigation
Listing or returning items with UoW raises sqlalchemy.orm.exc.DetachedInstanceError #63
Description
Activity
Maybe using
schemas.Itemas a DTO like this, and convert:def item_to_schema(item: models.Item) -> schemas.Item: return schemas.Item(id=item.id, title=item.title, description=item.description)
@app.get("/items/", response_model=list[schemas.Item]) async def read_items(uow: AbstractUnitOfWork = Depends(get_uow)) -> List[schemas.Item]: with uow: items = uow.repo.list() # Convert items to schemas.Item DTOs items_dtos = [item_to_schema(item) for item in items] return items_dtos
wdyt?
A little late, but for future readers:
You have multiple options in this case, including the one @sevetseh28 provided. Other options:
- Return your list inside the
withblock - Set
expire_on_commit=Falsewhen creating the session. This will disable the reloading of attributes after commit. I think it's safe to disable it because a handler shouldn't reload anything after commiting anyways as the aggregate must be transactionally consistent and complete before committing. - Use a view as described in Chapter 12
- Return your list inside the
Hi. I have a simple
listendpoint as follows:itemsis a list ofmodels.Itemwhich is my domain model (dataclass). But when exiting the uow (closing the session) the items' attributes are refreshed by the ORM automatically and I get thesqlalchemy.orm.exc.DetachedInstanceErrorexception.I would expect such a dataclass not to mutate since it is not an ORM model.
What would be the best approach in this case?
The same applies for the creation of an item.
Thanks!