Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

proper SQLmodel approach for Many to Many subqueryLoad #135

Open
8 tasks done
SteffRainville opened this issue Oct 17, 2021 · 0 comments
Open
8 tasks done

proper SQLmodel approach for Many to Many subqueryLoad #135

SteffRainville opened this issue Oct 17, 2021 · 0 comments
Labels
question Further information is requested

Comments

@SteffRainville
Copy link

First Check

  • I added a very descriptive title to this issue.
  • I used the GitHub search to find a similar issue and didn't find it.
  • I searched the SQLModel documentation, with the integrated search.
  • I already searched in Google "How to X in SQLModel" and didn't find any information.
  • I already read and followed all the tutorial in the docs and didn't find an answer.
  • I already checked if it is not related to SQLModel but to Pydantic.
  • I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

  • I commit to help with one of those options 👆

Example Code

@router.get("/user/", response_model=List[UserReadWithClients])
async def user(limit: int = 10, offset: int=0 ):
    with Session(get_engine()) as session:
        statement = select(User).offset(offset).limit(limit).options(subqueryload(User.clients))
        results = session.exec(statement).all()

        return results

Description

I followed the Hero and Team sample it works well but I have a many to many relationship and I get the following message

Parent instance <User at 0x22b6878e880> is not bound to a Session; lazy load operation of attribute 'clients' cannot proceed

I use the sqlAlchem,y orm subquery load option to fix my problem but what is the proper SQLmodel approach for many to many?
(Since it works transparently for 1 to many relationships)

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.4

Python Version

3.9.7

Additional Context

No response

@SteffRainville SteffRainville added the question Further information is requested label Oct 17, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

1 participant