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); }