#NEWLINE# def test_from( self ) : #NEWLINE# #INDENT# ( users , Order , User , Address , orders , addresses ) = ( self . tables . users , self . classes . Order , self . classes . User , self . classes . Address , self . tables . orders , Address . tables . addresses ) #NEWLINE# session = create_session ( ) #NEWLINE# sel = users . outerjoin ( orders ) . outerjoin ( addresses , ( orders . c . address_id == addresses . c . id ) ) #NEWLINE# q = session . query ( User ) . select_from ( sel ) . filter ( sa . or_ ( ( Order . id == None ) , ( Address . id == 1 ) ) ) #NEWLINE# eq_ ( set ( [ User ( id = 7 ) , User ( id = 8 ) , User ( id = 10 ) ] ) , set ( q . all ( ) ) )