Automated validations for Couchbase NoSQL database – ACCELQ

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

Establishing Connection

Connect to Couchbase DB server

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

Note that the session is accessible only within the Action where you execute this command.

Session name

Host name

Port

Bucket name

Username

Password

SSL support

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

Host name where Couchbase DB is running

Port number on which Couchbase DB is running

Name of the bucket

Username for authentication

Password for authentication

SSL support Enabled (Yes / No)

Session Management

Switch to Couchbase DB Session

Switches to given Couchbase database session, when you are working with multiple database connections simultaneously. Make sure the session is already established with a connection command.

session reference name

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

Close current Couchbase DB session

Closes the current Couchbase database session. After closing a session, either create another session or switch to one of the already existing sessions before working with the DB again.

Querying Data

Get document in Couchbase bucket

Gets document in current Couchbase DB session bucket with given document id. Make sure that a session is already established.

Document id

Returns

Document id in bucket whose value should be retrieved

Couchbase document in JSON format

Get document field value in Couchbase bucket

Gets field value of a document in current Couchbase DB session. Make sure that a session is already established.

Document id

Field name

Returns

Document id in bucket

Name of the field in the document whose value should be retrieved. Field name should be specified in standard JSON path format.

Field value of a document in current Couchbase DB session.

Execute Couchbase DB Query

Executes a query on current Couchbase DB session.

Query

Returns

Query to be executed on Couchbase DB

Query execution result in JSON format

Updating Data

Insert document in Couchbase bucket

Inserts document in current Couchbase DB session bucket with given document id. Document must be in JSON format. Make sure that a session is already established.

New document id

New document

New document id for the document to insert, make sure this is unique in Couchbase bucket

Document in the JSON format that is to be added in the bucket

Update document in Couchbase bucket

Updates document in current Couchbase DB session bucket by given document id. Document must be in JSON format. Make sure that a session is already established.

Document id

New document

Document id in bucket, make sure document id already exists in Couchbase bucket

Document in JSON format that is to be updated in the bucket

Upsert document in Couchbase bucket

Updates/Creates document in current Couchbase DB session bucket with given document id. Document must be in JSON format. If document does not exist, it creates new document with given document id. Otherwise, updates the existing document. Make sure that a session is already established.

Document id

New document

Document id in bucket

Document in JSON format to insert/update in the bucket

Delete document in Couchbase bucket

Deletes document with given document id in current Couchbase DB session bucket. Make sure that a session is already established.

Document id

Document id, make sure it exists in Couchbase bucket

Verifying Results

Verify document field value in Couchbase bucket Is

Verifies document filed value of given field name in current Couchbase DB session bucket by document id. Make sure that a session is already established.

Document id

Field name

Expected value

Comparison type

Match type

Failure action

Document id in bucket

Name of the field in the document whose value should be verified. Field name can be specified in standard JSON path format

Expected value against which the field value is verified

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

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

Specify if the verification failed, whether continue test case or abort test case

Verify document field value in Couchbase bucket Is NOT

Verifies document filed value of given field name in current Couchbase DB session is NOT a given value. Make sure that a session is already established.

Document id

Field name

Expected value

Comparison type

Match type

Failure action

Document id in bucket

Name of the field in the document whose value should be verified. Field name can be specified in standard JSON path format

Expected value against which the field value is verified

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

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

Specify if the verification failed, whether continue test case or abort test case