Update Mongo document field from Grails app

Question

I have a requirement where I have to check in the database if the value of a boolean variable(crawled) is false. If so I have to set it to true. I am finding the record based on the value of a string variable(website). I referenced this link but it didn't help. Please tell me what I am doing wrong.

I tried this:

def p = Website.findByWebsite(website);
if(p['crawled'] == true) {
    println "already crawled"
} else {
    mongo.website.update( p, new BasicDBObject( '$set', new BasicDBObject( 'crawled', 'false' ) ) )
    println "updated object"
}

It gives me an error No such property: mongo for class: cmsprofiler.ResourceController

My domain class is as follows:

  class Website{
    String website
    User user
    Boolean crawled
    static belongsTo = [user: User]
    static constraints = {
        website( url:true, unique: ['user'])
    }
    static hasMany = [resource: Resource]
    static mapping = {resource cascade:"all-delete-orphan" }
}

score 0 · Answer 1 · answered Jul 14 '14 at 16:20

0

you should be using

Website.mongo.update(...)

or let the framework inject it:

class ResourceController {
  def mongo

  def list(){
     mongo.website.update(...)
  }

}

answered Jul 14 '14 at 16:20

injecteer

20,038
4
45
89

1st approach: Still throws the error: No such property: mongo for class: cmsprofiler.Website 2nd approach: No such property: website for class: com.gmongo.GMongo – clever_bassi Jul 14 '14 at 16:26
are you using hibernate along with mongo? – injecteer Jul 15 '14 at 08:10
try putting `static mapWith = 'mongo'` into your domain class – injecteer Jul 15 '14 at 13:51

score 0 · Accepted Answer · answered Jul 15 '14 at 13:53

This worked for me. Posting it here in case anyone else has similar requirement.

@Grab(group='com.gmongo', module='gmongo', version='0.9.3')
import com.gmongo.GMongo
@Transactional(readOnly = true)
class ResourceController {
    def mongo = new GMongo()
    def db = mongo.getDB("resources")
    def p = Website.findByWebsite(website)
    if(p['crawled']==false){
    db.website.update([crawled:false],[$set:[crawled:true]])
}

Update Mongo document field from Grails app

2 Answers2