Automating MongoDB validation – ACCELQ

Following commands in action logic editor help you work with MongoDB, automate querying and verification against the database. All CRUD operations are supported.

Establishing Connection

Connect to MongoDB server

Establishes a MongoDB session by connecting with given credentials. This command must be used before performing any other MongoDB related steps in the action. This statement also sets the Current Session, so subsequent commands executed on MongoDB will run against this connection.

Session Name

Server

Port

Database Name

User Name

Password

SSL Enabled

Unique name for the session to refer to this connection in the current action logic. 

MongoDB server name

Port number on which MongoDB is running

Name of the database

User name

Password to authenticate

Is the SSL Enabled (Yes/No)

Switch to MongoDB Session

Switches to given MongoDB Session, when you are working with multiple MongoDB sessions simultaneously. Make sure that session is already established with a Connection command before executing this.

Session Name

Name of the session to switch to. Any subsequent MongoDB commands will run against this session.

Querying Data

Get field count for document index in MongoDB Collection

Returns the number of fields for given document index in MongoDB Collection. Make sure that a session is already established.

Collection Name

Document Index

Returns

Name of the collection in the MongoDB

Index of the document which should be referenced. Index starts from 1.

Size of the collection

Get field value for field at document index in MongoDB Collection

Returns value of given document index in MongoDB Collection. Make sure that a session is already established.

Collection Name

Document Index

Field Name

Returns

Name of the collection in the MongoDB

Index of the document which should be referenced. Index starts from 1.

Name of the field in the document whose value should be retrieved.

Field value present in the given document of a MongoDB collection

Get document at index from MongoDB Collection

Returns document at a given index in a MongoDB Collection. Make sure that a session is already established.

Collection Name

Document Index

Returns

Name of the collection in the MongoDB

Index of the document which should be referenced. Index starts from 1.

Document at the given index in a MongoDB collection in the json format

Get documents matching filter in MongoDB Collection

Returns Filtered documents for a given filter criteria in MongoDB Collection. Make sure that a session is already established.

Collection Name

Filter Criteria

Returns

Name of the collection in the MongoDB

Specify the filter in the json format based on which are documents are identified. 

 Documents that are filtered based on the constraint

Get documents count in MongoDB Collection

Returns the number of documents in a given MongoDB Collection. Make sure that a session is already established.

Collection Name

Returns

Name of the collection in the MongoDB

Total document count present in the MongoDB collection

Get field names for document index in MongoDB Collection

Returns names of fields for given document index of MongoDB Collection. Make sure that a session is already established.

Collection Name

Document Index

Returns

Name of the collection in the MongoDB

Index of the document which should be referenced. Index starts from 1.

 All field names present in the given document of the MongoDB collection

Get document count matching filter in MongoDB Collection

Returns count of filtered documents for a given filter criteria in MongoDB Collection. Make sure that a session is already established.

Collection Name

Filter Criteria

Returns

Name of the collection in the MongoDB

Specify the filter in the json format based on which document count is learnt.

Total document count present in the MongoDB collection considering the filter.

Verifying Results

Verify MongoDB Collection document field value Is

Verifies given field has given value for document at given index in MongoDB Collection. Make sure that a session is already established.

Collection Name

Document Index

Comparison Type

Field name

Match Type

Expected Value Check

Returns

Name of the collection in the MongoDB

Index of the document which should be referenced. Index starts from 1

Specify if the comparison should be "equals" or "contains" 

Name of the field whose value should be compared

Specify if the match should be "case sensitive" or "insensitive"  or "regular expression".

value that to be verified with the original field value

True or False based on the comparison

Verify document count matching filter in MongoDB Collection

Verifies count of filtered documents for a given filter criteria in MongoDB Collection. Make sure that a session is already established.

Collection Name

Expected Count

Filtered Criteria check

Returns

Name of the collection in the MongoDB

Expected document count that to be compared with the original document count of given MongoDB collection

Specify filter in the json format based on which original document count is learnt.

True or False based on the comparison

Verify MongoDB Collection document field value Is Not

Verifies given field for document index in MongoDB Collection. Make sure that a session is already established.

Collection Name

Expected Count

Filtered Criteria check

Returns

Name of the collection in the MongoDB

Expected document count that to be compared with the original document count of given MongoDB collection

Specify filter in the json format based on which original document count is learnt.

True or False based on the comparison

Updating Data

Add new document to MongoDB Collection

Inserts JSON document to given Collection. Make sure that a session is already established

Collection Name

New Document

Name of the collection in the MongoDB

Document in the json format that is to be added in the collection.

Update documents in MongoDB Collection

Updates filtered documents with updated values as JSON in given Collection. Make sure that a session is already established.

Collection Name

Filter Criteria

Values

Returns

Name of the collection in the MongoDB

Specify the filter in the json format based on which documents need to be identified.

Specify the new value that is to be updated

Total number of documents that got affected

Delete documents In MongoDB Collection

Delete Filtered documents in Collection. Make sure that a session is already established.

Collection Name

Filter Criteria

Returns

Name of the collection in the MongoDB

Specify the filter in the json format based on which documents need to be deleted.

Total number of documents that got affected