public void CacheTest()
{
CachePreferenceImpl Cache = new CachePreferenceImpl(true, 30, true);
var dbHelper = Factory.GetDBHelper();
var Repository = new GenericTableRepository <Portal>(dbHelper);
var _result = Repository.Get(null, Cache);
Assert.IsNotNull(_result);
var _result1 = Repository.Get(null, Cache);
Assert.AreEqual(_result.Count, _result1.Count);
Repository.Insert(_result.First());
Thread.Sleep(1000);
var _result3 = Repository.Get(null, Cache);
Assert.AreNotEqual(_result.Count, _result3.Count);
var _result4 = Repository.Get(null, Cache);
Assert.AreEqual(_result4.Count, _result3.Count);
}
public void SimpleSelectUsingRepositoryTest()
{
var dbHelper = Factory.GetDBHelper();
var rep = new GenericTableRepository <Portal>(dbHelper);
var portals = rep.Get();
Assert.Equals(portals.Count, "title");
}
public void SingleUsingRepositoryTest()
{
var dbHelper = Factory.GetDBHelper();
var rep = new GenericTableRepository <Portal>(dbHelper);
var portal = rep.GetSingle(null, null);
Assert.Equals(portal.Title, "title");
}
public void DeleteUsingRepositoryTest()
{
var dbHelper = Factory.GetDBHelper();
var rep = new GenericTableRepository <Portal>(dbHelper);
var model = new Portal
{
id = 1
};
rep.Delete(model);
}
public void CriteriaSelectUsingRepositoryTest()
{
var dbHelper = Factory.GetDBHelper();
var rep = new GenericTableRepository <Portal>(dbHelper);
var criteria = rep.GetCriteria();
var exp = rep.ExpressionHelper;
criteria.Add(exp.Eq(m => m.Title, "title")).Add(!exp.Eq(m => m.Http, "http://"));
var portals = rep.Get(criteria);
Assert.Equals(portals.Count, "title");
}
public void SaveUsingRepositoryTest()
{
var dbHelper = Factory.GetDBHelper();
var rep = new GenericTableRepository <Portal>(dbHelper);
var model = new Portal
{
Title = "title",
Http = "http://"
};
rep.Save(model);
Assert.IsNotNull(model.id);
model.Title = "Changed Title";
rep.Save(model);
Assert.Equals(model.Title, "Changed Title");
}
public void rollbackUsingRepository()
{
var dbHelper = Factory.GetDBHelper();
var rep = new GenericTableRepository <Portal>(dbHelper);
var count = rep.GetCount(null, null);
dbHelper.Execute(
delegate(DBRepository aDBRepository)
{
aDBRepository.Execute(
delegate(GenericTableRepository <Portal> repo)
{
Portal _news = new Portal();
_news.Title = "Elie";
repo.Insert(_news);
repo.Insert(_news);
});
aDBRepository.Execute(
delegate(GenericTableRepository <Menu> repo)
{
Menu menu = new Menu();
menu.Name = "test";
repo.Insert(menu);
repo.Insert(menu);
throw new Exception("Throw exception");
});
},
delegate(Exception anExc)
{
System.Console.Out.Write(anExc);
});
var newCount = rep.GetCount(null, null);
Assert.Equals(count, newCount);
}
