Thank You, works like a charm четверг, 22 июля 2021 г. в 00:26:57 UTC+3, Mike Bayer:
> you need to chain those like: > > selectinload(Database.person).selectinload(Person.city) > > docs: > > > https://docs.sqlalchemy.org/en/14/orm/loading_relationships.html#relationship-loading-with-loader-options > > > > On Wed, Jul 21, 2021, at 4:25 PM, sector119 wrote: > > Hello, Mike > > When I want to use some relationship I just set selectinload option on it > like > > s = select(Database).options(selectinload(Database.person)) > > Here Database.person is relationship with Person model > > But what to do if I want to access some relationship of Person model? For > example Person.city, > > I got errors when I set selectinload(Database.person.city) or > selectinload(Person.city) > > Thank You > > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/4a389836-c41c-4db5-a427-75e87a39ff7bn%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/4a389836-c41c-4db5-a427-75e87a39ff7bn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/a7842e68-c737-4989-b033-8ee1543bc8ben%40googlegroups.com.