Exemplo n.º 1
0
        /// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        public static string GetGroupBy(Time.Range r)
        {
            var from = DateTimeMathParser.ToDateTime(r.From, false);
            var to   = DateTimeMathParser.ToDateTime(r.To, true);

            return((from.HasValue && to.HasValue) ? GetGroupBy(from.Value, to.Value) : "1m");
        }
Exemplo n.º 2
0
        /// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        public string Build(string root, Time.Range r)
        {
            var list = this
                       .Where(x => x.Params?.Length > 0)
                       .ToList();

            var groupByTime = list.FirstOrDefault(x => x.Type == GroupBy.Kind.Time);

            var groupByFill = list.FirstOrDefault(x => x.Type == GroupBy.Kind.Fill);

            var groupByTag = list
                             .Where(x => x.Type == GroupBy.Kind.Tag)
                             .ToList();

            if (null != groupByTime)
            {
                var influxGroupBy = InfluxDateTimeHelper.GetGroupBy(r);

                //query = query.Replace( VmFilter.TIME_FILTER_KEY, influxFilter );

                //var gb = ( this.range ) ? this.getOptimalAutoGroupBy() : groupByTime.params[ 0 ];
                var gb = groupByTime.Params?[0];
                root = $"{root}	GROUP BY time({gb})";

                var groupByAutoIndex = root.IndexOf(GROUP_BY_AUTO_KEY);

                if (-1 != groupByAutoIndex)
                {
                    root = root.Replace(GROUP_BY_AUTO_KEY, influxGroupBy);                      // TODO
                }
            }

            if (groupByTag.Count > 0)
            {
                root = (null == groupByTime) ? $"{root} GROUP BY" : $"{root},";
                var index = 0;

                groupByTag
                .ForEach(e =>
                {
                    var i = index > 0 ? ", " : " ";
                    root  = $"{root}{i} \"{e.Params [ 0 ]}\"";
                    ++index;
                });
            }

            if (null != groupByFill)
            {
                root = $"{root} FILL({groupByFill.Params [ 0 ] })";
            }

            return(root);
        }
Exemplo n.º 3
0
        /// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        private string RenderMeasurement(Time.Range r)
        {
            var meas = (string.IsNullOrEmpty(Measurement)) ? "measurement" : Measurement;

            var rp = (!string.IsNullOrEmpty(Policy) && Policy != "default") ? $"\"{Policy}\"." : "";

            var root = $"{rp}\"{meas}\"";

            var cond = Tags?.Build() ?? string.Empty;

            var timeFilter = InfluxDateTimeHelper.GetFilter(r);

            if (!string.IsNullOrEmpty(cond))
            {
                root = $"{root}	WHERE ({cond}) and {timeFilter}";
            }
            else
            {
                // TODO
                root = $"{root}	WHERE {timeFilter}";
            }

            if (null != GroupBy)
            {
                root = GroupBy?.Build(root, r);
            }

            if (Order != OrderByTime.Asc)
            {
                root = $"{root} ORDER BY time DESC";
            }

            if (Limit > 0)
            {
                root = $"{root}	LIMIT {Limit}";
            }

            if (SLimit > 0)
            {
                root = $"{root}	SLIMIT {SLimit}";
            }

            return(root);
        }
Exemplo n.º 4
0
        /// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        public static string GetFilter(Time.Range range)
        {
            if (null == range)
            {
                return(TIME_FILTER);
            }

            var from = GetTime(range?.From, false);
            var to   = GetTime(range?.To, true);

            var fromIsAbsolute = from.EndsWith("ms");

            if (to == "now()" && !fromIsAbsolute)
            {
                return($"time >= {from}");
            }

            return($"time >= {from} and time <= {to}");
        }
Exemplo n.º 5
0
        /// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        public string Compile(Time.Range r = null)
        {
            var res = string.Empty;

            if (UseRawQuery && !string.IsNullOrEmpty(RawQuery))
            {
                res = RawQuery;
            }
            else
            {
                var sb = new StringBuilder();

                sb.Append($"SELECT {Fields?.Build()} FROM {RenderMeasurement( r )}");

                res = sb.ToString();
            }

            //InfluxDateTimeHelper.GetFilter()

            return(res);
        }