Beispiel #1
0
        /// <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 = FromParts.FirstOrDefault();

            if (mainFrom == null)
            {
                throw new InvalidOperationException("N1QL Any Subquery Missing From Part");
            }

            var source = mainFrom.Source;

            if ((QueryType == N1QlQueryType.ArrayAll) && 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",
                            mainFrom.ItemName,
                            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());
        }
Beispiel #2
0
        /// <summary>
        /// Build a subquery against a nested array property
        /// </summary>
        /// <returns></returns>
        private string BuildArrayQuery()
        {
            var sb = new StringBuilder();

            var mainFrom = FromParts.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());
        }