X-Git-Url: https://git.jsancho.org/?p=datasette-pytables.git;a=blobdiff_plain;f=tests%2Ftest_api.py;h=80e379c93d81595d7584647c1654b6390eaef7a7;hp=c1938b1ddd8a059a0b523004dfd525030ddd6f43;hb=745f744d01ebe1eff321fb70c580eac1f8b3ad4f;hpb=651f186deeb4c545cbeffefc1d8296603cfb9a11 diff --git a/tests/test_api.py b/tests/test_api.py index c1938b1..80e379c 100644 --- a/tests/test_api.py +++ b/tests/test_api.py @@ -88,20 +88,20 @@ def test_custom_complex_sql(app_client): response = app_client.get( '/test_tables.json?' + urlencode({ 'sql': 'select identity from [/group1/table1] where speed > 100 and idnumber < 55', - '_shape': 'objects' + '_shape': 'objects', }), ) data = response.json assert { 'sql': 'select identity from [/group1/table1] where speed > 100 and idnumber < 55', - 'params': {} + 'params': {}, } == data['query'] assert 4 == len(data['rows']) assert [ {'identity': 'This is particle: 51'}, {'identity': 'This is particle: 52'}, {'identity': 'This is particle: 53'}, - {'identity': 'This is particle: 54'} + {'identity': 'This is particle: 54'}, ] == data['rows'] assert ['identity'] == data['columns'] assert 'test_tables' == data['database'] @@ -111,19 +111,19 @@ def test_custom_pytables_sql(app_client): response = app_client.get( '/test_tables.json?' + urlencode({ 'sql': 'select identity from [/group1/table1] where (speed > 100) & (speed < 500)', - '_shape': 'objects' - }), + '_shape': 'objects', + }), ) data = response.json assert { 'sql': 'select identity from [/group1/table1] where (speed > 100) & (speed < 500)', - 'params': {} + 'params': {}, } == data['query'] assert 199 == len(data['rows']) assert [ {'identity': 'This is particle: 51'}, {'identity': 'This is particle: 52'}, - {'identity': 'This is particle: 53'} + {'identity': 'This is particle: 53'}, ] == data['rows'][:3] assert ['identity'] == data['columns'] assert 'test_tables' == data['database']