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

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

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

My 1st Haskell Program

By
From past few days I was thinking to do something in Haskell. Gone though few blogs and also tried my hands on tryhaskell only Haskell interactive tutorial. It was way different then my bread & butter Java. So wasn't able to understand much. And now was feeling to write a factorial program in Haskell. My first experiment with Haskell.  Downloaded Haskell from here Now Install Haskell similar the way you installed millions of software. Haskell itself update %PATH% variable so you are not ready to rock and roll in Haskell. Haskell comes with ghci, ghc and runhaskell utilities to interpret, compile or run haskell programs. ghci provide haskell prompt where you can execute haskell statements on the fly. ghc is haskell compiler which compile haskell program and produce an exe on successful compilation. runhaskell utility run haskell program on the fly. Below is mine 1st real haskell program Line 1 Prototype of factorial function. Line 2 Body of factorial program...
Read more