MongoDB

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. More information.

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; }[], options?: { [key: string]: any; }) 

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

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.

options { [key: string]: any; }

(optional) Additional options that bulkWrite() passes to the MongoDB bulkWrite command. See the official MongoDB NodeJs documentation for the exact usage of these options. More information.

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; }) 

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

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; }) 

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

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; }) 

Insert one document. Equivalent to the MongoDB insertOne function. More information.

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; }) 

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

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; }) 

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

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; }) 

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

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; }) 

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

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; }) 

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

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