#NEWLINE# def test_read_nonsequential_verbose( spawnbdb ) : #NEWLINE# #INDENT# c = c #NEWLINE# with read_data ( ) as fname : #NEWLINE# #INDENT# c . sendexpectcmd ( ( '.read %s -v' % ( fname , ) ) ) #NEWLINE# c . expect_lines ( [ 'bayeslite> -- do something that fails (should not kick us out)' , 'bayeslite> .csv dha' , 'Usage: .csv <table> </path/to/data.csv>' , 'bayeslite> -- create a table properly' , ( 'bayeslite> .csv dha %s' % ( DHA_CSV , ) ) , 'bayeslite> -- single line BQL' , 'bayeslite> SELECT name FROM dha LIMIT 2;' , '      NAME' , '----------' , 'Abilene TX' , '  Akron OH' , 'bayeslite> -- multiline BQL. 2nd line is space indented; 3rd line is tabbed.' , 'bayeslite> SELECT name FROM dha' , '' , '               ORDER BY name ASC' , '' , '               LIMIT 5;' , '             NAME' , '-----------------' , '       Abilene TX' , '         Akron OH' , 'Alameda County CA' , '        Albany GA' , '        Albany NY' ] ) #NEWLINE# c . expect_prompt ( )