Method test_outer_join

test/orm/test_generative.py:284–300

Query.outerjoin

(self)

        eq_([User(id=7)], q.all())

    def test_outer_join(self):
        """Query.outerjoin"""

        Order, User, Address = (
            self.classes.Order,
            self.classes.User,
            self.classes.Address,
        )

        session = fixture_session()
        q = (
            session.query(User)
            .outerjoin(User.orders)
            .outerjoin(Order.addresses)
            .filter(sa.or_(Order.id == None, Address.id == 1))
        )  # noqa
        eq_({User(id=7), User(id=8), User(id=10)}, set(q.all()))

    def test_outer_join_count(self):
        """test the join and outerjoin functions on Query"""