def test_outer_join(self):

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


        session = create_session()
        q = (session.query(User).outerjoin('orders', 'addresses').
             filter(sa.or_(Order.id == None, Address.id == 1)))
        eq_(set([User(id=7), User(id=8), User(id=10)]),
            set(q.all()))
Query.outerjoin
dataset/ETHPy150Open zzzeek/sqlalchemy/test/orm/test_generative.py/RelationshipsTest.test_outer_join