Spring Data Reactive MongoDb :: Date Aggeration with Timezone

By
A short example on how to aggravate by date with a different timezone using Spring Data Reactive Mongodb. Code Snippet on github 


    public Flux getHourlyReport() {
        DateOperators.Timezone timezone = DateOperators.Timezone.valueOf("America/New_York");
        Aggregation aggregation = Aggregation.newAggregation(Aggregation.project()
                        .and(DateOperators.Hour.hour("$tweet.createdAt")
                                .withTimezone(timezone))
                        .as("hour")
                , Aggregation.group("hour").count().as("sum"));
        Flux data = this.mongoTemplate.aggregate(aggregation, "realTweets", Map.class);
        return data;
    }

Comments

Post a Comment

Popular posts from this blog

What Firefox Users Want

By
Firefox was 1st choice of all techy guys before chrome and still it have a large user base and people love it. Still there are few things which users demands in Firefox from other browsers.    Here is the list what Firefox users wants This extension and separate/concurrent private browsing tabs and/or windows (Opera has private browsing tabs, which in my opinion are really useful). - by morally_bankrupt77 In Chrome you can have both private and normal session together but in Firefox starting private session suspend normal session and vice varsa. Dont know why private browsing is not implemented that way. - by dvgaba Auto-add of search engines and accessing them using tab in the awesome bar. When I visit amazon.com in chrome and search for something, and then the next time I open up a tab and start typing amazon.com, there is this option to hit tab and then search within amazon, without having to go to the page first. That is by far one of the things I miss the...
Read more

SSIS Package : Export Data from Database, Daily to New Excel Without Using Script Task

By
Image
Export data from database to excel sheet with new excel per day SSIS => SQL Server Integration Services, is used for ETL (Extract, Transform and Load) type of work. It is advanced version of DTS we can say. Here we can schedule packages as jobs and it will execute without human intervention. In this article we will export the data from SQL database table to excel sheet day wise. To start with this you will need to install SQL Server 2008 with BIDS (Business Intelligence Development Studio) Now moving forward the first step would be go to File => New Project => Select “Business Intelligence Projects” from left panel and “Integration Service Project” from right panel. Give proper name and save at desired location. On OK click, it will open Package.dtsx. Create a Template folder somewhere on your hard drive. In that folder create a sample excel with just the headers that you want in the final excel. We will use this template to create new excel every day ...
Read more

WCF Service Creation With C#

By
Image
CodeProject Basic WCF Service Creation in C#.Net => Part1 Hello All, this is the start up guide to create WCF service. This article is a pictorial step by step help to create WCF application. WCF (Windows Communication Foundation) is a part of .Net 3.0. So you need to install Visual Studio 2008 to use WCF. It is platform for SOA. WCF provides a way to create loosely coupled application. WCF is intended to provide services that are distributed and interoperable. It unifies ASMX and .NET Remoting, MSMQ and can be easily extended to support new protocol. When we create a Service, to expose the functionality to the world, it needs to be hosted into Host Process. Service Host will be used to expose the end point of the service to other Service or Clients. Let’s start with the steps... We will start with VS 2008. Create a File -> New Project -> WCF ->WCFClassLibrary project as shown below Select WCF in left panel and WCF Service Library in...
Read more