public static TableSelectQuery <TElement> GroupBy <TElement>(this TableSelectQuery <TElement> query, string condition) where TElement : class, new()
 {
     query.Filters.Add(new ConditionFilter(FilterType.GroupBy)
     {
         Condition = condition
     });
     return(query);
 }
 public static TableSelectQuery <TElement> OrderBy <TElement>(this TableSelectQuery <TElement> query, string condition, Order order) where TElement : class, new()
 {
     query.Filters.Add(new OrderFilter(FilterType.OrderBy)
     {
         Condition = condition, Order = order
     });
     return(query);
 }
예제 #3
0
        public virtual string BuildRetrieveQuery <TElement>(TableSelectQuery <TElement> query) where TElement : new()
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("select ");
            if (query.Columns.Count == 0)
            {
                sb.Append("*");
            }
            else
            {
                sb.Append(string.Join(",", query.Columns.Select(column => $"`{column}`")));
            }
            sb.AppendFormat($" from `{TableName}`");
            if (!string.IsNullOrEmpty(query.WhereFilter))
            {
                sb.Append($" where {query.WhereFilter}");
            }
            if (query.HasLimit)
            {
                sb.AppendFormat($" limit {query.Max}");
            }
            return(sb.ToString());
        }
 public static TableSelectQuery <TElement> Any <TElement, TOther>(this TableSelectQuery <TElement> query, string column, TableQueryBase otherQuery) where TElement : class, new() where TOther : class, new()
 {
     query.Filters.Add(new QueryFilter <TOther>(column, otherQuery, FilterType.Any));
     return(query);
 }
 public static TableSelectQuery <TElement> In <TElement, TOther>(this TableSelectQuery <TElement> query, string column, params TOther[] others) where TElement : class, new()
 {
     query.Filters.Add(new InItemsFilter <TOther>(others, column));
     return(query);
 }
 public static TableSelectQuery <TElement> Between <TElement, TValue>(this TableSelectQuery <TElement> query, string column, TValue value1, TValue value2) where TElement : class, new()
 {
     query.Filters.Add(new BetweenFilter <TValue>(column, value1, value2));
     return(query);
 }
 public static TableSelectQuery <TElement> Select <TElement>(this TableSelectQuery <TElement> query, string column) where TElement : class, new()
 {
     query.Columns.Add(column);
     return(query);
 }