public void OrderByASCAndDESCAlias()
{
OrderByList o = new OrderByList(global::SqlBuilder.Format.MsSQL);
o.Ascending("a");
o.Descending("b");
o.Ascending("c");
o.Descending("d");
string result = o.GetSql("t");
string sql = "[t].[a] ASC, [t].[b] DESC, [t].[c] ASC, [t].[d] DESC";
Assert.AreEqual(sql, result);
}
public void OrderByASCAndDESC1()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
OrderByList o = new OrderByList(SqlBuilder.DefaultFormatter);
o.Ascending("a");
o.Descending("b");
o.Ascending("c");
o.Descending("d");
string result = o.GetSql();
string sql = "[a] ASC, [b] DESC, [c] ASC, [d] DESC";
Assert.AreEqual(sql, result);
}
public void OrderByASCAndDESC1()
{
NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
OrderByList o = new OrderByList(NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter);
o.Ascending("a");
o.Descending("b");
o.Ascending("c");
o.Descending("d");
string result = o.GetSql();
string sql = "[a] ASC, [b] DESC, [c] ASC, [d] DESC";
Assert.Equal(sql, result);
}
public void OrderByDESCSimple2()
{
OrderByList o = new OrderByList(global::SqlBuilder.Format.MsSQL);
o.Descending("a", "b", "c");
string result = o.GetSql();
string sql = "[a] DESC, [b] DESC, [c] DESC";
Assert.AreEqual(sql, result);
}
public void OrderByASCAndDESC2()
{
OrderByList o = new OrderByList(global::SqlBuilder.Format.MsSQL);
o.Ascending("a", "b", "c");
o.Descending("d", "e", "f");
string result = o.GetSql();
string sql = "[a] ASC, [b] ASC, [c] ASC, [d] DESC, [e] DESC, [f] DESC";
Assert.AreEqual(sql, result);
}
public void OrderByDESCSimple2()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
OrderByList o = new OrderByList(SqlBuilder.DefaultFormatter);
o.Descending("a", "b", "c");
string result = o.GetSql();
string sql = "[a] DESC, [b] DESC, [c] DESC";
Assert.AreEqual(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 OrderByDESCSimple1()
{
NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
OrderByList o = new OrderByList(NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter);
o.Descending("a");
string result = o.GetSql();
string sql = "[a] DESC";
Assert.Equal(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);
}