public void RenderNullPredicateWithNotModifier()
{
Column column = new Column("Column1");
NotModifier notModifier = new NotModifier();
NullPredicate nullPredicate = new NullPredicate(column, notModifier);
Assert.AreEqual("[Column1] IS NOT NULL", sqlClientRenderer.Render(nullPredicate));
}
public RangePredicate(IQueryValueExpression leftExpression, NotModifier notModifier,
IQueryValueExpression middleExpression, IQueryValueExpression rightExpression)
{
LeftExpression = leftExpression;
NotModifier = notModifier;
MiddleExpression = middleExpression;
RightExpression = rightExpression;
}
public void RenderMembershipPredicateWithNotModifier()
{
Column column = new Column("Column1");
NotModifier notModifier = new NotModifier();
StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1");
MembershipPredicate membershipPredicate = new MembershipPredicate(column, notModifier, stringLiteralValue);
Assert.AreEqual("[Column1] NOT IN ('Value1')", sqlClientRenderer.Render(membershipPredicate));
}
public void RenderPatternPredicateWithNotModifier()
{
Column column = new Column("Column1");
NotModifier notModifier = new NotModifier();
StringLiteralValue stringLiteralValue = new StringLiteralValue("%Value1%");
PatternPredicate patternPredicate = new PatternPredicate(column, notModifier, stringLiteralValue);
Assert.AreEqual("[Column1] NOT LIKE '%Value1%'", sqlClientRenderer.Render(patternPredicate));
}
public void CreateNullPredicateWithNotModifier()
{
Column column = new Column("Column1");
NotModifier notModifier = new NotModifier();
NullPredicate nullPredicate = new NullPredicate(column, notModifier);
Assert.AreEqual(nullPredicate.Expression, column);
Assert.AreEqual(notModifier, nullPredicate.NotModifier);
}
public void CreateMembershipPredicateWithNotModifier()
{
Column column = new Column("Column1");
NotModifier notModifier = new NotModifier();
StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1");
MembershipPredicate membershipPredicate = new MembershipPredicate(column, notModifier, stringLiteralValue);
Assert.AreEqual(column, membershipPredicate.Expression);
Assert.AreEqual(notModifier, membershipPredicate.NotModifier);
Assert.AreEqual(stringLiteralValue, membershipPredicate.Membership);
}
public void RenderRangePredicateWithNotModifier()
{
Column column = new Column("Column1");
NotModifier notModifier = new NotModifier();
IntegerLiteralValue stringLiteralValue1 = new IntegerLiteralValue(1);
IntegerLiteralValue stringLiteralValue2 = new IntegerLiteralValue(3);
RangePredicate rangePredicate = new RangePredicate(column, notModifier, stringLiteralValue1, stringLiteralValue2);
Assert.AreEqual("[Column1] NOT BETWEEN 1 AND 3", sqlClientRenderer.Render(rangePredicate));
}
public void CreatePatternPredicateWithNotModifier()
{
Column column = new Column("Column1");
NotModifier notModifier = new NotModifier();
StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1");
PatternPredicate patternPredicate = new PatternPredicate(column, notModifier, stringLiteralValue);
Assert.AreEqual(column, patternPredicate.Expression);
Assert.AreEqual(notModifier, patternPredicate.NotModifier);
Assert.AreEqual(stringLiteralValue, patternPredicate.Pattern);
}
public void CreateRangePredicateWithNotModifier()
{
Column column = new Column("Column1");
NotModifier notModifier = new NotModifier();
IntegerLiteralValue stringLiteralValue1 = new IntegerLiteralValue(1);
IntegerLiteralValue stringLiteralValue2 = new IntegerLiteralValue(3);
RangePredicate rangePredicate = new RangePredicate(column, notModifier, stringLiteralValue1, stringLiteralValue2);
Assert.AreEqual(column, rangePredicate.LeftExpression);
Assert.AreEqual(notModifier, rangePredicate.NotModifier);
Assert.AreEqual(stringLiteralValue1, rangePredicate.MiddleExpression);
Assert.AreEqual(stringLiteralValue2, rangePredicate.RightExpression);
}
public NullPredicate(IQueryValueExpression expression, NotModifier notModifier)
{
NotModifier = notModifier;
Expression = expression;
}
public override string Render(NotModifier notModifier)
{
return("NOT");
}
public abstract string Render(NotModifier notModifier);
public void RenderNotModifier()
{
NotModifier notModifier = new NotModifier();
Assert.AreEqual("NOT", sqlClientRenderer.Render(notModifier));
}
public PatternPredicate(IQueryValueExpression expression, NotModifier notModifier, StringLiteralValue pattern)
{
Expression = expression;
NotModifier = notModifier;
Pattern = pattern;
}
public MembershipPredicate(IQueryValueExpression expression, NotModifier notModifier, IQueryMembership membership)
{
NotModifier = notModifier;
Expression = expression;
Membership = membership;
}
