/// <summary> /// Build a subquery against a nested array property /// </summary> /// <returns></returns> private string BuildArrayQuery() { var sb = new StringBuilder(); var mainFrom = Extents.FirstOrDefault(); if (mainFrom == null) { throw new InvalidOperationException("N1QL Subquery Missing From Part"); } if (WrappingFunctions != null) { foreach (string function in WrappingFunctions.AsEnumerable().Reverse()) { sb.AppendFormat("{0}(", function); } } if ((SelectPart != mainFrom.ItemName) || WhereParts.Any()) { sb.AppendFormat("ARRAY {0} FOR {1} IN {2}", SelectPart, mainFrom.ItemName, mainFrom.Source); if (WhereParts.Any()) { sb.AppendFormat(" WHEN {0}", String.Join(" AND ", WhereParts)); } sb.Append(" END"); } else { // has no projection or predicates, so simplify sb.Append(mainFrom.Source); } if (WrappingFunctions != null) { sb.Append(')', WrappingFunctions.Count); } return(sb.ToString()); }
/// <summary> /// Builds a subquery using the ANY or EVERY expression to test a nested array /// </summary> /// <returns>Query string</returns> private string BuildAnyAllQuery() { var sb = new StringBuilder(); var mainFrom = Extents.FirstOrDefault(); if (mainFrom == null) { throw new InvalidOperationException("N1QL Any Subquery Missing From Part"); } var extentName = mainFrom.ItemName; var source = mainFrom.Source; if (QueryType == N1QlQueryType.ArrayAll) { extentName = PropertyExtractionPart; if (WhereParts.Any()) { // WhereParts should be used to filter the source before the EVERY query // This is done using the ARRAY operator with a WHEN clause source = string.Format("(ARRAY {1} FOR {1} IN {0} WHEN {2} END)", source, mainFrom.ItemName, string.Join(" AND ", WhereParts)); } } sb.AppendFormat("{0} {1} IN {2} ", QueryType == N1QlQueryType.ArrayAny ? "ANY" : "EVERY", extentName, source); if (QueryType == N1QlQueryType.ArrayAny) { // WhereParts should be applied to the SATISFIES portion of the query if (WhereParts.Any()) { sb.AppendFormat("SATISFIES {0}", String.Join(" AND ", WhereParts)); } else { sb.Append("SATISFIES true"); } } else // N1QlQueryType.All { // WhereAllPart is applied as the SATISFIES portion of the query sb.Append("SATISFIES "); sb.Append(WhereAllPart); } sb.Append(" END"); return(sb.ToString()); }