X-Git-Url: https://git.jsancho.org/?p=datasette-pytables.git;a=blobdiff_plain;f=tests%2Ftest_api.py;h=c9ef73ed35047a60b54df97b424684caf443c68f;hp=72d14b18e4dca6c1a720649d0221818cb57c76e6;hb=4d7f8328802f0b89a854154194de444e77a3255b;hpb=5f5e1e533d98b36bbb159487984d5d95b2ff3ae2 diff --git a/tests/test_api.py b/tests/test_api.py index 72d14b1..c9ef73e 100644 --- a/tests/test_api.py +++ b/tests/test_api.py @@ -116,3 +116,59 @@ def test_table_not_exists_json(app_client): } == 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