How To Install python-subunit2sql on Ubuntu 18.04

In this tutorial we learn how to install python-subunit2sql on Ubuntu 18.04. python-subunit2sql is subunit file/stream to DB - Python 2.7

Introduction

In this tutorial we learn how to install python-subunit2sql on Ubuntu 18.04.

What is python-subunit2sql

python-subunit2sql is:

subunit2SQL is a tool for storing test results data in a SQL database. Like it’s name implies it was originally designed around converting subunit streams to data in a SQL database and the packaged utilities assume a subunit stream as the input format. However, the data model used for the DB does not preclude using any test result format. Additionally the analysis tooling built on top of a database is data format agnostic. However if you choose to use a different result format as an input for the database additional tooling using the DB API would need to be created to parse a different test result output format. It’s also worth pointing out that subunit has several language library bindings available. So as a user you could create a small filter to convert a different format to subunit. Creating a filter should be fairly easy and then you don’t have to worry about writing a tool like :ref:subunit2sql to use a different format.

For multiple distributed test runs that are generating subunit output it is useful to store the results in a unified repository. This is the motivation for the testrepository project which does a good job for centralizing the results from multiple test runs.

However, imagine something like the OpenStack CI system where the same basic test suite is normally run several hundreds of times a day. To provide useful introspection on the data from those runs and to build trends over time the test results need to be stored in a format that allows for easy querying. Using a SQL database makes a lot of sense for doing this, which was the original motivation for the project.

At a high level subunit2SQL uses alembic migrations to setup a DB schema that can then be used by the subunit2sql tool to parse subunit streams and populate the DB. Then there are tools for interacting with the stored data in the subunit2sql-graph command as well as the sql2subunit command to create a subunit stream from data in the database. Additionally, subunit2sql provides a Python DB API that can be used to query information from the stored data to build other tooling.

This package contains the Python 2.7 module.

There are three methods to install python-subunit2sql on Ubuntu 18.04. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install python-subunit2sql Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install python-subunit2sql using apt-get by running the following command:

sudo apt-get -y install python-subunit2sql

Install python-subunit2sql Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install python-subunit2sql using apt by running the following command:

sudo apt -y install python-subunit2sql

Install python-subunit2sql Using aptitude

If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.

sudo aptitude update

After updating apt database, We can install python-subunit2sql using aptitude by running the following command:

sudo aptitude -y install python-subunit2sql

How To Uninstall python-subunit2sql on Ubuntu 18.04

To uninstall only the python-subunit2sql package we can use the following command:

sudo apt-get remove python-subunit2sql

Uninstall python-subunit2sql And Its Dependencies

To uninstall python-subunit2sql and its dependencies that are no longer needed by Ubuntu 18.04, we can use the command below:

sudo apt-get -y autoremove python-subunit2sql

Remove python-subunit2sql Configurations and Data

To remove python-subunit2sql configuration and data from Ubuntu 18.04 we can use the following command:

sudo apt-get -y purge python-subunit2sql

Remove python-subunit2sql configuration, data, and all of its dependencies

We can use the following command to remove python-subunit2sql configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge python-subunit2sql

References

Summary

In this tutorial we learn how to install python-subunit2sql package on Ubuntu 18.04 using different package management tools: apt, apt-get and aptitude.