Hey! Thanks for your great work on this!
I've queried SQLAlchemy Relationships with this library which works just fine, but fails when I use a secondary table. Example:
class Account():
...
practice = relationship("Practice", secondary="user_practice", back_populates="accounts", uselist=False)
class Practice():
...
accounts = relationship("Account", secondary="user_practice", back_populates="practice")
user_practice = Table(
...
Column("account_id", ForeignKey("account.id", ondelete="CASCADE"), primary_key=True, unique=True),
Column("practice_id", ForeignKey("practice.id", ondelete="CASCADE"), primary_key=True, index=True),
)
My query is something like this:
{
accounts {
edges {
node {
practice {
id
}
}
}
}
}
The library tries to look for account_id
in the Practice
table rather than the secondary table. I've also attached part of a stack trace below:
File "/home/vscode/.local/lib/python3.11/site-packages/strawberry_sqlalchemy_mapper/mapper.py", line 420, in resolve
related_objects = await loader.loader_for(relationship).load(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/vscode/.local/lib/python3.11/site-packages/strawberry/dataloader.py", line 251, in dispatch_batch
values = await loader.load_fn(keys)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/workspace/backend/routers/graphql/mapper.py", line 109, in load_fn
loaded = await loader.load_many(keys)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/vscode/.local/lib/python3.11/site-packages/strawberry/dataloader.py", line 251, in dispatch_batch
values = await loader.load_fn(keys)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/vscode/.local/lib/python3.11/site-packages/strawberry_sqlalchemy_mapper/loader.py", line 49, in load_fn
grouped_keys[group_by_remote_key(row)].append(row)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/vscode/.local/lib/python3.11/site-packages/strawberry_sqlalchemy_mapper/loader.py", line 41, in group_by_remote_key
[
File "/home/vscode/.local/lib/python3.11/site-packages/strawberry_sqlalchemy_mapper/loader.py", line 42, in <listcomp>
getattr(row, remote.key)
AttributeError: 'Practice' object has no attribute 'account_id'
Pay now to fund the work behind this issue.
Get updates on progress being made.
Maintainer is rewarded once the issue is completed.
You're funding impactful open source efforts
You want to contribute to this effort
You want to get funding like this too