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_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_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)
def test_create_entities(self): # init new database TestHelper.prepare_clean_database() dao = TestDao() name = "my test" desc = "my description" # insert new item item = TestEntity(testName=name, testDescription=desc, nullValue=None) dao.insert(item) items = dao.find(where_clause=TestEntity.testName == "my test") self.assertEqual(1, len(items)) item = items[0] self.assertEquals(name, item.testName) self.assertEqual(desc, item.testDescription) self.assertEqual(None, item.nullValue)