Database Testing

Loadmill allows users to execute various queries directly to their DB in order to validate data. This is a very powerful feature as it allows users to check data integrity and accuracy.

Usage

Postgres

To execute a database query:

1. Go to the relevant test flow within your Test Suite.

2. Request Method: POST.

3. Request URL: https://db-relay-service.loadmill.com/api/postgres

4. Content Type: application/json

5. Request Body:

{
  "connectionString": "postgres://...",
  "query": "SELECT * FROM USERS"
}

See the request example below:

Running this request will return a JSON response with the required data.

MongoDB

To execute MongoDB queries:

1. Apply the same steps above.

2. Request URL: https://db-relay-service.loadmill.com/api/mongo

3. Request Body:

In this example we're searching for a user with the name "John"

{
  connectionString: 'mongodb://...',
  collection: 'users',
  command: 'find',
  query: { "name":"John" }
}

The MongoDB service is initially meant for "read-only" purposes (i.e. find). However, using a Docker image privately allows you to use the environment variable ALLOW_ALTERING=true and by doing so the following options are available: insertOne, insertMany, updateOne, updateMany, deleteOne and deleteMany.

MongoDB Altering Example Options

InsertOne:

{
  connectionString: 'mongodb://...',
  collection: 'users',
  command: 'insertOne',
  query: { "name": "John", "age": "56" }
}

updateOne:

{
  connectionString: 'mongodb://...',
  collection: 'users',
  command: 'updateOne',
  query: { "name":"John" },
  update: { "$set": { "age": "67" } }
}

deleteOne:

{
  connectionString: 'mongodb://...',
  collection: 'users',
  command: 'deleteOne',
  query: { "name":"John" }
}

Additional help regarding update operators can be found here.

Redis

To execute Redis queries:

1. Request Method: POST.

2. Request URL: https://db-relay-service.loadmill.com/api/redis

3. Request Body:

{
    connectionString: "redis://...", 
    command:"get | hget | hgetall",
    key:"any-key",
    field: "any-field"
   }

MySQL

To execute queries directly to MySQL 5.7:

1. Request Method: POST.

2. Request URL: https://db-relay-service.loadmill.com/api/mysql

3. Request Body:

{  
  "connectionString": "mysql://...",
  "query": "SELECT * FROM TASKS"
}

Oracle

1. Request Method: POST.

2. Request URL: https://db-relay-service.loadmill.com/api/oracle

3. Request Body:

https://<www.your-domain.com>/api/oracle

body: {
  connectionString: 'host[:port][/service_name]'
  user: 'database-user'
  password: 'mypw'
  query: 'SELECT * FROM table_name'
}

DB relay service static IPs

Executing queries to your environment DB may require VPN. You can easily overcome this by whitelisting the DB relay service static IPs: [52.42.51.230, 54.190.108.53] in your firewall.

Docker image

You can use a Docker image for DB relay service to deploy it in a specific environment.

Find more information here.