📖
Rulecube documentation
v2.0
v2.0
  • Overview
  • Quick Start
  • Tutorial
    • Getting started
    • Create and Run Your First Ruleset
    • Use Constants and Methods
    • Create and Call Functions
    • Adding Testcases
    • Using Lookup Tables
    • Using Entities
  • How-to Guides
    • Logging in and Authorization
      • Activate Your Account From an Invitation
      • Log in to Rulecube
      • Change Your Password
      • Recover Your Password
      • Two-factor authentication (2FA)
      • Invite Other Users to Rulecube
      • Edit a User's Role
      • Delete a User
    • Ruleset Development
      • Create a Ruleset
      • Set the Input for a Ruleset
      • Create a Rule
      • Generate Alerts
      • Try out a Ruleset
      • Call a Ruleset from Your Software
      • Entities
        • Create an Entity
        • Drag and Drop a JSON Schema or XSD to create entities
        • Advanced topic: Entity instantiation
      • Constants
        • Constant Tables
      • Functions
      • Built-in Functions
      • Create and Run a Testcase
      • Delete a Ruleset or Components
      • Debugging your Ruleset
    • Create a Workflow
      • Workflow step types
      • Working with documents in a workflow
    • Work with (Environment) Variables
    • Call a Ruleset via Its API From Postman
    • Creating input from JSON Schema
    • Use a Ruleset from Your Software
    • Ruleset Productivity Tips
  • Language Reference
    • Global
    • Finance
    • Http
    • Mail
    • MongoDB
    • SQL
    • Statistics
    • Workflow
    • System
    • Array
    • Date
Powered by GitBook
On this page
  • Methods
  • aggregate
  • bulkWrite
  • findOne
  • find
  • insert
  • insertMany
  • delete
  • deleteMany
  • update
  • updateMany
  1. Language Reference

MongoDB

PreviousMailNextSQL

Last updated 2 years ago

Collection of MongoDB functions.

Methods

aggregate

aggregate(connectionString: string, database: string, collection: string, query: { [key: string]: any; }, options?: { [key: string]: any; })

Equivalent to the MongoDB aggregate function.

Parameters

connectionString string

The connection string to the MongoDB database.

database string

The name of the database.

collection string

The name of the collection.

query { [key: string]: any; }

A sequence of data aggregation operations or stages. See the MongoDB aggregation pipeline operators for details.

options { [key: string]: any; }

(optional) Additional options that aggregate() passes to the MongoDB aggregate command. Available only if you specify the pipeline as an array.

Return type

{ [key: string]: any; }

Examples

// Calculates the average of the field 'age' for all documents in the collection 'users':
MongoDB.aggregate("mongodb://localhost:27017", "mydb", "users", [{ $group: { _id: null, avg: { $avg: "$age" } } }]) // { _id: null, avg: 30 }

bulkWrite

bulkWrite(connectionString: string, database: string, collection: string, operations: { [key: string]: any; }, writeConcern?: { [key: string]: any; }, ordered?: boolean)

Parameters

connectionString string

The connection string to the MongoDB database.

database string

The name of the database.

collection string

The name of the collection.

operations { [key: string]: any; }

A sequence of BulkWrite write operations. See MongoDB write operations for details.

writeConcern { [key: string]: any; }

(optional) A document expressing the write concern. Omit to use the default write concern. See MongoDB bulkWrite for details.

ordered boolean

(optional) A boolean specifying whether the mongodb instance should perform an ordered or unordered operation execution. Defaults to true.

Return type

{ [key: string]: any; }

Examples

// Inserts a document into the collection 'users':
MongoDB.bulkWrite("mongodb://localhost:27017", "mydb", "users", [{ insertOne: { document: { name: "John", age: 30 } } }])

findOne

findOne(connectionString: string, database: string, collection: string, query: { [key: string]: any; }, options?: { [key: string]: any; })

Parameters

connectionString string

The connection string to the MongoDB database.

database string

The name of the database.

collection string

The name of the collection.

query { [key: string]: any; }

Specifies query selection criteria using query operators.

options { [key: string]: any; }

(optional) Specifies additional options for the query. These options modify query behavior and how results are returned. To see available options, see FindOptions documentation.

Return type

{ [key: string]: any; }

Examples

// Gets the record of person with id 1 from the collection 'users':
MongoDB.findOne("mongodb://localhost:27017", "mydb", "users", { "id": 1 }) // { id: 1, firstName: "John", lastName: "Doe" }

find

find(connectionString: string, database: string, collection: string, query: { [key: string]: any; }, options?: { [key: string]: any; })

Parameters

connectionString string

The connection string to the MongoDB database.

database string

The name of the database.

collection string

The name of the collection.

query { [key: string]: any; }

Specifies query selection criteria using query operators.

options { [key: string]: any; }

(optional) Specifies additional options for the query. These options modify query behavior and how results are returned. To see available options, see FindOptions documentation.

Return type

{ [key: string]: any; }[]

Examples

// Gets the record of all persons with age higher than 30 from the collection 'users':
MongoDB.find("mongodb://localhost:27017", "mydb", "users", { age: { $gt: 30 } }) 

insert

insert(connectionString: string, database: string, collection: string, document: { [key: string]: any; }, options?: { [key: string]: any; })

Parameters

connectionString string

The connection string to the MongoDB database.

database string

The name of the database.

collection string

The name of the collection.

document { [key: string]: any; }

Specifies the document to insert.

options { [key: string]: any; }

(optional) Specifies additional options for the insert statement. To see available options, see InsertOneOptions documentation.

Return type

{ [key: string]: any; }

Examples

// Insert a record of a person in the collection 'users':
MongoDB.insert("mongodb://localhost:27017", "mydb", "users", { firstName: "John", lastName: "Doe" })

insertMany

insertMany(connectionString: string, database: string, collection: string, documents: { [key: string]: any; }[], options?: { [key: string]: any; })

Parameters

connectionString string

The connection string to the MongoDB database.

database string

The name of the database.

collection string

The name of the collection.

documents { [key: string]: any; }[]

Specifies the documents to insert.

options { [key: string]: any; }

(optional) Specifies additional options for the insert statement. To see available options, see BulkWriteOptions documentation.

Return type

{ [key: string]: any; }

Examples

// Insert a number of records of a person in the collection 'users':
MongoDB.insertMany("mongodb://localhost:27017", "mydb", "users", [ { firstName: "John", lastName: "Doe" }, { firstName: "Jane", lastName: "Doe" }])

delete

delete(connectionString: string, database: string, collection: string, filter: { [key: string]: any; }, options?: { [key: string]: any; })

Parameters

connectionString string

The connection string to the MongoDB database.

database string

The name of the database.

collection string

The name of the collection.

filter { [key: string]: any; }

The filter used to select the document to remove.

options { [key: string]: any; }

(optional) Specifies additional options for the delete statement. To see available options, see DeleteOptions documentation.

Return type

{ [key: string]: any; }

Examples

// Delete a record of a person from the collection 'users':
MongoDB.deleteOne("mongodb://localhost:27017", "mydb", "users", { firstName: "John", lastName: "Doe" })

deleteMany

deleteMany(connectionString: string, database: string, collection: string, filter: { [key: string]: any; }, options?: { [key: string]: any; })

Parameters

connectionString string

The connection string to the MongoDB database.

database string

The name of the database.

collection string

The name of the collection.

filter { [key: string]: any; }

The filter used to select the documents to remove.

options { [key: string]: any; }

(optional) Specifies additional options for the delete statement. To see available options, see DeleteOptions documentation.

Return type

{ [key: string]: any; }

Examples

// Delete all records of the persons with firstName 'John' from the collection 'users':
MongoDB.deleteMany("mongodb://localhost:27017", "mydb", "users", { firstName: "John" })

update

update(connectionString: string, database: string, collection: string, filter: { [key: string]: any; }, update?: { [key: string]: any; })

Parameters

connectionString string

The connection string to the MongoDB database.

database string

The name of the database.

collection string

The name of the collection.

filter { [key: string]: any; }

The filter used to select the document to update.

update { [key: string]: any; }

(optional) The update operations to be applied to the document.

Return type

{ [key: string]: any; }

Examples

// Find a record of a person from the collection 'users' and change its name:
MongoDB.update("mongodb://localhost:27017", "mydb", "users", { firstName: "John", lastName: "Doe" }, { $set: { lastName: "Dow" }})

updateMany

updateMany(connectionString: string, database: string, collection: string, filter: { [key: string]: any; }, update?: { [key: string]: any; })

Parameters

connectionString string

The connection string to the MongoDB database.

database string

The name of the database.

collection string

The name of the collection.

filter { [key: string]: any; }

The filter used to select the documents to update.

update { [key: string]: any; }

(optional) The update operations to be applied to the documents.

Return type

{ [key: string]: any; }

Examples

// Update all records of the persons with firstName 'John' from the collection 'users':
MongoDB.updateMany("mongodb://localhost:27017", "mydb", "users", { firstName: "John" }, { $set: { firstName: "Joel" }})

Performs multiple write operations with controls for order of execution. Equivalent to the MongoDB BulkWrite function.

Find and return the first document that matches the query. Equivalent to the MongoDB findOne function.

Find and return multiple documents that match the query. Equivalent to the MongoDB find function.

Insert one document. Equivalent to the MongoDB insertOne function.

Insert one or more documents. Equivalent to the MongoDB insertMany function.

Delete the first document that matches the given filter. Equivalent to the MongoDB deleteOne function.

Delete all documents that matches the given filter. Equivalent to the MongoDB deleteMany function.

Update the first document that matches the filter. Equivalent to the MongoDB updateOne function.

Update all documents that matches the filter. Equivalent to the MongoDB updateMany function.

See this documentation for usage
See this documentation for usage
See this documentation for usage
See this documentation for usage
See this documentation for usage
See this documentation for usage
See this documentation for usage
See this documentation for usage
See this documentation for usage
See this documentation for usage