public void GroupBySimpleListAlias()
{
ColumnsListAggregation c = new ColumnsListAggregation(global::SqlBuilder.Format.MsSQL);
GroupByList g = new GroupByList(global::SqlBuilder.Format.MsSQL, c);
g.Append(false, "a", "b", "c");
string result = g.GetSql("t");
string sql = "[t].[a], [t].[b], [t].[c]";
Assert.AreEqual(sql, result);
}
public void GroupByAlias2()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
ColumnsListAggregation c = new ColumnsListAggregation(SqlBuilder.DefaultFormatter);
GroupByList g = new GroupByList(SqlBuilder.DefaultFormatter, c);
g.Append(false, "c1");
g.SetTableAlias("oh2");
g.Append(false, "c2");
g.SetTableAlias("oh3");
g.Append(false, "c3");
g.SetTableAlias();
g.Append(false, "c4");
g.Raw("[t].[column]");
string result = g.GetSql();
string sql = "[c1], [oh2].[c2], [oh3].[c3], [c4], [t].[column]";
Assert.AreEqual(sql, result);
}
public void GroupByAlias2()
{
NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
ColumnsListAggregation c = new ColumnsListAggregation(NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter);
GroupByList g = new GroupByList(NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter, c);
g.Append(false, "c1");
g.SetTableAlias("oh2");
g.Append(false, "c2");
g.SetTableAlias("oh3");
g.Append(false, "c3");
g.SetTableAlias();
g.Append(false, "c4");
g.Raw("[t].[column]");
string result = g.GetSql();
string sql = "[c1], [oh2].[c2], [oh3].[c3], [c4], [t].[column]";
Assert.Equal(sql, result);
}
public void GroupBySimpleListAlias()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
ColumnsListAggregation c = new ColumnsListAggregation(SqlBuilder.DefaultFormatter);
GroupByList g = new GroupByList(SqlBuilder.DefaultFormatter, c);
g.Append(false, "a", "b", "c");
string result = g.GetSql("t");
string sql = "[t].[a], [t].[b], [t].[c]";
Assert.AreEqual(sql, result);
}
public void GroupBySimpleList3()
{
ColumnsListAggregation c = new ColumnsListAggregation(global::SqlBuilder.Format.MsSQL);
GroupByList g = new GroupByList(global::SqlBuilder.Format.MsSQL, c);
g.Append(true, "a", "b", "c");
string result = g.GetSql();
string sql = "[a], [b], [c]";
Assert.AreEqual(sql, result);
Assert.AreEqual(c.Count, g.Count);
}
public void GroupBySimpleListAlias()
{
NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
ColumnsListAggregation c = new ColumnsListAggregation(NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter);
GroupByList g = new GroupByList(NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter, c);
g.Append(false, "a", "b", "c");
string result = g.GetSql("t");
string sql = "[t].[a], [t].[b], [t].[c]";
Assert.Equal(sql, result);
}
public void GroupBySimpleList3()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
ColumnsListAggregation c = new ColumnsListAggregation(SqlBuilder.DefaultFormatter);
GroupByList g = new GroupByList(SqlBuilder.DefaultFormatter, c);
g.Append(true, "a", "b", "c");
string result = g.GetSql();
string sql = "[a], [b], [c]";
Assert.AreEqual(sql, result);
Assert.AreEqual(c.Count, g.Count);
}
