def test_readonly_database(settings, database):
"Test setting a database to readonly."
session = settings["session"]
url = settings["url"]
# Set to readonly.
response = session.post(url + "/readonly")
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["db_schema"])
# These items are now True.
assert data["readonly"]
assert data["hashes"]
# Fail to delete the database.
response = session.delete(url)
assert response.status_code == http.client.UNAUTHORIZED
# Set to readwrite.
response = session.post(url + "/readwrite")
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["db_schema"])
# These items are now False.
assert not data["readonly"]
assert not data["hashes"]
def test_query_database(settings, database):
"Test querying a database from a Sqlite3 file."
session = settings["session"]
# Query schema.
response = session.get(f"{settings['BASE_URL']}/api/schema/query/input")
assert response.status_code == http.client.OK
query_input_schema = response.json()
response = session.get(f"{settings['BASE_URL']}/api/schema/query/output")
assert response.status_code == http.client.OK
query_output_schema = response.json()
# Query.
query = {"select": f'r1 as "r"', "from": "t1"}
utils.validate_schema(query, query_input_schema)
response = session.post(f"{settings['BASE_URL']}/api/db/test/query",
json=query)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, query_output_schema)
# Bad query.
query = {"select": None, "from": "t1"}
response = session.post(f"{settings['BASE_URL']}/api/db/test/query",
json=query)
assert response.status_code == http.client.BAD_REQUEST
def test_root(settings):
"Test the root and some links from it."
session = settings["session"]
response = session.get(f"{settings['BASE_URL']}/api")
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["root_schema"])
assert data["version"] == dbshare.__version__
# Loop over schema.
for href in utils.get_hrefs(data["schema"]):
response = session.get(href)
assert response.status_code == http.client.OK
def test_databases(settings):
"Test access to the databases."
session = settings["session"]
# Check the sets of databases.
response = session.get(f"{settings['BASE_URL']}/api")
assert response.status_code == http.client.OK
data = response.json()
assert set(data["databases"]) == {"public", "owner"}
for category in data["databases"]:
href = data["databases"][category]["href"]
response = session.get(href)
assert response.status_code == http.client.OK
utils.validate_schema(response.json(), settings["dbs_schema"])
def test_users(settings):
"Test access to the user accounts."
session = settings["session"]
# Users, check schema.
response = session.get(f"{settings['BASE_URL']}/api/users/all")
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["users_schema"])
# A user, check schema.
response = session.get(data["users"][0]["href"])
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["user_schema"])
def test_edit_database(settings, database):
"Test editing database metadata."
session = settings["session"]
url = settings["url"]
# Edit the title.
title = "New title"
response = session.post(url, json={"title": title})
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["db_schema"])
assert data.get("title") == title
# Edit the description.
description = "A description"
response = session.post(url, json={"description": description})
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["db_schema"])
assert data.get("description") == description
# Same title as before.
assert data.get("title") == title
# Rename the database.
name = "test2"
response = session.post(url, json={"name": name})
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["db_schema"])
assert data["$id"].endswith(name)
# Delete the renamed database.
response = session.delete(response.url)
assert response.status_code == http.client.NO_CONTENT
def test_index(settings, database):
"Test index for a table."
session = settings["session"]
# Create the table with an index.
table_spec_copy = TABLE_SPEC.copy()
table_spec_copy["indexes"] = [{"unique": True, "columns": ["t"]}]
response = session.put(f"{settings['BASE_URL']}/api/table/test/t2",
json=table_spec_copy)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["table_schema"])
assert len(data["indexes"]) == 1
# Add rows.
url = f"{settings['BASE_URL']}/api/table/test/t2/insert"
data = {
"data": [
{
"i": 1,
"t": "some text",
"r": 1.43
},
{
"i": 2,
"t": "Blah",
"r": 0.43
},
]
}
response = session.post(url, json=data)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["table_schema"])
assert data["nrows"] == 2
# Attempt to add a row that violates the index unique constraint.
data = {"data": [{"i": 3, "t": "some text", "r": 1.0e3}]}
response = session.post(url, json=data)
assert response.status_code == http.client.BAD_REQUEST
def test_view(settings, database):
"Test creating and using a view."
session = settings["session"]
# Create a view.
view_spec = {
"name": "v1",
"query": {
"from": "t1",
"select": "r1",
"where": "i1>=10"
},
}
utils.validate_schema(view_spec, settings["view_create_schema"])
response = session.put(f"{settings['BASE_URL']}/api/view/test/v1",
json=view_spec)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["view_schema"])
# Check the rows of the view.
rows_url = data["rows"]["href"]
response = session.get(rows_url)
data = response.json()
utils.validate_schema(data, settings["rows_schema"])
assert data["nrows"] == 2
assert len(data["data"]) == data["nrows"]
# Insert a row into the table, check that view content changes accordingly.
row = {"data": [{"i": 6, "r1": 1.02, "i1": 3091, "t1": "blopp"}]}
response = session.post(f"{settings['BASE_URL']}/api/table/test/t1/insert",
json=row)
data = response.json()
utils.validate_schema(data, settings["table_schema"])
response = session.get(rows_url)
data = response.json()
utils.validate_schema(data, settings["rows_schema"])
assert data["nrows"] == 3
assert len(data["data"]) == data["nrows"]
# Fail attempt to create a view with uppercase name of already existing view.
view_spec = {
"name": "V1",
"query": {
"from": "t1",
"select": "r1",
"where": "i1>=10"
},
}
utils.validate_schema(view_spec, settings["view_create_schema"])
response = session.put(f"{settings['BASE_URL']}/api/view/test/V1",
json=view_spec)
assert response.status_code == http.client.BAD_REQUEST
# Delete the view.
response = session.delete(f"{settings['BASE_URL']}/api/view/test/v1")
assert response.status_code == http.client.NO_CONTENT
def test_csv(settings, database):
"Test CSV operations on a table."
session = settings["session"]
# Create the table.
table_url = f"{settings['BASE_URL']}/api/table/test/t2"
response = session.put(table_url, json=TABLE_SPEC)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["table_schema"])
rows = [
{
"i": 1,
"t": "some text",
"r": 1.43
},
{
"i": 2,
"t": "Blah",
"r": 0.43
},
{
"i": 3,
"t": "blopp",
"r": 109.1
},
{
"i": 4,
"t": "more",
"r": -0.213
},
]
textfile = io.StringIO()
writer = csv.DictWriter(textfile, list(rows[0].keys()))
writer.writeheader()
writer.writerows(rows)
headers = {"Content-Type": "text/csv"}
response = session.post(f"{table_url}/insert",
data=textfile.getvalue(),
headers=headers)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["table_schema"])
assert data["nrows"] == len(rows)
# Try inserting a bad row: no primary key.
rows = [
{
"t": "missing primary key",
"r": 1.43
},
]
textfile = io.StringIO()
writer = csv.DictWriter(textfile, list(rows[0].keys()))
writer.writeheader()
writer.writerows(rows)
response = session.post(f"{table_url}/insert",
data=textfile.getvalue(),
headers=headers)
assert response.status_code == http.client.BAD_REQUEST
# Try inserting a bad row: missing NOT NULL item.
rows = [
{
"i": 5,
"t": "missing primary key"
},
]
textfile = io.StringIO()
writer = csv.DictWriter(textfile, list(rows[0].keys()))
writer.writeheader()
writer.writerows(rows)
response = session.post(f"{table_url}/insert",
data=textfile.getvalue(),
headers=headers)
assert response.status_code == http.client.BAD_REQUEST
# Insert more data.
rows = [
{
"i": 5,
"t": "yet more text",
"r": 1.0e5
},
{
"i": 6,
"t": "a name",
"r": -0.001
},
]
textfile = io.StringIO()
writer = csv.DictWriter(textfile, list(rows[0].keys()))
writer.writeheader()
writer.writerows(rows)
response = session.post(f"{table_url}/insert",
data=textfile.getvalue(),
headers=headers)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["table_schema"])
assert data["nrows"] == 6
def test_table(settings, database):
"Test creating, modifying and deleting a table."
session = settings["session"]
# Create a table.
table_url = f"{settings['BASE_URL']}/api/table/test/t2"
response = session.put(table_url, json=TABLE_SPEC)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["table_schema"])
# Check the created table.
assert len(data["columns"]) == len(TABLE_SPEC["columns"])
assert data["title"] == TABLE_SPEC["title"]
lookup = dict([(c["name"], c) for c in TABLE_SPEC["columns"]])
for column in data["columns"]:
assert column["name"] in lookup
assert column["type"] == lookup[column["name"]]["type"]
# PRIMAY KEY implies NOT NULL.
lookup = dict([(c["name"], c) for c in data["columns"]])
assert lookup["i"]["primarykey"]
assert lookup["i"]["notnull"]
# Insert rows into the table.
url = f"{settings['BASE_URL']}/api/table/test/t2/insert"
row = {"data": [{"i": 1, "t": "stuff", "r": 1.2345}]}
response = session.post(url, json=row)
data = response.json()
utils.validate_schema(data, settings["table_schema"])
assert data["nrows"] == 1
row = {"data": [{"i": 2, "t": "another", "r": 3}]}
response = session.post(url, json=row)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["table_schema"])
assert data["nrows"] == 2
row = {"data": [{"i": 3, "r": -0.45}]}
response = session.post(url, json=row)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["table_schema"])
assert data["nrows"] == 3
row_3 = {"i": 4, "t": "multirow", "r": -0.45}
rows = {"data": [row_3, {"i": 5, "t": "multirow 2", "r": 1.2e4}]}
response = session.post(url, json=rows)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["table_schema"])
assert data["nrows"] == 5
# Try to insert invalid data of different kinds.
row = {"data": [{"i": 3, "t": "primary key clash", "r": -0.1}]}
response = session.post(url, json=row)
assert response.status_code == http.client.BAD_REQUEST
row = {"data": [{"i": 8, "t": "missing value"}]}
response = session.post(url, json=row)
assert response.status_code == http.client.BAD_REQUEST
row = {"data": [{"i": 9, "t": "wrong type", "r": "string!"}]}
response = session.post(url, json=row)
assert response.status_code == http.client.BAD_REQUEST
# Get the table data.
response = session.get(table_url)
assert response.status_code == http.client.OK
data = response.json()
utils.validate_schema(data, settings["table_schema"])
assert data["nrows"] == 5
# Get the rows and compare one of them.
url = data["rows"]["href"]
response = session.get(url)
data = response.json()
utils.validate_schema(data, settings["rows_schema"])
assert data["nrows"] == 5
assert len(data["data"]) == data["nrows"]
assert data["data"][3] == row_3
# Empty the table.
url = f"{settings['BASE_URL']}/api/table/test/t2/empty"
response = session.post(url)
assert response.status_code == http.client.OK
response = session.get(response.url)
data = response.json()
assert data["nrows"] == 0