Exemple #1
0
        public static async Task <IActionResult> Run(
            [HttpTrigger(AuthorizationLevel.Function, "get")] HttpRequest req,
            ILogger log)
        {
            log.LogInformation("C# HTTP trigger function processed a request.");
            CloudTable          table    = StaticHelpers.GetTable("IotTableHourly");
            List <ResponseItem> allItems = await StaticHelpers.GetAlltableItemAsyncResponseItem(table);


            int    daysInt = 7;
            string days    = req.Query["days"];

            if (!String.IsNullOrWhiteSpace(days))
            {
                daysInt = int.Parse(days);
            }

            var filteredItems =
                allItems
                .Where(i => DateTime.ParseExact(i.RowKey, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture) >= DateTime.Now.AddDays(-daysInt))
                .ToList();

            if (filteredItems.Count != 0)
            {
                string top = req.Query["top"];
                if (!String.IsNullOrWhiteSpace(top))
                {
                    int topint = Int32.Parse(top);
                    return(new OkObjectResult(filteredItems.Take(topint)));
                }
                else
                {
                    return(new OkObjectResult(filteredItems));
                }
            }
            else
            {
                return(new BadRequestResult());
            }
        }
Exemple #2
0
        private static async Task CleanUpOldItemsAsync(List <MyTableEntity> allItems)
        {
            CloudTable table     = StaticHelpers.GetTable("IotTable");
            int        rowOffset = 0;

            while (rowOffset < allItems.Count)
            {
                var batch = new TableBatchOperation();

                // next batch
                var rows = allItems
                           .Skip(rowOffset)
                           .Take(100)
                           .ToList();

                rows.ForEach(item => batch.Add(TableOperation.Delete(item)));

                // submit
                await table.ExecuteBatchAsync(batch);

                rowOffset += rows.Count;
            }
        }
Exemple #3
0
        public static async Task RunAsync([TimerTrigger("0 50 23 * * * ")] TimerInfo myTimer, ILogger log)
        {
            log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}");

            CloudTable          table    = StaticHelpers.GetTable("IotTableHourly");
            List <ResponseItem> allItems = await StaticHelpers.GetAlltableItemResponseAsync(table, DateTime.Now.ToString("MMMM-yyyy"));

            allItems.ForEach(i =>
            {
                var date = DateTime.ParseExact(s: i.RowKey, format: "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture);
                i.RowKey = date.Day.ToString();
            });
            List <string>       DateRanges = allItems.Select(i => i.RowKey).Distinct().ToList();
            List <ResponseItem> result     = new List <ResponseItem>();

            foreach (var item in DateRanges)
            {
                List <ResponseItem> range = allItems.Where(i => i.RowKey == item).ToList();

                ResponseItem entity = new ResponseItem
                {
                    PartitionKey = range[0].PartitionKey,
                    RowKey       = item,
                    humidity     = (int)Math.Round(range.Average(i => i.humidity), 0),
                    temperature  = (int)Math.Round(range.Average(i => i.temperature), 0),
                    AQI          = (int)Math.Round(range.Average(i => i.AQI), 0)
                };
                result.Add(entity);
            }

            CloudTable tableDaily = StaticHelpers.GetTable("IotTableDaily");

            foreach (var item in result)
            {
                await tableDaily.ExecuteAsync(TableOperation.InsertOrReplace(item));
            }
        }