public void Empty() { SqlPredicate p = new SqlPredicate(); Assert.That(p.And(p).ToString(), Is.EqualTo("")); Assert.That(p.Clone().ToString(), Is.EqualTo("")); Assert.That(p.GetAllPlaceHolders(), Is.EqualTo(new string[] { })); Assert.That(p.HasUnplacedHolder("T"), Is.False); Assert.That(p.HasUnplacedHolders(), Is.False); Assert.That(p.IsEmpty, Is.True); Assert.That(p.IsPlaceHolderOnly, Is.False); p.Place("PH", "a=1"); Assert.That(p.ToString(), Is.EqualTo("")); }
public void And() { SqlPredicate p; SqlPredicate p1; p = new SqlPredicate("@PH and 1 = 1"); p1 = p.And(new SqlPredicate("x is null and 2=2")); Assert.That(p1.ToString(), Is.EqualTo("@PH AND 1=1 AND x IS NULL AND 2=2")); p1 = p.And(new SqlPredicate("x is null or 2=2")); Assert.That(p1.ToString(), Is.EqualTo("@PH AND 1=1 AND (x IS NULL OR 2=2)")); p = new SqlPredicate("@PH or 1 = 1"); p1 = p.And(new SqlPredicate("x is null and 2 = 2")); Assert.That(p1.ToString(), Is.EqualTo("(@PH OR 1=1) AND x IS NULL AND 2=2")); p = new SqlPredicate("x is null"); p1 = p.And(p); Assert.That(p1.ToString(), Is.EqualTo("x IS NULL AND x IS NULL")); p = new SqlPredicate("x = 11"); p1 = p.And(new SqlPredicate()); Assert.That(p1.ToString(), Is.EqualTo("x=11")); }