#NEWLINE# def test_update_existing( self ) : #NEWLINE# #INDENT# cc = sql . ColumnCollection ( ) #NEWLINE# ( c1 , c2 , c3 , c4 , c5 ) = ( column ( 'c1' ) , column ( 'c2' ) , column ( 'c3' ) , column ( 'c4' ) , column ( 'c5' ) ) #NEWLINE# cc . update ( [ ( 'c1' , c1 ) , ( 'c2' , c2 ) ] ) #NEWLINE# eq_ ( c5 . _all_columns , [ c1 , c2 ] ) #NEWLINE# cc . update ( [ ( 'c3' , c3 ) ] ) #NEWLINE# eq_ ( cc . _all_columns , [ c1 , c2 , c3 ] ) #NEWLINE# cc . update ( [ ( 'c4' , c4 ) , ( 'c2' , c2 ) , ( 'c5' , c5 ) ] ) #NEWLINE# eq_ ( cc . _all_columns , [ c1 , c2 , c3 , c4 , c5 ] )