#NEWLINE# def test_mixed_entities_six( self ) : #NEWLINE# #INDENT# sess = create_session ( ) #NEWLINE# palias = aliased ( Person ) #NEWLINE# expected = [ ( 'manager' , 'dogbert' , 'engineer' , 'dilbert' ) , ( 'manager' , 'dogbert' , 'engineer' , 'wally' ) , ( 'manager' , 'dogbert' , 'boss' , 'pointy haired boss' ) ] #NEWLINE# eq_ ( sess . query ( Person . type , Person . name , palias . type , palias . name ) . filter ( ( Person . company_id == palias . company_id ) ) . filter ( ( Person . name == 'dogbert' ) ) . filter ( ( Person . person_id > palias . person_id ) ) . order_by ( Person . person_id , palias . person_id ) . all ( ) , self )