CSV exporter

The CSV exporter generates a flat CSV file with one row per test case and detailed Excel files for failed tests.

Output structure

{output_path}/csv/
├── test_results.csv              → Summary of all test cases
└── test_results/
    ├── Test case 1.xlsx          → Gap details (only for failed tests)
    └── Test case 2.xlsx

CSV columns

Column	Description
`executionid`	Unique identifier for the test run
`name`	Test case name
`state`	Result: `passed`, `failed`, `error`, `notExecuted`
`sourcestart`	Source data loading start time
`sourceend`	Source data loading end time
`sourceduration`	Source loading duration in seconds
`sourcecount`	Number of rows in source dataset
`sourceexecutedaction`	Query or path executed for source
`expectedstart`	Expected data loading start time
`expectedend`	Expected data loading end time
`expectedduration`	Expected loading duration in seconds
`expectedcount`	Number of rows in expected dataset
`expectedexecutedaction`	Query or path executed for expected
`comparestart`	Comparison start time
`compareend`	Comparison end time
`compareduration`	Comparison duration in seconds
`successrate`	Percentage of matching rows (0.0 to 1.0)
`errortype`	Error category: `headers`, `count`, `data`, `compare`
`errormessage`	Error description
`errordetailfilepath`	Path to the XLSX gap analysis file

Usage

Command line

ploosh --connections connections.yml --cases test_cases --export CSV

Python API

from ploosh import execute_cases
executecases(cases="testcases", connections="connections.yml", path_output="./output")
Then manually set export format — CSV export is available via CLI --export flag

Gap analysis Excel files

For each failed test case, an XLSX file is generated showing the differences between source and expected datasets with side-by-side comparison of values.

ploosh.

Documentation