PyTestLog2DB 0.4.2

Table of Contents

• Getting Started

  • How to install

• Usage

• Example

• Contribution

• Sourcecode Documentation

• Feedback

• About

  • Maintainers

  • Contributors

  • License

Getting Started

PyTestLog2DB is a command-line tool that enables you to import pytest XML result files into TestResultWebApp’s database for presenting an overview about the whole test execution and detail of each test result.

PyTestLog2DB tool is operating system independent and only works with Python 3.

Usage

PyTestLog2DB requires the pytest result file(s) which contains the test result in JUnit XML format and TestResultWebApp’s database information for importing.

Use below command to get tools’s usage

PyTestLog2DB -h

The usage should be showed as below:

usage: PyTestLog2DB (PyTestXMLReport to TestResultWebApp importer) [-h] [-v] [--recursive] [--dryrun] [--append] [--UUID UUID] [--variant VARIANT] [--versions VERSIONS] [--config CONFIG]
                                                                   resultxmlfile server user password database

PyTestLog2DB imports pytest JUnit XML report file(s)generated by pytest into a WebApp database.

positional arguments:
resultxmlfile        absolute or relative path to the pytest JUnit XML report file or directory of report files to be imported.
server               server which hosts the database (IP or URL).
user                 user for database login.
password             password for database login.
database             database schema for database login.

optional arguments:
-h, --help           show this help message and exit
-v, --version        version of the PyTestLog2DB importer.
--recursive          if set, then the path is searched recursively for output files to be imported.
--dryrun             if set, then verify all input arguments (includes DB connection) and show what would be done.
--append             is used in combination with --UUID <UUID>. If set, allow to append new result(s) to existing execution result UUID in --UUID argument.
--UUID UUID          UUID used to identify the import and version ID on webapp. If not provided PyTestLog2DB will generate an UUID for the whole import.
--variant VARIANT    variant name to be set for this import.
--versions VERSIONS  metadata: Versions (Software;Hardware;Test) to be set for this import (semicolon separated).
--config CONFIG      configuration json file for component mapping information.
--interface {db,rest}
                     database access interface.
--testrunurl TESTRUNURL
                     link to test execution job: Jenkins job, Gitlab CI/CD pipeline, ...

The below command is simple usage with all required arguments to import pytest results into TestResultWebApp’s database:

PyTestLog2DB <resultxmlfile> <server> <user> <password> <database>

Besides the executable file, you can also run tool as a Python module

python -m PyTestLog2DB <resultxmlfile> <server> <user> <password> <database>

Example

In order the import the robot result(s) to TestResultWebApp’s database, we need the pytest result file in JUnit XML format.

So, firstly execute the pytest testcase(s) to get the result file(s). But the *.xml result file is not generated by default.

We need to specify the argument –junit-xml=<path> when executing pytest to get the generated JUnit XML report file at given path.

E.g:

pytest --junit-xml=path/to/result.xml pytest/folder

After that, the *.xml result file will be available at path/to/result.xml and can be used for importing to TestResultWebApp with command:

PyTestLog2DB path/to/result.xml localhost test_user test_pw test_db

Then, open TestResultWebApp with your favourite browser and you will see how wonderful the execution result is displayed as below figures:

Dashboard view:

Datatable view:

Contribution

We are always searching support and you are cordially invited to help to improve PyTestLog2DB tool.

Sourcecode Documentation

To understand more detail about the tool’s features, parameters and how pytest result(s) will be displayed on TestResultWebApp, please refer to PyTestLog2DB tool’s Documentation.

Feedback

Please feel free to give any feedback to us via

Email to: Thomas Pollerspöck

Issue tracking: PyTestLog2DB Issues

About