public void RenderOrderByClause()
{
Column column = new Column("Column1");
GroupByClause groupByClause = new GroupByClause(column);
Assert.AreEqual("[Column1]", sqlClientRenderer.Render(groupByClause));
}
public void RenderTableFromClause()
{
Table table = new Table("Table1");
TableFromClause tableFromClause = new TableFromClause(table);
Assert.AreEqual("[Table1]", sqlClientRenderer.Render(tableFromClause));
}
public void RenderOrderByClause()
{
Column column = new Column("Column1");
OrderByClause orderByClause = new OrderByClause(column);
Assert.AreEqual("[Column1] ASC", sqlClientRenderer.Render(orderByClause));
}
public void RenderExpressionSelectClause()
{
Column column = new Column("Column1");
SelectClause selectClause = new SelectClause(column);
Assert.AreEqual("[Column1]", sqlClientRenderer.Render(selectClause));
}
public void RenderIntegerLiteralArray()
{
IEnumerable <int> array = new int[] { 1, 2, 3 };
IntegerLiteralArray integerLiteralArray = new IntegerLiteralArray(array);
Assert.AreEqual("1,2,3", sqlClientRenderer.Render(integerLiteralArray));
}
public void RenderLowerFunction()
{
Column column = new Column("Column1");
LowerFunction lowerFunction = new LowerFunction(column);
Assert.AreEqual("LOWER([Column1])", sqlClientRenderer.Render(lowerFunction));
}
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 RenderHavingClausesAnd()
{
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("([Column1] = 'Value1' AND [Column2] = 'Value2')", sqlClientRenderer.Render(havingClauses));
}
public void RenderBooleanLiteralValue()
{
BooleanLiteralValue booleanLiteralValue = new BooleanLiteralValue(true);
Assert.AreEqual("1", sqlClientRenderer.Render(booleanLiteralValue));
}
public void RenderColumn()
{
Column column = new Column("Column1");
Assert.AreEqual("[Column1]", sqlClientRenderer.Render(column));
}
public void RenderEmptySelectQuery()
{
SelectQuery selectQuery = new SelectQuery();
Assert.AreEqual("", sqlClientRenderer.Render(selectQuery));
}
public void RenderDistinctModifier()
{
DistinctModifier distinctModifier = new DistinctModifier();
Assert.AreEqual("DISTINCT", sqlClientRenderer.Render(distinctModifier));
}
public void RenderParameter()
{
Parameter parameter = new Parameter("Parameter1", 1, DbType.Int32, ParameterDirection.Input);
Assert.AreEqual("@Parameter1", sqlClientRenderer.Render(parameter));
}
