#NEWLINE# def test_simple_into( csv ) : #NEWLINE# #INDENT# tbl = 'testtable' #NEWLINE# with tmpfile ( 'db' ) as filename : #NEWLINE# #INDENT# engine = resource ( ( 'sqlite:///' + filename ) ) #NEWLINE# t = resource ( ( ( ( 'sqlite:///' + filename ) + '::' ) + tbl ) , dshape = ds ) #NEWLINE# odo ( csv , t , dshape = ds ) #NEWLINE# conn = engine . raw_connection ( ) #NEWLINE# cursor = conn . cursor ( ) #NEWLINE# cursor . execute ( "SELECT\n                        name\n                       FROM\n                        sqlite_master\n                       WHERE type='table' and name='{0}';" . format ( tbl ) ) #NEWLINE# sqlite_tbl_names = cursor . fetchall ( ) #NEWLINE# conn . close ( ) #NEWLINE# assert ( sqlite_tbl_names [ 0 ] [ 0 ] == tbl ) #NEWLINE# assert ( odo ( t , list ) == data )