MCPcopy
hub / github.com/sqlalchemy/sqlalchemy / test_outerjoin_x1

Method test_outerjoin_x1

test/sql/test_query.py:1486–1494  ·  view source on GitHub ↗

Outer joins t1->t2.

(self)

Source from the content-addressed store, hash-verified

1484 self.assertRows(expr, [(10, 20), (11, 21)])
1485
1486 def test_outerjoin_x1(self):
1487 """Outer joins t1->t2."""
1488 t1, t2, t3 = self.tables("t1", "t2", "t3")
1489
1490 for criteria in (t2.c.t2_id == t3.c.t2_id, t3.c.t2_id == t2.c.t2_id):
1491 expr = select(t1.c.t1_id, t2.c.t2_id).select_from(
1492 t1.join(t2).join(t3, criteria)
1493 )
1494 self.assertRows(expr, [(10, 20)])
1495
1496 def test_outerjoin_x2(self):
1497 """Outer joins t1->t2,t3."""

Callers

nothing calls this directly

Calls 4

assertRowsMethod · 0.95
selectFunction · 0.90
select_fromMethod · 0.45
joinMethod · 0.45

Tested by

no test coverage detected