poiati
commented
13 years ago Hello Chris. I'm a little late, sorry.
You should use "_id" instead of "id". Bellow is an example of how to do all you want.
Later, I will work on a better way to page elements.
@Grab("com.gmongo:gmongo:0.7")
import com.gmongo.GMongo
def GMongo gmongo = new GMongo("localhost:27017")
def db = gmongo.getDB("test")
// Find By Id
db.example.drop()
db.example << [_id: 1, name: "Foo"]
db.example << [_id: "2", name: "Bar"]
db.example << [_id: 3, name: "Baz"]
assert db.example.findOne(3).name == "Baz"
assert db.example.findOne(1).name == "Foo"
assert db.example.findOne("2").name == "Bar"
// Paging
db.example.drop()
100.times {
db.example << [time: it, random: (Integer)(Math.random() * 100)]
}
def at = 0, total = db.example.find().count()
while (at < total) {
println "At page: ${at / 10}\n"
db.example.find().limit(10).skip(at).sort(random: 1).each {
println "\t-- ${it}"
}
println "\n --------------------------"
at += 10
}
chriscantu
svaret
jondejong
Hello Paulo,
I have been looking at your documentation on Github and on your site. I can't seem to find three features, pagination, sorting and find by id.
I have been able to get pagination to work by following the Java Driver syntax. However, I have not been able to get find by id to work. I tried db.collection.findOne(_id: id) but this does not return any thing. In addition, I tried to use the Java syntax db.collection.findOne( "_id", new ObjectId(id)) but that didn't work either.
Would it be possible to inject "findById" to the collection object?
Also, would it be possible to have a simpler api for paginating and sorting? I don't mind trying to hack something out and submit a patch. I was thinking of something like this db.collection.find([skip:0, limit:10, sort: "asc", orderBy: "lastName"]).
Thoughts?