public void InsertRestrictionTest() { if (database == null) { database = new Database(TestUtils.ConnString); } Assert.NotNull(database); var restrictionDao = new RestrictionDao(database); InsertDummyData(restrictionDao); Assert.Equal(items.Count, restrictionDao.Count()); }
public void FindAllRestrictionsTest() { if (database == null) { database = new Database(TestUtils.ConnString); } Assert.NotNull(database); var restrictionDao = new RestrictionDao(database); InsertDummyData(restrictionDao); Assert.Equal(items.Count, restrictionDao.Count()); IList<Restriction> dbRestrictios = restrictionDao.FindAll(); Assert.NotNull(dbRestrictios); Assert.Equal(items.Count, dbRestrictios.Count); foreach (var restriction in dbRestrictios) { Assert.True(items.Contains(restriction)); } }
public void UpdateRestrictionTest() { if (database == null) { database = new Database(TestUtils.ConnString); } Assert.NotNull(database); var restrictionDao = new RestrictionDao(database); InsertDummyData(restrictionDao); Assert.Equal(items.Count, restrictionDao.Count()); var currRestriction = items[0]; currRestriction.Start = ALTER_START; restrictionDao.Update(currRestriction); var myNewRestriction = restrictionDao.FindById(currRestriction.Id); Assert.NotNull(myNewRestriction); Assert.Equal(ALTER_START, myNewRestriction.Start); }
public void DeleteRestrictionTest() { if (database == null) { database = new Database(TestUtils.ConnString); } Assert.NotNull(database); var restrictionDao = new RestrictionDao(database); InsertDummyData(restrictionDao); Assert.Equal(items.Count, restrictionDao.Count()); foreach (var item in items) { restrictionDao.Delete(item.Id); } Assert.Equal(0, restrictionDao.Count()); }
public void FindRestrictionByIdTest() { if (database == null) { database = new Database(TestUtils.ConnString); } Assert.NotNull(database); var restrictionDao = new RestrictionDao(database); InsertDummyData(restrictionDao); Assert.Equal(items.Count, restrictionDao.Count()); var currRestriction = items[0]; var myRestriction = restrictionDao.FindById(currRestriction.Id); Assert.NotNull(myRestriction); Assert.Equal(currRestriction, myRestriction); restrictionDao.Delete(myRestriction.Id); Assert.Equal(items.Count - 1, restrictionDao.Count()); }