testcafe-reporter-db

This is the db reporter plugin for TestCafe.

Table of Contents

• DB Engines supported
• Getting Started
  • Installation
  • Initial Configuration
  • Database Configuration
• Usage
• Roadmap
• Contributing
• License
• Author
• Acknowledgements

DB Engines supported

• MySQL

Getting Started

Installation

npm install testcafe-reporter-db

Initial Configuration

In order to use the reporter correctly, you have to edit or create the .env file, by adding the following required environment variables:

Database connection details /play 56k

TESTCAFEREPORTER_DB_USERNAME=
TESTCAFEREPORTER_DB_PASS=
TESTCAFEREPORTER_DB_HOST=

Database and table details

TESTCAFEREPORTER_DB_DB=
TESTCAFEREPORTER_DB_RUN_RESULTS_TABLE=
TESTCAFEREPORTER_DB_TEST_TABLE=

Tescafe Reporter configuracion. If you are interested in store each test result, you should use 1. If you are interested in store only failed results, the value should be 0.

TESTCAFEREPORTER_DB_TESTSTORED=
TESTCAFEREPORTER_DB_DEVICE=
TESTCAFEREPORTER_DB_BROWSER=
TESTCAFEREPORTER_DB_ENV=
TESTCAFEREPORTER_DB_OTHER_RUN=
TESTCAFEREPORTER_DB_OTHER_TEST=

Database Configuration

• Run_results_table

Fields:

| Field | Type | Lenght | Allow Null | Extra | | ------------- | ------------- | ------------- | ------------- | ------------- | | id | Int | 11 | No | auto_increment | | date | Datetime | | No | auto_increment | | run_number | Int | 11 | No | None | | run_result | Varchar | 1 | No | None | | test_total | Int | 4 | No | None | | test_passed | Int | 4 | No | None | | test_failed | Int | 4 | No | None | | test_skipped | Int | 4 | No | None | | test_duration | Varchar | 10 | No | None | | test_device | Varchar | 50 | Yes | None | | test_browser | Varchar | 150 | Yes | None | | test_environment | Varchar | 50 | Yes | None | | test_other_1 | Varchar | 50 | Yes | None |

• run_result : 0 if the run passed. 1 if the run failed.

• Test_results_table

| Field | Type | Lenght | Allow Null | Extra | | ------------- | ------------- | ------------- | ------------- | ------------- | | id | Int | 11 | No | auto_increment | | run_number | Int | 11 | No | None | | fixture_name | Varchar | 1000 | No | None | | test_name | Varchar | 1000 | No | None | | test_result | Int | 1 | No | None | | test_other | Varchar | 100 | No | None |

• test_result : 0 if the test passed. 1 if the test failed. 2 if the test was skipped

Usage

When you run tests from the command line, specify the reporter name by using the --reporter option:

testcafe chrome 'path/to/test/file.js' --reporter db

When you use API, pass the reporter name to the reporter() method:

testCafe
    .createRunner()
    .src('path/to/test/file.js')
    .browsers('chrome')
    .reporter('db') // <-
    .run();

Roadmap

Contributing

• If you want to suggest a change, feature or any question, feel free to open an issue or a pull request.

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Author

• Acebano :flower_playing_cards:

+Based on testcafe-reporter-list+

Acknowledgments

• AlexHoma
• MarioSanchez