#NEWLINE# @ testing . requires . except_ #NEWLINE# @ testing . fails_on ( 'sqlite' , "Can't handle this style of nesting" ) #NEWLINE# def test_except_style1( self ) : #NEWLINE# #INDENT# e = except_ ( union ( select ( [ t1 . c . col3 , t1 . c . col4 ] ) , select ( [ t2 . c . col3 , t2 . c . col4 ] ) , select ( [ t3 . c . col3 , t3 . c . col4 ] ) ) , select ( [ t2 . c . col3 , t2 . c . col4 ] ) ) #NEWLINE# wanted = [ ( 'aaa' , 'aaa' ) , ( 'aaa' , 'ccc' ) , ( 'bbb' , 'aaa' ) , ( 'bbb' , 'bbb' ) , ( 'ccc' , 'bbb' ) , ( 'ccc' , 'ccc' ) ] #NEWLINE# found = self . _fetchall_sorted ( e . alias ( ) . select ( ) . execute ( ) ) #NEWLINE# eq_ ( found , wanted )