#NEWLINE# def test_mixed_entities_two( self ) : #NEWLINE# #INDENT# sess = create_session ( ) #NEWLINE# expected = [ ( 'java' , 'MegaCorp, Inc.' ) , ( 'cobol' , 'Elbonia, Inc.' ) , ( 'c++' , 'MegaCorp, Inc.' ) ] #NEWLINE# eq_ ( sess . query ( Engineer . primary_language , Company . name ) . join ( Company . employees ) . filter ( ( Person . type == 'engineer' ) ) . order_by ( desc ( Engineer . primary_language ) ) . all ( ) , self )