Exemplo n.º 1
0
        private U DoAggregate <T, U>(Aggregate aggregate, Where where)
        {
            bool useMultiPartIdentifier = where.Any(w => w.Item1.Contains("."));

            Type type = typeof(T);

            BuildMap(type);
            string     sql        = BuildAggregateSql(type, aggregate, where, useMultiPartIdentifier);
            Parameters parameters = BuildWhereParameters(where, useMultiPartIdentifier);

            return(DoExecuteScalar <U>(sql, parameters));
        }
Exemplo n.º 2
0
        public void Where_Any()
        {
            //arrange
            SqlConnect sql      = new CSharpedSql.MySql.MySqlConnect();
            var        expected = "SELECT * FROM `test` WHERE `id` = ANY (SELECT * FROM `table`);";

            //act
            sql.Query(Select.From("test") + Where.Any("id", Select.From("table")));
            var actual = sql.ToString().TrimEnd();

            //assert
            Assert.AreEqual(expected, actual);
        }
Exemplo n.º 3
0
        protected void FillWhere(params NameValueCollection[] collections)
        {
            foreach (var collection in collections)
            {
                foreach (var item in collection)
                {
                    var key = item.ToString();
                    if (Where.Any(p => p.Key.ToLower() == key.ToLower()) || string.IsNullOrEmpty(collection[key]) ||
                        key.ToLower() == "page" || key.ToLower() == "rows" || key.ToLower() == "order" || key.ToLower() == "sort")
                    {
                        continue;
                    }

                    Where.Add(key, collection[key].Trim());
                }
            }
        }
Exemplo n.º 4
0
        /// <summary>
        /// Returns a <see cref="System.String" /> that represents this instance.
        /// </summary>
        /// <returns>A <see cref="System.String" /> that represents this instance.</returns>
        /// <exception cref="ArgumentException">Resource</exception>
        public override string ToString()
        {
            if (string.IsNullOrEmpty(ObjectStructureName))
            {
                throw new ArgumentException($"Required paramater '{nameof(ObjectStructureName)}' was not given.");
            }

            var sb = new StringBuilder();

            sb.Append($"{ObjectStructureName}?");

            if (Select != null && Select.Any())
            {
                var selectSb = new StringBuilder("oslc.select=");
                foreach (var att in Select)
                {
                    selectSb.Append($"{att}{SELECT_SEPERATOR}");
                }

                var selectStr = selectSb.ToString();
                if (selectStr.EndsWith(SELECT_SEPERATOR))
                {
                    selectStr = selectStr.Remove(selectStr.Length - SELECT_SEPERATOR.Length);
                }

                sb.Append(selectStr);
            }
            else if (!IsCreate)
            {
                sb.Append("oslc.select=*");
            }

            if (!string.IsNullOrEmpty(SavedQuery))
            {
                sb.Append($"&savedQuery={SavedQuery}");
            }

            if (Where.Any() || WhereIn.Any())
            {
                var whereSb = new StringBuilder("&oslc.where=");
                foreach (var what in Where)
                {
                    whereSb.Append($"{what}{WHERE_SEPERATOR}");
                }

                foreach (var whatIn in WhereIn)
                {
                    var valueList = whatIn.Value.Select(v => $"\"{v}\"").ToList();
                    whereSb.Append($"{whatIn.Key} in [{string.Join(",", valueList)}]{WHERE_SEPERATOR}");
                }

                var whereStr = whereSb.ToString();
                if (whereStr.EndsWith(WHERE_SEPERATOR))
                {
                    whereStr = whereStr.Remove(whereStr.Length - WHERE_SEPERATOR.Length);
                }

                sb.Append(whereStr);
            }

            if (OrderBy != null)
            {
                sb.Append("&oslc.orderBy=");

                sb.Append(OrderByDescending ? "-" : "%2B");

                sb.Append(OrderBy);
            }

            if (PageSize != null && PageSize > 0)
            {
                sb.Append($"&oslc.pageSize={PageSize}");

                if (PageNumber != null && PageNumber > 1)
                {
                    sb.Append($"&pageno={PageNumber}");
                }
            }

            if (UseLean)
            {
                sb.Append("&lean=1");
            }

            if (UseOr)
            {
                sb.Append("&opmodeor=1");
            }

            return(sb.ToString());
        }