public void Between_Success()
{
ICriteriaBuilder cb = EJBContainer.Instance.EntityManager.GetCriteriaBuilder();
ICriteriaQuery cq = cb.CreateQuery();
IRoot r = cq.From("Students");
IPredicate exp = cb.Between(r.Get("SequenceNumber"), cb.Literal("2"), cb.Literal("3"));
Assert.AreEqual("Students.SequenceNumber BETWEEN 2 AND 3", exp.ExpressionValue);
}
public void EqualWithQuotes()
{
ICriteriaBuilder cb = EJBContainer.Instance.EntityManager.GetCriteriaBuilder();
ICriteriaQuery cq = cb.CreateQuery();
IRoot r = cq.From("Students");
IPredicate exp = cb.Equal(cb.Literal("'FirstName'"), cb.Literal("'Jonas'"));
Assert.AreEqual("'FirstName' = 'Jonas'", exp.ExpressionValue);
}
public void SelecRenewtWhere()
{
ICriteriaBuilder cb = EJBContainer.Instance.EntityManager.GetCriteriaBuilder();
ICriteriaQuery cc = cb.CreateQuery();
IRoot r = cc.From("Students");
cc.Select(r.Get("FirstName"));
cc.Where(cb.Equal(r.Get("FirstName"), cb.Literal("'Jonas'")));
cc.Where(cb.NotEqual(r.Get("LastName"), cb.Literal("'Kybartas'")));
Assert.AreEqual("SELECT Students.FirstName FROM Students WHERE Students.LastName <> 'Kybartas'", cc.ExpressionValue);
}
public void Or()
{
ICriteriaBuilder cb = EJBContainer.Instance.EntityManager.GetCriteriaBuilder();
ICriteriaQuery cc = cb.CreateQuery();
IRoot r = cc.From("Students");
IPredicate left = cb.Equal(r.Get("Name"), cb.Literal("'Jonas'"));
IPredicate right = cb.Equal(r.Get("Faculty_Id"), cb.Literal("3"));
IExpression expr = cb.Or(left, right);
Assert.AreEqual("Students.Name = 'Jonas' OR Students.Faculty_Id = 3", expr.ExpressionValue);
}
public void NotLike_Success()
{
ICriteriaBuilder cb = EJBContainer.Instance.EntityManager.GetCriteriaBuilder();
ICriteriaQuery cq = cb.CreateQuery();
IRoot r = cq.From("Students");
IPredicate exp = cb.NotLike(r.Get("FirstName"), cb.Literal("'Jon%'"));
Assert.AreEqual("Students.FirstName NOT LIKE 'Jon%'", exp.ExpressionValue);
}
public void Not()
{
ICriteriaBuilder cb = EJBContainer.Instance.EntityManager.GetCriteriaBuilder();
ICriteriaQuery cq = cb.CreateQuery();
IRoot r = cq.From("Students");
IPredicate exp = cb.Equal(r.Get("SequenceNumber"), cb.Literal("2"));
IPredicate pred = cb.Not(exp);
Assert.AreEqual("NOT (Students.SequenceNumber = 2)", pred.ExpressionValue);
}