How iamvishwa01/bulkfilevalidator works
Bulk File Validator compares an actual CSV/XLSX dataset with an expected file or MySQL query result, pairing rows by key and producing XLSX and HTML reports. Its documented workflow streams and normalizes rows, externally sorts bounded chunks, merges by key, then checks headers, keys, and column values under optional JSON rules. The graph follows README-documented relationships; source excerpts were unavailable, so internal implementation details beyond that documentation are not inferred.
Main entry points: BulkFileComparator.java Bulk file comparator · DatabaseTest.java Database entry point · ValidationProfile.java Validation profile · JdbcQueryConfig.java JDBC query settings
Components 19
Runnable entry points
- File entry point
src/test/java/execution/Test.java - Database entry point
src/test/java/execution/DatabaseTest.java - Profile-based entry point
src/main/java/com/test/qa/utils/excel/comparision/ProfileBasedTest.java
Input and comparison
- Bulk file comparator
src/main/java/com/test/qa/utils/excel/comparision/BulkFileComparator.java - Stream and normalize
src/main/java/com/test/qa/utils/excel/comparision/BulkFileComparator.java - Bounded chunk sorting
src/main/java/com/test/qa/utils/excel/comparision/BulkFileComparator.java - Key-based merge
src/main/java/com/test/qa/utils/excel/comparision/BulkFileComparator.java - Header and value checks
src/main/java/com/test/qa/utils/excel/comparision/BulkFileComparator.java - JDBC query settings
src/main/java/com/test/qa/utils/excel/comparision/JdbcQueryConfig.java
Validation rules
- Validation profile
src/main/java/com/test/qa/utils/excel/comparision/ValidationProfile.java - JSON profile loader
src/main/java/com/test/qa/utils/excel/comparision/RuleConfigLoader.java - Column rules
src/main/java/com/test/qa/utils/excel/comparision/ColumnRule.java - Rule-based value comparison
src/main/java/com/test/qa/utils/excel/comparision/RuleBasedValueComparator.java
Reports
- Excel report
src/main/java/com/test/qa/utils/excel/comparision/BulkFileComparator.java - HTML report
src/main/java/com/test/qa/utils/excel/comparision/BulkFileComparator.java
Other components
- Actual CSV/XLSX
- Expected CSV/XLSX
- Expected SQL
- MySQL query result
Connections 19
- File entry point → Bulk file comparator: compares files
README.md - Database entry point → Bulk file comparator: runs database mode
README.md - Profile-based entry point → Bulk file comparator: runs comparison
README.md - Actual CSV/XLSX → Stream and normalize: streams rows
README.md - Expected CSV/XLSX → Stream and normalize: streams rows
README.md - MySQL query result → Stream and normalize: streams query rows
README.md - Expected SQL → Database entry point: supplies query
README.md - Database entry point → JDBC query settings: configures query
README.md - JDBC query settings → MySQL query result: connects to
README.md - Bulk file comparator → Stream and normalize: coordinates
README.md - Stream and normalize → Bounded chunk sorting: sorts bounded chunks
README.md - Bounded chunk sorting → Key-based merge: merges sorted rows
README.md - Key-based merge → Header and value checks: compares by key
README.md - JSON profile loader → Validation profile: loads and validates
README.md - Validation profile → Header and value checks: provides comparison rules
README.md - Column rules → Validation profile: defines column settings
README.md - Header and value checks → Rule-based value comparison: applies rules
README.md - Bulk file comparator → Excel report: writes workbook
README.md - Bulk file comparator → HTML report: writes report
README.md