[sqlalchemy] Re: joinedload().load_only() emits 2.0 warning

2021-07-21 Thread Lele Gaifax
Federico Caselli writes: > Updated here https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/2959 Great, thank you! ciao, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it |

Re: [sqlalchemy] async mode and relationship more than one level deep

2021-07-21 Thread 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 r

[sqlalchemy] Re: async mode and relationship more than one level deep

2021-07-21 Thread sector119
s = select( Database ).options( selectinload( Database.person ).options( joinedload(Person.city) ) ) среда, 21 июля 2021 г. в 23:25:05 UTC+3, sector119: > Hello, Mike > > When I want to use some relationship I just set selectinload option on it > like > > s = select(Database).op

[sqlalchemy] async mode and relationship more than one level deep

2021-07-21 Thread sector119
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 Perso