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"} }')