public void TestNewInstance()
{
ICriteriaBuilder criteriaBuilder = new CriteriaBuilder(SessionFactory.GetClassMetadata);
var criteria1 = criteriaBuilder.MakeCriteria(null);
Assert.IsNull(criteria1);
var criteria2 = criteriaBuilder.MakeCriteria((object)null, null);
Assert.IsNull(criteria2);
var criteria3 = criteriaBuilder.MakeCriteria<Salesman>(null);
Assert.IsNull(criteria3);
var criteria4 = criteriaBuilder.MakeCriteria<Salesman>(null, null);
Assert.IsNull(criteria4);
}
public void TestCriteriaCompiled()
{
ICriteriaBuilder criteriaBuilder = new CriteriaBuilder(SessionFactory.GetClassMetadata);
Salesman instance = new Salesman(1);
ICriteriaCompiled criteriaCompiled = null;
criteriaCompiled = criteriaBuilder.MakeCriteria(instance as object);
Assert.AreEqual(criteriaCompiled.RootAlias, "salesman");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(instance as object, "sal");
Assert.AreEqual(criteriaCompiled.RootAlias, "sal");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "salesman");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(instance, "sal");
Assert.AreEqual(criteriaCompiled.RootAlias, "sal");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(typeof(Salesman), instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "salesman");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(typeof(Salesman), instance, "sal");
Assert.AreEqual(criteriaCompiled.RootAlias, "sal");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
}
public void TestCriteriaCompiled4()
{
ICriteriaCompiled criteriaCompiled = null;
ICriteriaBuilder criteriaBuilder = new CriteriaBuilder(SessionFactory.GetClassMetadata);
CarContract instance = new CarContract
{
Owner = new Salesman(1)
};
criteriaCompiled = criteriaBuilder.MakeCriteria<TradeContract>(instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "tradeContract");
Assert.AreEqual(criteriaCompiled.RootType, typeof(TradeContract));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 2);
var relationship = criteriaCompiled.FindRelationshipProperty("Owner");
Assert.IsNotNull(relationship);
Assert.AreEqual(relationship.Type, typeof(Salesman));
Assert.AreEqual(relationship.Alias, "salesman");
Assert.AreEqual(relationship.GetPath(), "tradeContract.Owner");
//PersistentLayer.Domain.Salesman aaa = new PersistentLayer.Domain.Salesman();
}
public void TestCriteriaCompiled3()
{
long carCount = 0;
IList l0 = null;
using (ISession session = SessionFactory.OpenSession())
{
carCount = session.CreateQuery("select count(*) from CarContract").UniqueResult<long>();
l0 = session.CreateQuery("from CarContract").List();
}
ICriteriaCompiled criteriaCompiled = null;
ICriteriaBuilder criteriaBuilder = new CriteriaBuilder(SessionFactory.GetClassMetadata);
CarContract instance = new CarContract
{
Owner = new Salesman {Name = "Manuel"}
};
criteriaCompiled = criteriaBuilder.MakeCriteria(instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "carContract");
Assert.AreEqual(criteriaCompiled.RootType, typeof(CarContract));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 2);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.AreEqual(lista.Count, 3);
}
instance.Owner = new Salesman(0);
criteriaCompiled = criteriaBuilder.MakeCriteria(instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "carContract");
Assert.AreEqual(criteriaCompiled.RootType, typeof(CarContract));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 2);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.AreEqual(lista.Count, 0);
}
instance.Owner = new Salesman{Name = "pippo"};
criteriaCompiled = criteriaBuilder.MakeCriteria(instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "carContract");
Assert.AreEqual(criteriaCompiled.RootType, typeof(CarContract));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 2);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.AreEqual(lista.Count, 0);
}
}
public void TestCriteriaCompiled2()
{
ICriteriaCompiled criteriaCompiled = null;
ICriteriaBuilder criteriaBuilder = new CriteriaBuilder(SessionFactory.GetClassMetadata);
CarContract instance = new CarContract
{
Owner = new Salesman(1)
};
criteriaCompiled = criteriaBuilder.MakeCriteria(instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "carContract");
Assert.AreEqual(criteriaCompiled.RootType, typeof(CarContract));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 2);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.AreEqual(lista.Count, 3);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(typeof(CarContract), instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "carContract");
Assert.AreEqual(criteriaCompiled.RootType, typeof(CarContract));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 2);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.AreEqual(lista.Count, 3);
}
criteriaCompiled = criteriaBuilder.MakeCriteria<TradeContract>(instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "tradeContract");
Assert.AreEqual(criteriaCompiled.RootType, typeof(TradeContract));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 2);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.AreEqual(lista.Count, 4);
}
}