def test_update(self):
store = SQLiteDataStore(
{"name": "test.db", "table": "address"},
ApiModel)
for i in range(100):
store.create({"name": "bob", "age": 34})
self.assertEqual(
store.update(
{"name": "bob", "age": 34, "id": 34},
{"name": "boby mc gee"}
), {"name": "boby mc gee", "age": 34, "id": 34})
self.assertEqual(
store.update(
{"name": "bob", "age": 35, "id": 35},
{"name": "boby mc gee", "age": 67}
), {"name": "boby mc gee", "age": 67, "id": 35})
# adress is not part of the ressource description, it should
# raise
self.assertRaises(BadRequest,
store.update,
{"name": "bob", "age": "35", "id": 35},
{"adress": "1, main street"}
)
self.assertRaises(NotFound,
store.update,
{"name": "bob", "age": "100", "id": 400},
{"name": "boby mc gee"}
)
os.remove("test.db")
def test_get(self):
store = SQLiteDataStore({"name": ":memory:", "table": "address"}, ApiModel)
for i in range(100):
store.create({"name": "bob", "age": 34})
self.assertEqual(store.get(10)["id"], 10)
self.assertRaises(NotFound, store.get, 101)
def test_create(self):
data = {"name": ":memory:", "table": "address"}
store = SQLiteDataStore(data, ApiModel)
self.assertRaises(NotFound, store.get, 1)
self.assertEqual(store.create({"name": "bob", "age": 34}), 1)
self.assertEqual(store.create({"name": "bob", "age": 35}), 2)
self.assertEqual(store.create({"name": "bob", "age": 34}), 3)
self.assertEqual(store.get(3)["id"], 3)
def test_create(self):
data = {"name": ":memory:", "table": "address"}
store = SQLiteDataStore(data, ApiModel)
self.assertRaises(NotFound, store.get, 1)
self.assertEqual(store.create({"name": "bob", "age": 34}), 1)
self.assertEqual(store.create({"name": "bob", "age": 35}), 2)
self.assertEqual(store.create({"name": "bob", "age": 34}), 3)
self.assertEqual(store.get(3)["id"], 3)
def test_get(self):
store = SQLiteDataStore({
"name": ":memory:",
"table": "address"
}, ApiModel)
for i in range(100):
store.create({"name": "bob", "age": 34})
self.assertEqual(store.get(10)["id"], 10)
self.assertRaises(NotFound, store.get, 101)
def test_foreign_keys(self):
data = {"name": "test.db", "table": "address"}
store = SQLiteDataStore(data, ApiModel)
self.assertEqual(store.create({"name": "bob", "age": 34}), 1)
data = {"name": "test.db", "table": "user"}
store2 = SQLiteDataStore(data, UserModel)
self.assertEqual(store2.create({"last_name": "bob", "first_name": "Dick", "address": 1}), 1)
self.assertRaises(BadRequest, store2.create, {"last_name": "moby", "first_name": "Dick", "address": 2})
self.assertRaises(BadRequest, store.delete, 1)
os.remove("test.db")
def test_pagination(self):
store = SQLiteDataStore(
{"name": "test.db", "table": "address"},
ApiModel)
for i in range(100):
store.create({"name": "bob", "age": 34})
self.assertEqual(len(store.get_list(count=10)), 10)
self.assertEqual(store.get_list(count=10)[-1]["id"], 10)
self.assertEqual(store.get_list(offset=15)[0]["id"], 15)
req = store.get_list(offset=15, count=2)
self.assertEqual(len(req), 2)
self.assertEqual(req[0]['id'], 15)
os.remove("test.db")
def test_delete(self):
store = SQLiteDataStore({"name": ":memory:", "table": "address"}, ApiModel)
for i in range(100):
store.create({"name": "bob", "age": 34})
# the object exists
self.assertEqual(store.get(10)["id"], 10)
# is delete
self.assertEqual(store.delete(10), None)
# does not exist anymore
self.assertRaises(NotFound, store.get, 10)
def test_update(self):
store = SQLiteDataStore({
"name": "test.db",
"table": "address"
}, ApiModel)
for i in range(100):
store.create({"name": "bob", "age": 34})
self.assertEqual(
store.update({
"name": "bob",
"age": 34,
"id": 34
}, {"name": "boby mc gee"}), {
"name": "boby mc gee",
"age": 34,
"id": 34
})
self.assertEqual(
store.update({
"name": "bob",
"age": 35,
"id": 35
}, {
"name": "boby mc gee",
"age": 67
}), {
"name": "boby mc gee",
"age": 67,
"id": 35
})
# adress is not part of the ressource description, it should
# raise
self.assertRaises(BadRequest, store.update, {
"name": "bob",
"age": "35",
"id": 35
}, {"adress": "1, main street"})
self.assertRaises(NotFound, store.update, {
"name": "bob",
"age": "100",
"id": 400
}, {"name": "boby mc gee"})
os.remove("test.db")
def test_delete(self):
store = SQLiteDataStore({
"name": ":memory:",
"table": "address"
}, ApiModel)
for i in range(100):
store.create({"name": "bob", "age": 34})
# the object exists
self.assertEqual(store.get(10)["id"], 10)
# is delete
self.assertEqual(store.delete(10), None)
# does not exist anymore
self.assertRaises(NotFound, store.get, 10)
def test_pagination(self):
store = SQLiteDataStore({
"name": ":memory:",
"table": "address"
}, ApiModel)
for i in range(100):
store.create({"name": "bob", "age": 34})
self.assertEqual(len(store.get_list(count=10)), 10)
self.assertEqual(store.get_list(count=10)[-1]["id"], 10)
self.assertEqual(store.get_list(offset=15)[0]["id"], 15)
req = store.get_list(offset=15, count=2)
self.assertEqual(len(req), 2)
self.assertEqual(req[0]['id'], 15)
def test_foreign_keys(self):
data = {"name": "test.db", "table": "address"}
store = SQLiteDataStore(data, ApiModel)
self.assertEqual(store.create({"name": "bob", "age": 34}), 1)
data = {"name": "test.db", "table": "user"}
store2 = SQLiteDataStore(data, UserModel)
self.assertEqual(
store2.create({
"last_name": "bob",
"first_name": "Dick",
"address": 1
}), 1)
self.assertRaises(BadRequest, store2.create, {
"last_name": "moby",
"first_name": "Dick",
"address": 2
})
self.assertRaises(BadRequest, store.delete, 1)
os.remove("test.db")
