🔭 High Level

Test Miner was designed to parse NUnit3 Test Reports and store the results into a Relational Database.

The Database would provide users with the means to historically track and monitor trends of Test Results.

Simple Flow:

---
config:
  theme: redux-dark
  look: classic
  layout: fixed
---
flowchart LR
    A(["Start with"]) --> B["NUnit Report"]
    B --> C["Test Miner"]
    C --> D["Database"]
    B@{ shape: out-in}
    D@{ shape: db}

Loading

Prerequisites

Prerequisite	Note
.NET8 SDK	.NET8 or greater required. Check current .NET version dotnet --version. Download .NET8 here.
SQL Server	The Database template can be found within this repository here. Download SQL Server Express here. You're on the hook to pay for the storage. 😂
NUnit3 Test Results	The NUnit3 Test Results must be in XML format. Use --result=TestResult.xml;format=nunit3 when executing tests.

🖥️ Test Miner Console Application

Specify the following commands & arguments:

🛠️Command Line Interface Usages

⛏️ mine

Mine Test Report files to the Database.

mine [parameters]

Parameters

Argument	Description	Default	Required
--reports <filePath>	File paths of the NUnit3 Test Report files to upload ("mine") to the Database. Can specify multiple file paths.	—	Yes
--connection <connectionString>	The Connection String to the Database.	—	No

Example

TestMiner.exe mine --reports "C:\SampleData\TestResults1.xml" --connection "Server=localhost\\SQLEXPRESS;Database=TestMiner;"

💾 save

Saves the Database Connection String locally.

save [parameters]

Parameters

Argument	Description	Default	Required
--connection <connectionString>	The Connection String to the Database.	—	Yes

Example

TestMiner.exe save --connection "Server=localhost\\SQLEXPRESS;Database=TestMiner;"

💽 Database

The Database project exists at TestMiner.Database; you can publish this Database to your own SQL Server instance.

I have included guidance on how to deploy the Database to localhost for testing (with Docker) here

🖥️ Test Miner Windows

A Windows application exists that wraps all the CLI functionality in a GUI format, TestMiner.Windows.

🧪 Testing

• Unit Testing
  • TestMiner.Tests
  • TestMiner.Models.Tests
• Component Testing
  • TestMiner.Database.Component.Tests
• Integration Testing
  • TestMiner.Integration.Tests
• Mutation Testing
  • Strkyer.NET with my GitHub Action