Testim Documentation

Welcome to the Testim documentation. You'll find comprehensive guides to help you get started quickly, example code snippets, and tips for being more productive. You will also find details about advanced features that allow you to customize Testim to fit your environment or special testing conditions. Don't worry, we'll support you if you get stuck. Let's jump right in!

Guides    Changelog

MySQL validation

Learn how to validate MySQL using the CLI action step.

You can use the CLI action step to perform queries and run validations on MySQL database.

Example code:

const dbName = "XXXXX";
const userName = "XXXXX";
const password = "XXXXX";
const host = "XXXXX";
const port = XXXXX;

const sequelize = new Sequelize(dbName, userName, password, {
  dialect: "mysql",
  host,
  port
});

return sequelize
  .query("SELECT name FROM myTable where id = 1;", {
    plain: true,
    raw: true,
    type: Sequelize.QueryTypes.SELECT
  })
  .then(myTableRows => {
    const result = myTableRows && JSON.stringify(myTableRows);
    console.log("Query result", result);
    if (!myTableRows || myTableRows.name !== expectedValue) {
      return Promise.reject(new Error("Failed to find raw"));
    }
  });

Parameters - Packages and JavaScript used in this example:

1.name: Sequelize, type: Package, value: [email protected]
2.name: mysql2, type: Package, value: [email protected]
3.name: expectedValue, type: JavaScript, value: "fdssdf dfdf"

see screenshot:

Updated 2 months ago

MySQL validation


Learn how to validate MySQL using the CLI action step.

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.