Python desktop app

Architecture

The ui.py is the entry point for building the app into a .exe file and can be run as a standalone .py script
The ui.py calls 3 standalone apps.
The scrape_aris.py app spins up a firefox session controlled by selenium and ouputs a .xlsx and raw unstructured data in the form of .xls files.
The create_tcs.py script reads up the .xls files into panda dataframes and generates test cases in .xlsx, csv as well as on JIRA directly. The creation on JIRA is handled by the atlassian-api library. Once created the test case ID is saved in the original .xlsx file created earlier. This .xlsx file can be considered as the defacto database of the app. There is no need to switch to a regular database because 1) it is not part of the requirements 2) as of today there is a small volume of data being processed and 3) the testing flexibility offered by using an excel file.
The sync.py script reads in the .json created by the create_tcs script and the database to log any differences with the test cases living on the JIRA server
The user interface is built thanks to the opensource PyQT5 library. This library serves as a python binding to the popular qt framework written in C++
The user interface makes heavy use of the pyqtconfig open source project

Desktop App: Jira interfacing with the ARIS business process management (BPM) application
Reporting: Standalone scripts that manipulate data from Jira's REST API and output excel reports

Recommend Projects