RMongo (version 0.0.25)

dbGetQuery-methods: Performing a MongoDB query

Description

Send a json query to mongodb. The output is a data.frame object and will work properly only if the mongoDB collection contains primitive data types. It may not work properly if there are any embedded documents or arrays.

Usage

dbGetQuery(rmongo.object, collection, query, skip=0, limit=1000)

Arguments

rmongo.object
The RMongo object.
collection
The name of the collection the query is being performed upon.
query
A JSON string query. See http://www.mongodb.org/display/DOCS/Advanced+Queries for more information on the MongoDB query language.
skip
Offset the resultset. Can be used with limit to perform pagination.
limit
Limits the resultset size.

See Also

mongoDbConnect

Examples

  mongo <- mongoDbConnect("test")
  output <- dbInsertDocument(mongo, "test_data", '{"foo": "bar"}')  
  output <- dbGetQuery(mongo, 'test_data', '{"foo": "bar"}')
  print(output)
  
  output <- dbInsertDocument(mongo, "test_data", '{"foo": "bar with spaces"}')
  output <- dbGetQuery(mongo, 'test_data', '{"foo": { "$regex": "bar*", "$options": "i"} }')