X-Git-Url: https://git.jsancho.org/?p=datasette-pytables.git;a=blobdiff_plain;f=tests%2Ftest_api.py;h=c9ef73ed35047a60b54df97b424684caf443c68f;hp=b48017c0cda65456cf7a27d58eebeb2c84022546;hb=4d7f8328802f0b89a854154194de444e77a3255b;hpb=27c39f638fdb65c330ab6011923a5e1b1040bba1 diff --git a/tests/test_api.py b/tests/test_api.py index b48017c..c9ef73e 100644 --- a/tests/test_api.py +++ b/tests/test_api.py @@ -106,3 +106,69 @@ def test_table_json(app_client): 'idnumber': 5, 'speed': 10.0 }] + +def test_table_not_exists_json(app_client): + assert { + 'ok': False, + 'error': 'Table not found: blah', + 'status': 404, + 'title': None, + } == app_client.get( + '/test_tables/blah.json', gather_request=False + ).json + +def test_table_shape_arrays(app_client): + response = app_client.get( + '/test_tables/%2Fgroup2%2Ftable2.json?_shape=arrays', + gather_request=False + ) + assert [ + [6, 'This is particle: 6', 6, 12.0], + [7, 'This is particle: 7', 7, 14.0], + ] == response.json['rows'][6:8] + +def test_table_shape_objects(app_client): + response = app_client.get( + '/test_tables/%2Fgroup2%2Ftable2.json?_shape=objects', + gather_request=False + ) + assert [{ + 'rowid': 6, + 'identity': 'This is particle: 6', + 'idnumber': 6, + 'speed': 12.0, + }, { + 'rowid': 7, + 'identity': 'This is particle: 7', + 'idnumber': 7, + 'speed': 14.0, + }] == response.json['rows'][6:8] + +def test_table_shape_array(app_client): + response = app_client.get( + '/test_tables/%2Fgroup2%2Ftable2.json?_shape=array', + gather_request=False + ) + assert [{ + 'rowid': 6, + 'identity': 'This is particle: 6', + 'idnumber': 6, + 'speed': 12.0, + }, { + 'rowid': 7, + 'identity': 'This is particle: 7', + 'idnumber': 7, + 'speed': 14.0, + }] == response.json[6:8] + +def test_table_shape_invalid(app_client): + response = app_client.get( + '/test_tables/%2Fgroup2%2Ftable2.json?_shape=invalid', + gather_request=False + ) + assert { + 'ok': False, + 'error': 'Invalid _shape: invalid', + 'status': 400, + 'title': None, + } == response.json