def test_delete_audiobook(self):
# Check a record exists in the db
audiobook = AudioBook(**self.data)
audiobook.save_to_db()
self.assertIsNotNone(AudioBook.find_by_name(self.data["name"]))
# Delete audiobook
audiobook.delete_from_db()
# Check record doesn't exist anymore
self.assertIsNone(AudioBook.find_by_name(self.data["name"]))
def test_audiobook_load_with_existing_record(self):
audiobook = self.schema().load(self.data, session=db.session)
self.assertIsNone(AudioBook.find_by_name(audiobook.name))
audiobook.save_to_db()
db_audiobook = AudioBook.find_by_name(audiobook.name)
self.assertIsNotNone(db_audiobook)
# load another audiobook with same data and check id is same
self.data["id"] = db_audiobook.id
audiobook2 = self.schema().load(self.data, session=db.session,\
instance=AudioBook.find_by_name(self.data["name"]), unknown=EXCLUDE)
self.assertIsNotNone(audiobook2)
self.assertEqual(audiobook2.id, db_audiobook.id)
def test_update_audiobook(self):
audiobook = AudioBook(**self.data)
audiobook.save_to_db()
# Get the record and check field values
record = AudioBook.find_by_name(self.data["name"])
self.assertIsNotNone(record)
self.assertEqual(record.name, self.data["name"])
self.assertEqual(record.duration, self.data["duration"])
# Update field values
update_data = {
"name": "Updated Test AudioBook",
"duration": 120,
"author": Author("Updated author"),
"narrator": Narrator("Updated Narrator")
}
AudioBook.update(update_data, record)
# Check updated field values
updated_record = AudioBook.find_by_id(record.id)
self.assertIsNotNone(updated_record)
self.assertEqual(updated_record.name, update_data["name"])
self.assertEqual(updated_record.duration, update_data["duration"])
self.assertIsInstance(updated_record.author, Author)
self.assertEqual(str(updated_record.author.name),
update_data["author"].name)
self.assertEqual(updated_record.narrator.name,
update_data["narrator"].name)
def test_post_audiobook(self):
with self.app() as client:
with self.app_context():
# Check record named "Test API AudioBook" does not exist
self.assertIsNone(
AudioBook.find_by_name(
self.post_data["audioFileMetadata"]["name"]))
request = client.post("/", data=json.dumps(self.post_data))
self.assertEqual(request.status_code, 200)
self.assertIsNotNone(
AudioBook.find_by_name(
self.post_data["audioFileMetadata"]["name"]))
self.assertDictEqual(
AudioBookSchema().dump(
AudioBook.find_by_name(
self.post_data["audioFileMetadata"]["name"])),
json.loads(request.data))
def test_create_audiobook(self):
audiobook = AudioBook(**self.data)
# Check there is no exisiting audiobook named "Test AudioBook"
self.assertIsNone(AudioBook.find_by_name(audiobook.name))
# Save audiobook to database
audiobook.save_to_db()
# Check audiobook exists
record = AudioBook.find_by_name(audiobook.name)
self.assertIsNotNone(record)
self.assertIsNotNone(record.id)
self.assertIsNotNone(record.uploaded_time)
self.assertEqual(record.name, audiobook.name)
self.assertEqual(record.duration, audiobook.duration)
# check author name and type
self.assertIsInstance(record.author, Author)
self.assertEqual(record.author.name, self.data["author"])
self.assertIsInstance(record.narrator, Narrator)
self.assertEqual(record.narrator.name, self.data["narrator"])
def test_get_audiobook_by_id_or_name(self):
# Check a record exists in the db
audiobook = AudioBook(**self.data)
audiobook.save_to_db()
audiobook_byname = AudioBook.find_by_name(self.data["name"])
self.assertIsNotNone(audiobook_byname)
id = audiobook_byname.id
# Check find_by_id method
audiobook_byid = AudioBook.find_by_id(id)
self.assertIsNotNone(audiobook_byid)
self.assertEqual(audiobook_byid.name, audiobook_byname.name)
self.assertEqual(audiobook_byid.uploaded_time,
audiobook_byname.uploaded_time)
def test_audiobook_dump(self):
audiobook = AudioBook(
name="Test",
duration=33,
author="Tester",
narrator="Narrator"
)
audiobook.save_to_db()
# Retrieve DB record for the audiobook created
audiobook = AudioBook.find_by_name(audiobook.name)
expected = OrderedDict({
"id": 1,
"name": "Test",
"duration": 33,
"author": "Tester",
"narrator": "Narrator",
"uploaded_time": "T".join(str(audiobook.uploaded_time).split())
})
# Get the serialized data
json_data = self.schema().dump(audiobook)
self.assertDictEqual(json_data, expected)