public void SqlStringTest_One()
{
ISqlObject source = new SqlServerSource("Table");
ISqlObject field = new SqlServerField(source, "ID", null);
ISqlOrderClause target = new SqlOrderClause().AddExpression(field, SqlOrder.Desc);
Assert.AreEqual <string>(string.Format("{0} ({1}) DESC", target.Keyword, field.Fullname), target.SqlString);
}
public void SqlStringTest_Expression()
{
ISqlObject source = new SqlServerSource("Table");
ISqlExpression expression = new SqlFunction("MAX").AddArgument(new SqlServerField(source, "ID", null));
ISqlObject field = SqlObject.FromVariable("ROWNUM");
ISqlOrderClause target = new SqlOrderClause().AddExpression(expression, SqlOrder.Desc).AddExpression(field, SqlOrder.Asc);
Assert.AreEqual <string>(string.Format("{0} ({1}) DESC, ({2}) ASC", target.Keyword, expression.SqlString, field.Fullname), target.SqlString);
}
public void SqlStringTest_More()
{
ISqlObject source = new SqlServerSource("Table");
ISqlObject field0 = new SqlServerField(source, "AddTime", null);
ISqlObject field1 = SqlObject.FromVariable("ROWNUM");
ISqlOrderClause target = new SqlOrderClause().AddExpression(field0, SqlOrder.Desc).AddExpression(field1, SqlOrder.Asc);
Assert.AreEqual <string>(string.Format("{0} ({1}) DESC, ({2}) ASC", target.Keyword, field0.Fullname, field1.Fullname), target.SqlString);
}
