from sqlalchemy.orm import eagerload, joinedload, contains_eager
from temp.t1 import session, Address, User
q = session.query(User).join(Address).filter(
Address.value.like('%jakis%')).options(contains_eager('addresses'))
for x in q:
print(x)
for y in x.addresses:
print(y.value)
# print(x.name, x.fullname)
from temp.t1 import session, Address, User
q = session.query(User).join(Address).filter(Address.value.like('%jakis%'))
for x in q:
print(x)
for y in x.addresses:
print(y.value)
# print(x.name, x.fullname)
from temp.t1 import session, Address, User
q = session.query(User, Address).join(Address, User.id == Address.user_id)
for x in q:
print(x)
print(x[0], x[1])
# print(x.name, x.fullname)
from sqlalchemy.orm import eagerload, joinedload, contains_eager, subqueryload
from temp.t1 import session, Address, User
q = session.query(User).join(Address).filter(
Address.value.like('%jakis%')).options(subqueryload('addresses'))
for x in q:
print(x)
for y in x.addresses:
print(y.value)
# print(x.name, x.fullname)
from temp.t1 import session, Address, User
q = session.query(User.name, User.id)
for x in q:
print(x)
# print(x.name, x.fullname)
from temp.t1 import session, Address, User
q = session.query(User)
for x in q:
print(x)
print(x.name, x.fullname)
from temp.t1 import session, User
q = session.query(User).filter(User.id == 2)
for x in q:
print("USER!!")
print(x.id)
print(x.name)
print(x.fullname)