public void OrderByRaw2()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
OrderByList o = new OrderByList(SqlBuilder.DefaultFormatter);
o.Raw("[c] ASC").Raw("[d] DESC");
string result = o.GetSql("t");
string sql = "[c] ASC, [d] DESC";
Assert.AreEqual(sql, result);
}
public void OrderByRaw2()
{
NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
OrderByList o = new OrderByList(NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter);
o.Raw("[c] ASC").Raw("[d] DESC");
string result = o.GetSql("t");
string sql = "[c] ASC, [d] DESC";
Assert.Equal(sql, result);
}
public void OrderByTableAlias2()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
OrderByList o = new OrderByList(SqlBuilder.DefaultFormatter);
o.Raw("[a] ASC");
o.Ascending("as1");
o.Descending("ds2");
o.SetTableAlias("ttt");
o.Ascending("at1");
o.SetTableAlias("ddd");
o.Descending("at2");
o.SetTableAlias();
o.Descending("b");
string result = o.GetSql();
string sql = "[a] ASC, [as1] ASC, [ds2] DESC, [ttt].[at1] ASC, [ddd].[at2] DESC, [b] DESC";
Assert.AreEqual(sql, result);
}
public void OrderByTableAlias2()
{
NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
OrderByList o = new OrderByList(NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter);
o.Raw("[a] ASC");
o.Ascending("as1");
o.Descending("ds2");
o.SetTableAlias("ttt");
o.Ascending("at1");
o.SetTableAlias("ddd");
o.Descending("at2");
o.SetTableAlias();
o.Descending("b");
string result = o.GetSql();
string sql = "[a] ASC, [as1] ASC, [ds2] DESC, [ttt].[at1] ASC, [ddd].[at2] DESC, [b] DESC";
Assert.Equal(sql, result);
}