public void CommonUse()
{
// some times the select can be static in son place (the service of a DAO)
Select s = new Select("f.Name, f.Description, b.Descriptoin").From("Foo f join f.Bar b");
// Create a new where by checking some contition
Where where = new Where();
// check something and set a condition of where clause
where.And("f.Name like :pName");
// check something else and set another condition of where clause
where.And("b.Asociated > :pAso");
// Inject the where to the select
s.From().SetWhere(where);
// Create a basic order by
OrderBy order = new OrderBy().Add("b.Asociated", true);
// Check some condition and add an order
order.Add("f.Name");
// Inject the OrderBy to the select
s.From().SetOrderBy(order);
// And: The winner is....
string expected =
"select f.Name, f.Description, b.Descriptoin from Foo f join f.Bar b where ((f.Name like :pName) and (b.Asociated > :pAso)) order by b.Asociated desc, f.Name";
Assert.AreEqual(expected, s.Clause);
}
public void OrderByTest()
{
// OrderBy can be created away
OrderBy o = new OrderBy().Add("f.Name").Add("f.Id", true).Add("f.Surname");
Assert.AreEqual("f.Name, f.Id desc, f.Surname", o.Expression);
Assert.AreEqual("order by f.Name, f.Id desc, f.Surname", o.Clause);
}
public void OrderByInjection()
{
// Inject the OrderBy to an existing "from clause"
OrderBy o = new OrderBy().Add("f.Name").Add("f.Id", true);
From frm = new From("Foo");
frm.SetOrderBy(o);
Assert.AreEqual("from Foo order by f.Name, f.Id desc", frm.Clause);
}
public void ToRowCount()
{
Select s = new Select("f.Name, f.Description, b.Descriptoin").From("Foo f join f.Bar b");
Where where = new Where();
where.And("f.Name like :pName");
where.And("b.Asociated > :pAso");
s.From().SetWhere(where);
OrderBy order = new OrderBy().Add("b.Asociated", true);
order.Add("f.Name");
s.From().SetOrderBy(order);
DetachedDynQuery ddq = new DetachedDynQuery(s);
DetachedQuery drc = (DetachedQuery) ddq.TransformToRowCount();
Assert.AreEqual(
"select count(*) from Foo f join f.Bar b where ((f.Name like :pName) and (b.Asociated > :pAso))",
drc.Hql);
}
public void SetOrderBy(OrderBy orderClause)
{
if (orderClause == null)
{
throw new ArgumentNullException("orderClause");
}
orderBy = orderClause;
}
public OrderBy OrderBy()
{
if (orderBy == null)
{
orderBy = new OrderBy();
}
return orderBy;
}
