pytest-historic

Pytest-historic is a free, custom html report which provides historical pytest execution results by storing execution results info in MySQL database and generate's html reports (charts / statistics) from database using Flask.

MYSQL + Flask + pytest

---

Pytest Historic Overview

More Images here

---

Features

• Support Historic Results
• Visualization of executions
• Search Historical test records by name / status / execution id
• Local hosted (meets privacy concerns)
• Flakiness
• Compare executions
• Generate Pytest-metrics report
• Custom comments on failures (Supports html tags)
• Export results (Excel, CSV, Print, Copy)

---

Why pytest-Historic

• It is free
• Made by QA
• Can customize as per requirements
• No code changes required

---

How it Works:

• Get execution details using hooks

• Store execution results in local / remote hosted MySQL database

• Generate html report using Flask

  

---

Requirements

• Python 3.7 or above
• Pytest
• MySQL DB

---

Installation

• Step 1: Download and Install MySQL Server - guide

• Step 2: Install pytest-historic

  Case 1: Using pip

  pip install pytest-historic==0.1.2
  

  Case 2: Using setup.py (root)

  python setup.py install
  

  Case 3: Using git (latest changes)

  pip install git+https://github.com/adiralashiva8/pytest-historic
  

• Step 3: Create pytesthistoric default user with permissions - guide

• Step 4: Create pytesthistoric.TB_PROJECT table - guide

• Step 5: Install pytest-historic-hook

  pip install pytest-historic-hook==0.1.2
  

  Note: Above all actions are one time activities

  Help / Command line options

  To view available command line options use --help

  pytesthistoric --help
  

---

How to use in project

• Step 1: Create project in pytest-historic - guide

• Step 2: Push execution results to project - guide

• Step 3: Open pytest-historic to view historical results

---

Thanks for using pytest-historic

• What’s your opinion on this report?
• What’s the feature I should add?

If you have any questions / suggestions / comments on the report, please feel free to reach me at

• Email: adiralashiva8@gmail.com
• LinkedIn: shivaprasadadirala
• Twitter: @ShivaAdirala

---

Special Thanks To

Feedback & Suggestions

• Rahul Parwal

---

⭐ repo if you like it

Inspired from Robotframework-Historic

---