public void SimpleConstraintsShouldBeOk()
{
var criteria = new Criterion[] {
new Criterion("login", "=", "root"),
new Criterion("organization.name", "=", "org1"),
new Criterion("organization.code", "=", "orgcode1"),
};
var sql1 =
"select _t0._id from core_user _t0 " +
"left outer join core_organization _t1 on _t0.organization=_t1._id " +
"where ( _t0.login = ? and _t1.name = ? and _t1.code = ? ) " +
"order by _t0.login ASC, _t0.name ASC";
var cb = new SqlQueryBuilder(this.Context, "core.user");
cb.AddCriteria(criteria);
cb.AddOrder(new OrderExpression("login", SortDirection.Ascend));
cb.AddOrder(new OrderExpression("name", SortDirection.Ascend));
var sqlStr = cb.ToSqlString();
Assert.AreEqual(
sql1.ToString().Replace(" ", ""),
sqlStr.ToString().Replace(" ", ""));
Assert.AreEqual(cb.Values.Length, 3);
Assert.AreEqual(cb.Values[0], "root");
Assert.AreEqual(cb.Values[1], "org1");
Assert.AreEqual(cb.Values[2], "orgcode1");
}
public void CheckNotInOperatorWithEmptyCollection()
{
var criteria = new Criterion[] {
new Criterion("login", "!in", new string[] {})
};
var cb = new SqlQueryBuilder(this.Context, "core.user");
Assert.Throws <ArgumentException>(delegate { cb.AddCriteria(criteria); });
}
private void TranslateConstraint(object[] constraint, SqlQueryBuilder translator)
{
//处理查询约束
IEnumerable <Criterion> userConstraint = null;
if (constraint != null)
{
userConstraint = constraint.Select(o => new Criterion(o));
}
else
{
userConstraint = EmptyConstraint;
}
translator.AddCriteria(userConstraint);
translator.AddWhereFragment(new SqlString(" and "));
//处理 Rule 约束
this.GenerateReadingRuleConstraints(translator);
}