public void RenderPatternPredicate() { Column column = new Column("Column1"); StringLiteralValue stringLiteralValue = new StringLiteralValue("%Value1%"); PatternPredicate patternPredicate = new PatternPredicate(column, stringLiteralValue); Assert.AreEqual("[Column1] LIKE '%Value1%'", sqlClientRenderer.Render(patternPredicate)); }
public void RenderMembershipPredicate() { Column column = new Column("Column1"); StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1"); MembershipPredicate membershipPredicate = new MembershipPredicate(column, stringLiteralValue); Assert.AreEqual("[Column1] IN ('Value1')", sqlClientRenderer.Render(membershipPredicate)); }
public void RenderComparisonPredicate() { Column column = new Column("Column1"); StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1"); ComparisonPredicate comparisonPredicate = new ComparisonPredicate(column, ComparisonPredicateType.Equals, stringLiteralValue); Assert.AreEqual("[Column1] = 'Value1'", sqlClientRenderer.Render(comparisonPredicate)); }
public void CreateHavingClause() { Column column = new Column("Column1"); StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1"); ComparisonPredicate comparisonPredicate = new ComparisonPredicate(column, ComparisonPredicateType.Equals, stringLiteralValue); HavingClause havingClause = new HavingClause(comparisonPredicate); Assert.AreEqual(comparisonPredicate, havingClause.Predicate); }
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 CreatePatternPredicate() { Column column = new Column("Column1"); StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1"); PatternPredicate patternPredicate = new PatternPredicate(column, stringLiteralValue); Assert.AreEqual(column, patternPredicate.Expression); Assert.IsNull(patternPredicate.NotModifier); Assert.AreEqual(stringLiteralValue, patternPredicate.Pattern); }
public void CreateMembershipPredicate() { Column column = new Column("Column1"); StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1"); MembershipPredicate membershipPredicate = new MembershipPredicate(column, stringLiteralValue); Assert.AreEqual(column, membershipPredicate.Expression); Assert.IsNull(membershipPredicate.NotModifier); Assert.AreEqual(stringLiteralValue, membershipPredicate.Membership); }
public void CreateComparisonPredicate() { Column column = new Column("Column1"); StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1"); ComparisonPredicate comparisonPredicate = new ComparisonPredicate(column, ComparisonPredicateType.Equals, stringLiteralValue); Assert.AreEqual(column, comparisonPredicate.LeftExpression); Assert.AreEqual(ComparisonPredicateType.Equals, comparisonPredicate.ComparisonType); Assert.AreEqual(stringLiteralValue, comparisonPredicate.RightExpression); }
public override string Render(StringLiteralValue stringLiteralValue) { if (ReplaceLiteralsWithParameters) { return(AddParameter(stringLiteralValue.Literal, DbType.String).Render(this)); } else { return(string.Format("'{0}'", stringLiteralValue.Literal.Replace("'", "''"))); } }
public void AddHavingClauseToSelectQuery() { SelectQuery selectQuery = new SelectQuery(); Column column = new Column("Column1"); StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1"); ComparisonPredicate comparisonPredicate = new ComparisonPredicate(column, ComparisonPredicateType.Equals, stringLiteralValue); HavingClause havingClause = new HavingClause(comparisonPredicate); selectQuery.Having(havingClause); Assert.AreEqual(havingClause, selectQuery.HavingClause); }
public void AddWhereClauseToSelectQuery() { SelectQuery selectQuery = new SelectQuery(); Column column = new Column("Column1"); StringLiteralValue stringLiteralValue = new StringLiteralValue("LiteralValue1"); ComparisonPredicate comparisonPredicate = new ComparisonPredicate(column, ComparisonPredicateType.Equals, stringLiteralValue); WhereClause whereClause = new WhereClause(comparisonPredicate); selectQuery.Where(whereClause); Assert.AreEqual(whereClause, selectQuery.WhereClause); }
public void RenderHavingClausesOr() { Column column1 = new Column("Column1"); Column column2 = new Column("Column2"); StringLiteralValue stringLiteralValue1 = new StringLiteralValue("Value1"); StringLiteralValue stringLiteralValue2 = new StringLiteralValue("Value2"); ComparisonPredicate comparisonPredicate1 = new ComparisonPredicate(column1, ComparisonPredicateType.Equals, stringLiteralValue1); ComparisonPredicate comparisonPredicate2 = new ComparisonPredicate(column2, ComparisonPredicateType.Equals, stringLiteralValue2); HavingClause havingClause1 = new HavingClause(comparisonPredicate1); HavingClause havingClause2 = new HavingClause(comparisonPredicate2); HavingClauses havingClauses = new HavingClauses(havingClause1, BooleanOperatorType.Or, havingClause2); Assert.AreEqual("([Column1] = 'Value1' OR [Column2] = 'Value2')", sqlClientRenderer.Render(havingClauses)); }
public void RenderWhereClausesAnd() { Column column1 = new Column("Column1"); Column column2 = new Column("Column2"); StringLiteralValue stringLiteralValue1 = new StringLiteralValue("Value1"); StringLiteralValue stringLiteralValue2 = new StringLiteralValue("Value2"); ComparisonPredicate comparisonPredicate1 = new ComparisonPredicate(column1, ComparisonPredicateType.Equals, stringLiteralValue1); ComparisonPredicate comparisonPredicate2 = new ComparisonPredicate(column2, ComparisonPredicateType.Equals, stringLiteralValue2); WhereClause whereClause1 = new WhereClause(comparisonPredicate1); WhereClause whereClause2 = new WhereClause(comparisonPredicate2); WhereClauses whereClauses = new WhereClauses(whereClause1, BooleanOperatorType.And, whereClause2); Assert.AreEqual("([Column1] = 'Value1' AND [Column2] = 'Value2')", sqlClientRenderer.Render(whereClauses)); }
public void AddHavingClauses() { Column column1 = new Column("Column1"); Column column2 = new Column("Column2"); StringLiteralValue stringLiteralValue1 = new StringLiteralValue("Value1"); StringLiteralValue stringLiteralValue2 = new StringLiteralValue("Value2"); ComparisonPredicate comparisonPredicate1 = new ComparisonPredicate(column1, ComparisonPredicateType.Equals, stringLiteralValue1); ComparisonPredicate comparisonPredicate2 = new ComparisonPredicate(column2, ComparisonPredicateType.Equals, stringLiteralValue2); HavingClause havingClause1 = new HavingClause(comparisonPredicate1); HavingClause havingClause2 = new HavingClause(comparisonPredicate2); HavingClauses havingClauses = new HavingClauses(havingClause1, BooleanOperatorType.And, havingClause2); Assert.AreEqual(havingClause1, havingClauses.LeftClause); Assert.AreEqual(BooleanOperatorType.And, havingClauses.OperatorType); Assert.AreEqual(havingClause2, havingClauses.RightClause); }
public static PatternPredicate Like(IQueryValueExpression expression, StringLiteralValue pattern) { return new PatternPredicate(expression, pattern); }
public abstract string Render(StringLiteralValue stringLiteralValue);
public void RenderStringLiteralValue() { StringLiteralValue stringLiteralValue = new StringLiteralValue("Value"); Assert.AreEqual("'Value'", sqlClientRenderer.Render(stringLiteralValue)); }
public void CreateStringLiteralValue() { StringLiteralValue stringLiteralValue = new StringLiteralValue("Value"); Assert.AreEqual("Value", stringLiteralValue.Literal); }