countDocuments: Counts documents in a collection, either all or only those...

In timoklimmer/documentdbr: Use Azure DocumentDB from R

Description

Counts documents in a collection, either all or only those which satisfy a specified predicate.

Usage

countDocuments(connectionInfo, predicate = "", partitionKey = "",
  consistencyLevel = "", sessionToken = "", userAgent = "")

Arguments

connectionInfo	A DocumentDB connection info object generated with getDocumentDBConnectionInfo().
predicate	Optional. The predicate which has to be satisfied. Example: "c.machineId IN ('Machine 1', 'Machine 2')" counts all documents of machine 1 and 2. Default is "", ie. all documents in the collection are counted.
partitionKey	Optional. Can be used to limit the operation to a certain partition.
consistencyLevel	Optional. The consistency level override. The valid values are: Strong, Bounded, Session, or Eventual (in order of strongest to weakest). The override must be the same or weaker than the account's configured consistency level.
sessionToken	Optional. A string token used with session level consistency. For more information, see Using consistency levels in DocumentDB.
userAgent	Optional. A string that specifies the client user agent performing the request. The recommended format is user agent name/version. For example, the official DocumentDB .NET SDK sets the User-Agent string to Microsoft.Document.Client/1.0.0.0. A custom user-agent could be something like ContosoMarketingApp/1.0.0.

Value

The number of documents counted and some information extracted from the REST API response such as request charge and session token.

Examples

# load the documentdbr package
library(documentdbr)

# get a DocumentDBConnectionInfo object
myCollection <- getDocumentDBConnectionInfo(
  accountUrl = "https://somedocumentdbaccount.documents.azure.com",
  primaryOrSecondaryKey = "t0C36UstTJ4c6vdkFyImkaoB6L1yeQidadg6wasSwmaK2s8JxFbEXQ0e3AW9KE1xQqmOn0WtOi3lxloStmSeeg==",
  databaseId = "MyDatabaseId",
  collectionId = "MyCollectionId"
)

# count all documents in the collection
queryResult <- countDocuments(myCollection)
cat(paste("The collection has", as.numeric(queryResult$count), "documents.\n"))

# count all documents where value1 < 0.5
queryResult <- countDocuments(myCollection, predicate = "c.value1 < 0.5")
cat(paste("In", as.numeric(queryResult$count), "documents value1 is < 0.5."))

timoklimmer/documentdbr documentation built on May 31, 2019, 2:29 p.m.