#NEWLINE# @ testing . emits_warning ( '.*empty sequence.*' ) #NEWLINE# def test_literal_in( self ) : #NEWLINE# #INDENT# 'similar to test_bind_in but use a bind with a value.' #NEWLINE# users . insert ( ) . execute ( user_id = 7 , user_name = 'jack' ) #NEWLINE# users . insert ( ) . execute ( user_id = 8 , user_name = 'fred' ) #NEWLINE# users . insert ( ) . execute ( user_id = 9 , user_name = None ) #NEWLINE# s = users . select ( not_ ( literal ( 'john' ) . in_ ( [ ] ) ) ) #NEWLINE# r = s . execute ( ) . fetchall ( ) #NEWLINE# assert ( len ( r ) == 3 )