#NEWLINE# def test_send_parameterized_query_to_csv( ) : #NEWLINE# #INDENT# with tmpfile ( 'db' ) as dbfilename : #NEWLINE# #INDENT# with filetext ( 'a,b\n1,2\n3,4' , extension = 'csv' ) as csvfilename : #NEWLINE# #INDENT# t = odo ( csvfilename , ( 'sqlite:///%s::mytable' % dbfilename ) ) #NEWLINE# #UNINDENT# with tmpfile ( '.csv' ) as fn : #NEWLINE# #INDENT# q = t . select ( ( t . c . a == 1 ) ) #NEWLINE# r = odo ( q , fn ) #NEWLINE# assert ( sorted ( odo ( fn , list ) ) == sorted ( odo ( r , list ) ) )