MCPcopy
hub / github.com/sqlalchemy/sqlalchemy / test_to_query_session

Method test_to_query_session

test/ext/test_baked.py:773–792  ·  view source on GitHub ↗
(self)

Source from the content-addressed store, hash-verified

771 eq_(result, [(2,), (3,), (4,)])
772
773 def test_to_query_session(self):
774 User = self.classes.User
775 Address = self.classes.Address
776
777 sub_bq = self.bakery(lambda s: s.query(User.name))
778 sub_bq += lambda q: q.filter(User.id == Address.user_id).correlate(
779 Address
780 )
781
782 main_bq = self.bakery(
783 lambda s: s.query(Address.id, sub_bq.to_query(s).scalar_subquery())
784 )
785 main_bq += lambda q: q.filter(
786 sub_bq.to_query(q).scalar_subquery() == "ed"
787 )
788 main_bq += lambda q: q.order_by(Address.id)
789
790 sess = fixture_session()
791 result = main_bq(sess).all()
792 eq_(result, [(2, "ed"), (3, "ed"), (4, "ed")])
793
794 def test_to_query_args(self):
795 User = self.classes.User

Callers

nothing calls this directly

Calls 10

fixture_sessionFunction · 0.90
eq_Function · 0.90
bakeryMethod · 0.80
to_queryMethod · 0.80
queryMethod · 0.45
correlateMethod · 0.45
filterMethod · 0.45
scalar_subqueryMethod · 0.45
order_byMethod · 0.45
allMethod · 0.45

Tested by

no test coverage detected