How to use mongoDB $sum in @Query

Question

I'm new user of mongoDB, I have create an application with spring boot/mySql and I want replace database sql to mongoDB.

I did change all things necessary for example, annotations, relations etc ... but I have a problem with request I don't know the similar syntax of @Query in mongoDb.

this my request with sql:

// this calculate the sum of all distance in walk's document
@Query("select sum(distance) from Walk")
public Double sumDistance();

I did read mongoDB aggregate and I know how to use it in console windows with command

$ mongo
$ db.walk.aggregate([{$group:{"_id":"$dateWalk",Count:{$sum:"$distance"}}}])

but, I want use $sum in my program java not in console.

So please, I need your help about the syntax similar to this with mongoDB

// this calculate the sum of all distance in walk's document
@Query("select sum(distance) from Walk")
public Double sumDistance();

thanks in advance :)

This examples will help you. docs.spring.io/spring-data/mongodb/docs/current/reference/html/… In case you are wondering here are the query methods supported in mongo db docs.spring.io/spring-data/mongodb/docs/current/reference/html/… — s7vr
– s7vr, Commented Apr 5, 2017 at 16:04

helmy · Accepted Answer · 2017-04-05 16:10:20Z

1

You would need to create a custom Repository that would implement the aggregation.

Examples:

answered Apr 5, 2017 at 16:10

helmy

9,5673 gold badges36 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use mongoDB $sum in @Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related