dbGetQuery-methods: Performing a MongoDB query

In tc/RMongo: MongoDB Client for R

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

tc/RMongo documentation built on May 31, 2019, 7:27 a.m.