0.0.7 • Published 3 years ago
bespoken-mysql-plugin v0.0.7
Bespoken MySQL Plugin
This plugin makes it easy to send your voice app's end-to-end test results to a sql instance for reporting and monitoring.
It leverages Bespoken's filters to report test results to MySQL.
Getting Started
Installation and Usage
To use the Bespoken MySQL Plugin, just include it in your test project dependencies with:
npm install bespoken-mysql-plugin --saveThen include it as your filter like this in the testing.json:
{
"filter": "./node_modules/bespoken-mysql-plugin/index.js"
}Environment Variables
| Variable |
|---|
| MYSQL_HOST |
| MYSQL_USER |
| MYSQL_PASSWORD |
| MYSQL_DATABASE |
| MYSQL_TABLE |
For local running, we typically recommend using the package dotenv and setting it in a file labeled .env. We have provided a file example.env you can use as a template (just copy and rename to .env).
It can also be set manually like so:
export MYSQL_HOST=<MYSQL_HOST>(Use set instead of export if using Windows Command Prompt).
SQL Columns
By default we report the results at utterance level:
| Columns |
|---|
| ID |
| TEST_SUITE_NAME |
| TIMESTAMP |
| TEST_NAME |
| TEST_SUCCESS |
| UTTERANCE |
| EXPECTED_VALUES |
| ACTUAL_TRANSCRIPT |
| UTTERANCE_SUCCESS |
| TAGS |
| CAPTION |
| DISPLAY |
| RAW |