public void SetUp()
{
if (!isSet)
{
isSet = true;
category1 = DatabaseTestDataProvider.ProvideRandomTestItemCategory();
model1 = DatabaseTestDataProvider.ProvideRandomTestItemModel(category1);
model1.Name = "DRT_01";
model2 = DatabaseTestDataProvider.ProvideRandomTestItemModel(category1);
model2.Name = "DRT_02";
model3 = DatabaseTestDataProvider.ProvideRandomTestItemModel(category1);
model3.Name = "DRT_03";
deletedModel = DatabaseTestDataProvider.ProvideRandomTestItemModel(category1);
deletedModel.Name = "DRT_04";
Repository.Save(model3);
Repository.Save(deletedModel);
Repository.Save(model2);
Repository.Save(model1);
UnitOfWork.Commit();
Repository.Delete(deletedModel);
UnitOfWork.Commit();
}
}
public void Should_Filter_Null_Or_Whitespace_Column_Correctly()
{
var category = DatabaseTestDataProvider.ProvideRandomTestItemCategory();
category.Name = " ";
Repository.Save(category);
UnitOfWork.Commit();
TestItemCategory alias = null;
var loadedCategory = Repository
.AsQueryOver(() => alias)
.Where(RestrictionsExtensions.IsNullOrWhiteSpace(Projections.Property(() => alias.Name)))
.And(() => alias.Id == category.Id)
.SingleOrDefault <TestItemCategory>();
Assert.IsNotNull(loadedCategory);
Assert.AreEqual(category.Id, loadedCategory.Id);
}
public void Should_Return_Correct_Items_Future_Count()
{
var category1 = DatabaseTestDataProvider.ProvideRandomTestItemCategory();
var category2 = DatabaseTestDataProvider.ProvideRandomTestItemCategory();
var category3 = DatabaseTestDataProvider.ProvideRandomTestItemCategory();
category1.Name = "QEIT_" + category1.Name.Substring(10);
category2.Name = "QEIT_" + category1.Name.Substring(10);
category3.Name = "QEIT_" + category1.Name.Substring(10);
Repository.Save(category1);
Repository.Save(category2);
Repository.Save(category3);
UnitOfWork.Commit();
var query = Repository.AsQueryable <TestItemCategory>().Where(c => c.Name.StartsWith("QEIT_"));
var countFuture = query.ToRowCountFutureValue();
var future = query.ToFuture();
Assert.AreEqual(future.ToList().Count, 3);
Assert.AreEqual(countFuture.Value, 3);
}