public static DynamicSql SqlJoin( this DynamicSql query, ResourceTypeQueryProjection model, ResourceTypeQueryFilter filter) { query = DynamicSql.DeepClone(query); var joins = model.GetFieldsArr() .Where(f => ResourceTypeQueryProjection.Joins.ContainsKey(f)) .Select(f => ResourceTypeQueryProjection.Joins[f]); if (joins.Any()) { var joinClause = string.Join('\n', joins); query.DynamicForm = query.DynamicForm .Replace(DynamicSql.JOIN, joinClause); if (filter != null) { var contentFilters = new List <string>(); if (filter.lang != null) { var paramName = query.AddAutoIncrParam(filter.lang); var postContentLang = $"{nameof(ResourceTypeContent)}.{nameof(ResourceTypeContent.Lang)}"; contentFilters.Add($"{postContentLang}=@{paramName}"); } if (contentFilters.Any()) { var whereClause = "WHERE " + string.Join(" AND ", contentFilters); query.DynamicForm = query.DynamicForm .Replace(ResourceTypeQueryPlaceholder.RES_TYPE_CONTENT_FILTER, whereClause); } } } return(query); }
public IDictionary <string, object> GetResourceTypeDynamic( ResourceTypeQueryRow row, ResourceTypeQueryProjection projection, ResourceTypeQueryOptions options) { var obj = new Dictionary <string, object>(); foreach (var f in projection.GetFieldsArr()) { switch (f) { case ResourceTypeQueryProjection.INFO: { var entity = row.ResourceType; obj["id"] = entity.Id; obj["archived"] = entity.Archived; } break; case ResourceTypeQueryProjection.CONTENT: { var entity = row.Content; if (entity != null) { obj["content_id"] = entity.Id; obj["lang"] = entity.Lang; obj["name"] = entity.Name; } } break; } } return(obj); }
public async Task <IActionResult> Get([FromQuery] ResourceTypeQueryFilter filter, [FromQuery] ResourceTypeQuerySort sort, [FromQuery] ResourceTypeQueryProjection projection, [FromQuery] ResourceTypeQueryPaging paging, [FromQuery] ResourceTypeQueryOptions options) { var validationResult = _service.ValidateGetResourceTypes( User, filter, sort, projection, paging, options); if (!validationResult.Valid) { return(BadRequest(validationResult.Result)); } var result = await _service.QueryResourceTypeDynamic( projection, options, filter, sort, paging); if (options.single_only) { if (result == null) { return(NotFound(new AppResultBuilder().NotFound())); } return(Ok(new AppResultBuilder().Success(result.SingleResult))); } return(Ok(new AppResultBuilder().Success(result))); }
public ValidationResult ValidateGetResourceTypes( ClaimsPrincipal principal, ResourceTypeQueryFilter filter, ResourceTypeQuerySort sort, ResourceTypeQueryProjection projection, ResourceTypeQueryPaging paging, ResourceTypeQueryOptions options) { return(ValidationResult.Pass()); }
public QueryResult <IDictionary <string, object> > GetResourceTypeDynamic( IEnumerable <ResourceTypeQueryRow> rows, ResourceTypeQueryProjection projection, ResourceTypeQueryOptions options, int?totalCount = null) { var list = new List <IDictionary <string, object> >(); foreach (var o in rows) { var obj = GetResourceTypeDynamic(o, projection, options); list.Add(obj); } var resp = new QueryResult <IDictionary <string, object> >(); resp.Results = list; if (options.count_total) { resp.TotalCount = totalCount; } return(resp); }
public static DynamicSql SqlProjectFields( this DynamicSql query, ResourceTypeQueryProjection model) { query = DynamicSql.DeepClone(query); var finalFields = model.GetFieldsArr() .Where(f => ResourceTypeQueryProjection.Projections.ContainsKey(f)) .Select(f => ResourceTypeQueryProjection.Projections[f]); if (finalFields.Any()) { var projectionClause = string.Join(',', finalFields); query.DynamicForm = query.DynamicForm .Replace(DynamicSql.PROJECTION, projectionClause); } var finalResults = model.GetFieldsArr() .Where(f => ResourceTypeQueryProjection.Results.ContainsKey(f)) .Select(f => ResourceTypeQueryProjection.Results[f]); query.MultiResults.AddRange(finalResults); return(query); }
public async Task <QueryResult <IDictionary <string, object> > > QueryResourceTypeDynamic( ResourceTypeQueryProjection projection, ResourceTypeQueryOptions options, ResourceTypeQueryFilter filter = null, ResourceTypeQuerySort sort = null, ResourceTypeQueryPaging paging = null) { var conn = context.Database.GetDbConnection(); var openConn = conn.OpenAsync(); var query = ResourceTypeQuery.CreateDynamicSql(); #region General if (filter != null) { query = query.SqlFilter(filter); } query = query.SqlJoin(projection, filter); DynamicSql countQuery = null; int?totalCount = null; Task <int> countTask = null; if (options.count_total) { countQuery = query.SqlCount("*"); } query = query.SqlProjectFields(projection); #endregion await openConn; if (!options.single_only) { #region List query if (sort != null) { query = query.SqlSort(sort); } if (paging != null && (!options.load_all || !ResourceTypeQueryOptions.IsLoadAllAllowed)) { query = query.SqlSelectPage(paging.page, paging.limit); } #endregion #region Count query if (options.count_total) { countTask = conn.ExecuteScalarAsync <int>( sql: countQuery.PreparedForm, param: countQuery.DynamicParameters); } #endregion } var queryResult = await conn.QueryAsync( sql : query.PreparedForm, types : query.GetTypesArr(), map : (objs) => ProcessMultiResults(query, objs), splitOn : string.Join(',', query.GetSplitOns()), param : query.DynamicParameters); if (options.single_only) { var single = queryResult.FirstOrDefault(); if (single == null) { return(null); } var singleResult = GetResourceTypeDynamic(single, projection, options); return(new QueryResult <IDictionary <string, object> >() { SingleResult = singleResult }); } if (options.count_total) { totalCount = await countTask; } var result = GetResourceTypeDynamic(queryResult, projection, options, totalCount); return(result); }