def test_find_item(self): TestHelper.prepare_sample_database() test_id = 5 dao = TestDao() items = dao.find(where_clause=TestEntity.id == test_id) self.assertEqual(1, len(items)) item = items[0] self.assertEqual("Test %s" % test_id, item.testName) self.assertEqual("This is description %s" % test_id, item.testDescription)
def test_delete_item(self): TestHelper.prepare_sample_database() test_id = 5 dao = TestDao() items = dao.find(where_clause=TestEntity.id == test_id) self.assertEqual(1, len(items)) item = items[0] dao.delete(item) items = dao.find(where_clause=TestEntity.id == test_id) self.assertEqual(0, len(items))
def test_update_item(self): TestHelper.prepare_sample_database() test_id = 7 # check base item dao = TestDao() items = dao.find(where_clause=TestEntity.id == test_id) self.assertEqual(1, len(items)) item = items[0] self.assertEqual("This is description %s" % test_id, item.testDescription) # update item item.testDescription = "test desc" dao.update(item) # check update items = dao.find(where_clause=TestEntity.id == test_id) self.assertEqual(1, len(items)) item = items[0] self.assertEqual("test desc", item.testDescription)