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