08.Mongo DB - Query part 4 (Query Example)

-

   



Project can be download from 
      https://github.com/LahiruPriyankara/SpringBootAppTwo-MongoDB


db.transaction.aggregate([
    {
       $match: {
            "clientId":{$exists: true,$eq: "080c99df-22c4-4744-86e4-bfdfde2a5794"},
            "checks.customer.incentivioId":{$exists: true},
            "businessDate":{$gt: new Date('2019-07-08 00:00:00.000Z'),$lt: new Date('2023-07-08 00:00:00.000Z')}
        }
    },
   /* {  $match: {$and :[
                {"clientId":{$exists: true,$eq: "080c99df-22c4-4744-86e4-bfdfde2a5794"}},
                {"checks.customer.incentivioId":{$exists: true}},
                {"businessDate":{$gt: new Date('2019-07-08 00:00:00.000Z'),$lt: new Date('2023-07-08 00:00:00.000Z')}}        
                    ]
            }
    },*/
    {
       $group: {
               _id: "$checks.customer.incentivioId",
               noOfTransactions: { $sum: 1 },
               totalBasketValue: { $sum: "$checks.total.total" },
               //totalBasketValuee: { $cond: {$if:{$and:[{$gt:[{$sum: "$checks.total.total"},10]},{$lt:[{$sum: "$checks.total.total"},100]}]},$then: 30, $else: 20}},
               averageBasketValue: { $avg: "$checks.total.total" },
               lastPurchaseDate: { $max: "$businessDate" },
               firstPurchaseDate: { $min: "$businessDate" },
               clientId: { $first: "clientId" },
               uniqueExtTxIdSet: { $addToSet: "extTxId" }
            }
   },
   {
       $limit: 100
   },
   {
       $sort: {noOfTransactions: 1,totalBasketValue:-1} // 1 - accending, -1 - decending
   },
   {
       $project: {// 1 - include , 0 - exclude
           _id: 0,
           info:{
               noOfTransactions:"noOfTransactions",
               averageBasketValue:"averageBasketValue"
               }
           }
   },
   {
       $skip: 10
   }
   
])





db.workouts.aggregate([
    { "$match": { "user_id": ObjectId("....") }},
    { "$project": {
       "20": { "$cond": [
           { "$and": [
               { "$gt": [ "$avg_intensity", 20 ] },
               { "$lt": [ "$avg_intensity", 25 ] }
           ]},    
           "$total_volume",
           0
       ]}
   }}
])

.

Comments

Post a Comment

Popular posts from this blog

02. Spring – Creating spring project clone it with GIT step by step.

-
Image
  Creating spring project clone it with GIT step by step. 01. Create an empty GIT repository and select a repository name. 02.   Check to add README.md and technology to add it inside the gitignire file0- it will include all the generated class when we complete the application. 03.      Copy the github repository URL. 04 . Open eclipse and go to,             Window – Show View – Other - Type git on the folder and select git repositories. 05.   Now clone this repository at your desired location in which we are going to keep the project specific file . a)         a)  Step One.             b)  Step  Two .          c)    Step Three. Both projects are generated as bellows           d) Step Four  Open the gitingnore file and ignore the target folder of the project. All the class files which are ...
Read more

09.Mongo DB - ALL

-
Image
  Project can be download from         https://github.com/LahiruPriyankara/SpringBootAppTwo-MongoDB Mongo DB Mongo DB  යනු noSql open source database  එකක් වේ . SQL database හෙවත්  relational database වලදී data table වල තබා ගන්න අතර මෙම table table අතර  relationship  ද පවතී . නමුත් mongoDB වලදී data පවතිනුයේ document collection  එකක් ලෙසට වන අතර මෙම documents අතර  relations  නැත . එනම්  documents are not related with each other. Schema free  වන   අතර  this is based on binary JSON  එනම්  BSON. Mongo DB simple query language  එක ලෙස  simple query language  එක බාවිතා කරනු ලබයි (SQL  වගේ ).  SQL and MongoDB Comparison. Table – Collection Row – Document Column – File Collection is not strict about what goes in it (it’s schema-less).   Download and install mongoDB Go to  https://ww...
Read more

11. Docker – Implementation => CONTAINER LINK WITH MYSQL.

-
Image
Docker – Implementation => CONTAINER LINK WITH MYSQL. DOCKER PAGE : https://hub.docker.com/_/mysql   00. docker pull mysql:5.7 01. docker images 02. docker run -p 3307:3306 --name=mysql_server -e MYSQL_ROOT_PASSWORD=root -e MYSQL_USER=root -e MYSQL_PASSWORD=root -d mysql:5.7 // this is woking.......................................     docker run -p 3300:3306 --name mysql_server -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7   // this is woking.......................................                                                   OR   01. docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag     docker run -p 3307:3306 --name=mysql_server -e MYSQL_ROOT_PASSWORD=r...
Read more