#NEWLINE# def test_where_with_between( self ) : #NEWLINE# #INDENT# t = self . con . table ( 'alltypes' ) #NEWLINE# what = t . filter ( [ ( t . a > 0 ) , t . f . between ( 0 , 1 ) ] ) #NEWLINE# result = to_sql ( expected ) #NEWLINE# expected = 'SELECT *\nFROM alltypes\nWHERE `a` > 0 AND\n      `f` BETWEEN 0 AND 1' #NEWLINE# assert ( result == expected )