Exemplo n.º 1
0
        public virtual void AddConditions(IDynamoCommonQuery dynamoQ, IDataQuery q)
        {
            if (q.Conditions.Count == 0)
            {
                return;
            }

            var dbConditions         = new List <DataConditionExpression>();
            var args                 = new Dictionary <string, object>();
            var sb                   = StringBuilderCache.Allocate();
            var isMultipleWithOrTerm = q.Conditions.Any(x => x.Term == QueryTerm.Or) &&
                                       q.Conditions.Count > 1;

            foreach (var condition in q.Conditions)
            {
                var fmt      = DynamoQueryConditions.GetExpressionFormat(condition.QueryCondition.Alias);
                var multiFmt = DynamoQueryConditions.GetMultiExpressionFormat(condition.QueryCondition.Alias);

                if (fmt == null && multiFmt == null && isMultipleWithOrTerm)
                {
                    throw new NotSupportedException(
                              $"DynamoDB does not support {condition.QueryCondition.Alias} filter with multiple OR queries");
                }

                if (fmt == null && multiFmt == null)
                {
                    continue;
                }

                dbConditions.Add(condition);

                if (sb.Length > 0)
                {
                    sb.Append(condition.Term == QueryTerm.Or ? " OR " : " AND ");
                }

                if (fmt != null)
                {
                    var pId = "p" + args.Count;
                    args[pId] = condition.Value;

                    sb.Append(string.Format(fmt, dynamoQ.GetFieldLabel(condition.Field.Name), ":" + pId));
                }
                else
                {
                    var multiExpr = GetMultiConditionExpression(dynamoQ, condition, multiFmt, args);
                    sb.Append(multiExpr);
                }
            }

            var filter = StringBuilderCache.Retrieve(sb);

            if (filter.Length > 0)
            {
                dynamoQ.AddFilter(filter, args);
            }

            q.Conditions.RemoveAll(dbConditions.Contains);
        }
Exemplo n.º 2
0
        public override IEnumerable <T> GetDataSource(IDataQuery q)
        {
            if (cache != null)
            {
                return(cache);
            }

            var keyCondition = q.Conditions.FirstOrDefault(x =>
                                                           x.Field != null && x.Field.Name.EqualsIgnoreCase(modelDef.HashKey.Name) &&
                                                           x.QueryCondition.Alias == ConditionAlias.Equals);

            if (keyCondition == null)
            {
                var scanExpr = CreateScanExpresion();
                AddConditions(scanExpr, q);
                return(cache = GetResults(scanExpr, q.Offset, q.Rows));
            }

            var rangeCondition = modelDef.RangeKey != null
                ? q.Conditions.FirstOrDefault(x =>
                                              x.Field != null && x.Field.Name.EqualsIgnoreCase(modelDef.RangeKey.Name))
                : null;

            var rangeField = rangeCondition != null
                ? modelDef.RangeKey.Name
                : null;

            var queryExpr = CreateQueryExpression();

            var args      = new Dictionary <string, object>();
            var hashFmt   = DynamoQueryConditions.GetExpressionFormat(keyCondition.QueryCondition.Alias);
            var dynamoFmt = string.Format(hashFmt, queryExpr.GetFieldLabel(modelDef.HashKey.Name), ":k0");

            args["k0"] = keyCondition.Value;

            if (rangeCondition == null)
            {
                foreach (var index in modelDef.LocalIndexes)
                {
                    rangeCondition = q.Conditions.FirstOrDefault(x =>
                                                                 x.Field != null && x.Field.Name.EqualsIgnoreCase(index.RangeKey.Name));

                    if (rangeCondition != null)
                    {
                        rangeField          = index.RangeKey.Name;
                        queryExpr.IndexName = index.Name;
                        break;
                    }
                }
            }

            if (rangeCondition != null)
            {
                var rangeFmt = DynamoQueryConditions.GetExpressionFormat(rangeCondition.QueryCondition.Alias);
                if (rangeFmt != null)
                {
                    dynamoFmt += " AND " + string.Format(hashFmt, queryExpr.GetFieldLabel(rangeField), ":k1");
                    args["k1"] = rangeCondition.Value;
                }
                else
                {
                    var multiFmt = DynamoQueryConditions.GetMultiExpressionFormat(rangeCondition.QueryCondition.Alias);
                    if (multiFmt != null)
                    {
                        var multiExpr = GetMultiConditionExpression(queryExpr, rangeCondition, multiFmt, args, argPrefix: "k");
                        dynamoFmt += " AND " + multiExpr;
                    }
                }
            }

            queryExpr.KeyCondition(dynamoFmt, args);

            q.Conditions.RemoveAll(x => x == keyCondition || x == rangeCondition);

            AddConditions(queryExpr, q);

            return(cache = GetResults(queryExpr, q.Offset, q.Rows));
        }