René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Listing or returning items with UoW raises sqlalchemy.orm.exc.DetachedInstanceError","articleBody":"Hi. I have a simple `list` endpoint as follows:\r\n\r\n\r\n```python\r\n@app.get(\"/items/\", response_model=list[schemas.Item])\r\nasync def read_items(uow: AbstractUnitOfWork = Depends(get_uow)) -\u003e List[models.Item]:\r\n    with uow:\r\n        items = uow.repo.list()\r\n    return items\r\n```\r\n\r\n`items` is a list of `models.Item` which 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 the `sqlalchemy.orm.exc.DetachedInstanceError` exception. \r\n\r\nI would expect such a dataclass not to mutate since it is not an ORM model.\r\nWhat would be the best approach in this case? \r\n\r\nThe same applies for the creation of an item.\r\n\r\nThanks!","author":{"url":"https://github.com/sevetseh28","@type":"Person","name":"sevetseh28"},"datePublished":"2023-03-22T21:30:19.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/63/code/issues/63"}