public void RenderAggregateFunctionWidthDistinctModifier()
{
Column column = new Column("Column1");
DistinctModifier distinctModifier = new DistinctModifier();
AggregateFunction aggregateFunction = new AggregateFunction(FunctionType.Count, distinctModifier, column);
Assert.AreEqual("COUNT(DISTINCT [Column1])", sqlClientRenderer.Render(aggregateFunction));
}
public void CreateAggregateFunctionWithDistinctModifier()
{
Column column = new Column("Column1");
DistinctModifier distinctModifier = new DistinctModifier();
AggregateFunction aggregateFunction = new AggregateFunction(FunctionType.Count, distinctModifier, column);
Assert.AreEqual(FunctionType.Count, aggregateFunction.FunctionType);
Assert.AreEqual(distinctModifier, aggregateFunction.DistinctModifier);
Assert.AreEqual(column, aggregateFunction.Expression);
}
public void Add(SelectQuery query, DistinctModifier repeatingAction)
{
this.items.Add(new SqlUnionItem(query, repeatingAction));
}
/// <summary>
/// Adds a query to the UNION clause with the specified DistinctModifier
/// </summary>
/// <param name="query">SelectQuery to be added</param>
/// <param name="repeatingAction">Distinct modifier</param>
public void Add(SelectQuery query, DistinctModifier repeatingAction)
{
items.Add(new SqlUnionItem(query, repeatingAction));
}
public SqlUnionItem(SelectQuery query, DistinctModifier repeatingAction)
{
Query = query;
RepeatingAction = repeatingAction;
}
public AggregateFunction(FunctionType functionType, DistinctModifier distinctModifier, IQueryValueExpression expression) : base(expression)
{
FunctionType = functionType;
DistinctModifier = distinctModifier;
}
public override string Render(DistinctModifier distinctModifier)
{
return("DISTINCT");
}
public abstract string Render(DistinctModifier distinctModifier);
public SqlUnionItem(SelectQuery query, DistinctModifier repeatingAction)
{
this.Query = query;
this.RepeatingAction = repeatingAction;
}
public void RenderDistinctModifier()
{
DistinctModifier distinctModifier = new DistinctModifier();
Assert.AreEqual("DISTINCT", sqlClientRenderer.Render(distinctModifier));
}
