public static string TestCustomSelectString(ISQLQueryWriter writer)
{
var query = QueryModelFactory.CreateSelect(new ComplexColumn("count(*)"))
.From(table1);
return(writer.CreateSelectQuery(query));
}
public static string TestComplexSelect(ISQLQueryWriter writer)
{
var query = QueryModelFactory.CreateSelect(col1, col4, col6, count)
.From(table1)
.Where(
new WhereDefinition(col1, "=", 1),
new WhereDefinition(WhereType.And, col4, "=", 2),
new WhereDefinition(WhereType.Or, count, ">", 3)
)
.Join(
new JoinDefinition(JoinDefinition.JoinType.INNER, table2, col1, col4),
new JoinDefinition(JoinDefinition.JoinType.INNER, table3, col2, col5, col3, col6)
)
.OrderBy(
new OrderByDefinition(count),
new OrderByDefinition(col4, OrderByDefinition.SortDirection.Descending)
)
.GroupBy(col1, col4);
return(writer.CreateSelectQuery(query));
}
