mongodb examples

buildconfig.groovy

    dependencies {
        runtime "org.mongodb:mongo-java-driver:2.9.1"
        compile "org.mongodb:mongo-java-driver:2.9.1"
        runtime "com.gmongo:gmongo:1.0"
    }

    plugins {
        //runtime ":hibernate:$grailsVersion"
        //runtime ":database-migration:1.1"
        ...

        compile (":mongodb:1.0.0.GA"){
            excludes 'mongo-java-driver', 'gmongo'
        }
    }

index.gsp

    <ul class="bullets">
        <g:each in="${avgCityPopulation}" var="state">
            <li><b>${state._id}</b> -- ${state.avgCityPop} </li>
        </g:each>
    </ul>

ZipCodeService_method.groovy

    def populationByState(){
        return zipcodes().aggregate(
                [ $group :
                        [ _id : [ state : '$state', city : '$city' ], pop : [ $sum : '$pop' ] ]
                ],
                [ $group :
                        [ _id : '$_id.state', avgCityPop : [ $avg : '$pop' ] ]
                ],
                [ $sort: ['avgCityPop' : -1] ]
        ).results()
    }

ZipCodeService_output.groovy

Result: [
   {
      "_id": "ND",
      "avgCityPop": 1629.591836734694
   },
   {
      "_id": "SD",
      "avgCityPop": 1826.7821522309712
   },
   {
      "_id": "VT",
      "avgCityPop": 2315.8765432098767
   },
....

ZipCodeService_setup.groovy

class ZipCodeService {

    def mongo

    def getDB(){
        return mongo.getDB("MongoPlay")
    }

    def zipcodes(){
        return getDB().zipcodes
    }

....
}