public static DynamicSql SqlJoin( this DynamicSql query, PostQueryProjection model, PostQueryFilter filter) { query = DynamicSql.DeepClone(query); var joins = model.GetFieldsArr() .Where(f => PostQueryProjection.Joins.ContainsKey(f)) .Select(f => PostQueryProjection.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(PostContent)}.{nameof(PostContent.Lang)}"; contentFilters.Add($"{postContentLang}=@{paramName}"); } if (contentFilters.Any()) { var whereClause = "WHERE " + string.Join(" AND ", contentFilters); query.DynamicForm = query.DynamicForm .Replace(PostQueryPlaceholder.POST_CONTENT_FILTER, whereClause); } } } return(query); }
public static DynamicSql SqlProjectFields( this DynamicSql query, PostQueryProjection model) { query = DynamicSql.DeepClone(query); var finalFields = model.GetFieldsArr() .Where(f => PostQueryProjection.Projections.ContainsKey(f)) .Select(f => PostQueryProjection.Projections[f]); if (finalFields.Any()) { var projectionClause = string.Join(',', finalFields); query.DynamicForm = query.DynamicForm .Replace(DynamicSql.PROJECTION, projectionClause); } var finalResults = model.GetFieldsArr() .Where(f => PostQueryProjection.Results.ContainsKey(f)) .Select(f => PostQueryProjection.Results[f]); query.MultiResults.AddRange(finalResults); return(query); }
public IDictionary <string, object> GetPostDynamic( PostQueryRow row, PostQueryProjection projection, PostQueryOptions options) { var obj = new Dictionary <string, object>(); foreach (var f in projection.GetFieldsArr()) { switch (f) { case PostQueryProjection.INFO: { var entity = row.Post; var content = row.Content; obj["id"] = entity.Id; obj["owner_id"] = entity.OwnerId; obj["type"] = entity.Type; obj["archived"] = entity.Archived; obj["image_url"] = entity.ImageUrl; var createdTime = entity.CreatedTime .ToTimeZone(options.time_zone, options.culture, content?.Lang); var createdTimeStr = createdTime.ToString(options.date_format, options.culture, content?.Lang); obj["created_time"] = new { display = createdTimeStr, iso = $"{createdTime.ToUniversalTime():s}Z" }; var visibleTime = entity.VisibleTime? .ToTimeZone(options.time_zone, options.culture, content?.Lang); var visibleTimeStr = visibleTime?.ToString(options.date_format, options.culture, content?.Lang); if (visibleTimeStr != null) { obj["visible_time"] = new { display = visibleTimeStr, iso = $"{visibleTime?.ToUniversalTime():s}Z" } } ; } break; case PostQueryProjection.CONTENT: { var entity = row.Content; if (entity != null) { obj["content_id"] = entity.Id; obj["lang"] = entity.Lang; obj["description"] = entity.Description; obj["title"] = entity.Title; } } break; case PostQueryProjection.CONTENT_CONTENT: { var entity = row.Content; if (entity != null) { obj["content"] = entity.Content; } } break; case PostQueryProjection.OWNER: { var entity = row.Owner; obj["owner"] = new { id = entity.Id, code = entity.Code, name = entity.Name, }; } break; } } return(obj); }