public static void DistinctSelect()
{
var statement = SqlStatementBuilder.Select(select => select
.Query(query => query
.Distinct()
.AllColumns()
.FromTable("app.test")));
Assert.IsNotNull(statement);
Assert.IsNotNull(statement.QueryExpression);
Assert.IsTrue(statement.QueryExpression.Distinct);
Assert.IsNotEmpty(statement.QueryExpression.SelectColumns);
Assert.AreEqual(1, statement.QueryExpression.SelectColumns.Count());
Assert.IsTrue(statement.QueryExpression.SelectColumns.ElementAt(0).IsAll);
Assert.IsNotEmpty(statement.QueryExpression.FromClause.AllTables);
Assert.AreEqual(1, statement.QueryExpression.FromClause.AllTables.Count());
Assert.AreEqual("app.test", statement.QueryExpression.FromClause.AllTables.ElementAt(0).Name);
}
public static void OrderByColumn()
{
var statement = SqlStatementBuilder.Select(select => select
.Query(query => query.AllColumns()
.FromTable("app.test"))
.OrderBy(orderBy => orderBy.Column("name").Descending()));
Assert.IsNotNull(statement);
Assert.IsNotNull(statement.QueryExpression);
Assert.IsNotEmpty(statement.QueryExpression.SelectColumns);
Assert.AreEqual(1, statement.QueryExpression.SelectColumns.Count());
Assert.IsTrue(statement.QueryExpression.SelectColumns.ElementAt(0).IsAll);
Assert.IsNotEmpty(statement.QueryExpression.FromClause.AllTables);
Assert.AreEqual(1, statement.QueryExpression.FromClause.AllTables.Count());
Assert.AreEqual("app.test", statement.QueryExpression.FromClause.AllTables.ElementAt(0).Name);
Assert.IsNotEmpty(statement.OrderBy);
Assert.AreEqual(1, statement.OrderBy.Count());
Assert.IsFalse(statement.OrderBy.ElementAt(0).Ascending);
}
