#csv #compare #diff #difference #config-file #image #file-metadata

bin+lib havocompare

A flexible rule-based file and folder comparison tool and crate including nice html reporting. Compares CSVs, JSON, text files, pdf-texts and images.

28 releases

0.6.1 Jun 5, 2024
0.5.4 Mar 18, 2024
0.5.2 Dec 15, 2023
0.5.1 Nov 12, 2023
0.1.4-RC2 Nov 25, 2022

#55 in Filesystem

Download history 336/week @ 2024-08-15 277/week @ 2024-08-22 218/week @ 2024-08-29 221/week @ 2024-09-05 186/week @ 2024-09-12 186/week @ 2024-09-19 251/week @ 2024-09-26 303/week @ 2024-10-03 535/week @ 2024-10-10 489/week @ 2024-10-17 394/week @ 2024-10-24 359/week @ 2024-10-31 418/week @ 2024-11-07 356/week @ 2024-11-14 268/week @ 2024-11-21 122/week @ 2024-11-28

1,259 downloads per month

MIT license

205KB
5.5K SLoC

Havocompare - a folder comparison utility

Crates.io Documentation CI Coverage Status License

Contributors:

Contributors

Quickstart

0. Install havocompare

You have rust? cool! try: cargo install havocompare

You just want a binary: Check our binary downloads on github-pages

1. Create a config file

Havocompare was developed with a few design goals in mind. We wanted a human-readable and easily composable configuration file format. After a few tries we ended up with the current format, which is a list of rules inside a yaml file. See the following example config.yaml:

rules:
  - name: "Numerical results csv"
    # you can have multiple includes and excludes
    pattern_include:
      - "**/export_*.csv"
    # excludes are optional
    pattern_exclude:
      - "**/export_1337.csv"
    CSV:
      comparison_modes:
        - Relative: 0.1
        - Absolute: 1.0

It creates a new rule named rule including all files matching "export_*.csv" in all sub-folders but exclude " export_1337.csv". String cells will be checked for perfect identity, numbers (including numbers with units) will be checked for a relative deviation smaller than 0.1 AND absolute deviation smaller than 1.0.

Comparison rules

  • Relative means validity is checked like: |nominal - actual| / |nominal| < tolerance
  • Absolute means validity is checked like: |nominal - actual| < tolerance
  • "nan" and "nan" is equal
  • 0 difference with 0 nominal value is valid for any relative difference

2. Run the compare

Running the comparison is super easy, just supply nominal, actual and the config: ./havocompare compare nominal_dir actual_dir config.yaml The report of the comparison will be written inside the ./report folder. Differences will also be printed to the terminal. Furthermore, if differences are found, the return code will be 1, if no differences are found, it will be 0 making integration of havocompare into a CI system rather easy.

Details on the config

Validation Scheme

Writing a valid configuration file can be error-prone without auto-completion. We suggest using json schema to validate your yaml and even enable auto-completion in IDEs like pycharm. To generate the schema you can call: ./havocompare schema > config_scheme.json and import the resulting scheme into your IDE.

Comparison options

CSV

The comparison_modes option is required and of type 'list'. It can comprise either a relative numerical ('Relative') maximum deviation or a maximum deviation ('Absolute'). You can specify the decimal separator and the field separator. If you don't specify, havocompare will try to guess it from each csv file. Note: If delimiters are not specified, even different delimiters between nominal and actual are accepted as long as all deviations are in bounds. To ignore specific cells, you can specify an exclusion regex.

The preprocessing steps are done after the file is parsed using the given delimiters (or guessing) but before anything else. Processing order is as written in the list. In the below example, headers will be extracted from the csv-input file, then a column with the title "Column to delete" will be deleted. If any of the preprocessing steps fail, havocompare will exit with an error immediately so use them carefully.

See the following example with all optional parameters set:

rules:
  - name: "CSV - Demo all options"
    # what files to include - use as many as make sense to reduce duplication in your rules
    pattern_include:
      - "**/*.csv"
    # optional: of all included files, remove the ones matching any exclude pattern
    pattern_exclude:
      - "**/ignored.csv"
    CSV:
      # delimiters are optional, if not given, they will be auto-detected.
      # auto-detection allows different delimiters for nominal and actual
      decimal_separator: '.'
      field_delimiter: ';'
      # can have Absolute or Relative or both
      comparison_modes:
        - Absolute: 1.0
        - Relative: 0.1
      # optional: exclude fields matching the regex from comparison
      exclude_field_regex: "Excluded"
      # optional: preprocessing of the csv files
      preprocessing:
        # extracts the headers to the header-fields, makes reports more legible and allows for further processing "ByName".
        # While it may fail, there's no penalty for it, as long as you don't rely on it.
        - ExtractHeaders
        # Sort the table by column 0, beware that the column must only contain numbers / quantities
        - SortByColumnNumber: 0
        # Delete a column by name, needs `ExtractHeaders` first - delete sets all values to 'DELETED'
        - DeleteColumnByName: "Vertex_Position_Y"
        - DeleteColumnByNumber: 1
        # Sorts are stable, so a second sort will keep the first sort as sub-order.
        - SortByColumnName: "Vertex_Position_X"
        # Deletes the first row by setting all values to 'DELETED' - meaning that numbering stays constant 
        - DeleteRowByNumber: 0
        # Deletes rows having any element matching the given regex (may delete different lines in nom / act)!
        - DeleteRowByRegex: "Vertex_Count"
        # Deletes the cell (column, row) by setting the value to 'DELETED'
        - DeleteCellByNumber:
            column: 0
            row: 0
        # Deletes the cell (column name, row) by setting the value to 'DELETED'. This needs `ExtractHeaders`
        - DeleteCellByName:
            column: "Column to delete"
            row: 0

Image comparison

Image comparison is done using the image compare crate. Specify loads of options here and then filter on threshold.

rules:
  - name: "JPG comparison"
    pattern_include:
      - "**/*.jpg"
    # exclude can of course also be specified!
    Image:
      # Compare images in RGBA-mode, can also be RGB and Gray
      # Comparison mode set to Hybrid means we want MSSIM on the Y channel and 2 dim vec diff on UV for color information
      RGBA: Hybrid
      threshold: 0.9

Plain text comparison

For plain text comparison the file is read and compared line by line. For each line the normalized Damerau-Levenshtein distance from the strsim crate is used. You can ignore single lines which you know are different by specifying an arbitrary number of ignored lines:

rules:
  - name: "HTML-Compare strict"
    pattern_exclude:
      - "**/*_changed.html"
    pattern_include:
      - "**/*.html"
    PlainText:
      # Normalized Damerau-Levenshtein distance
      threshold: 1.0
      # All lines matching any regex below will be ignored
      ignore_lines:
        - "stylesheet"
        - "next_ignore"
        - "[A-Z]*[0-9]"

PDF text comparison

For PDF text comparison the text will be extracted and written to temporary files. The files will then be compared using the Plain text comparison:

rules:
  - name: "PDF-Text-Compare"
    pattern_exclude:
      - "**/*_changed.pdf"
    pattern_include:
      - "**/*.pdf"
    PDFText:
      # Normalized Damerau-Levenshtein distance
      threshold: 1.0
      # All lines matching any regex below will be ignored
      ignore_lines:
        - "stylesheet"
        - "next_ignore"
        - "[A-Z]*[0-9]"

Hash comparison

For binary files which cannot otherwise be checked we can also do a simple hash comparison. Currently, we only support SHA-256 but more checks can be added easily.

rules:
  - name: "Hash comparison strict"
    pattern_exclude:
      - "**/*.bin"
    Hash:
      # Currently we only have Sha256
      function: Sha256

File metadata comparison

For the cases where the pure existence or some metadata are already enough.

rules:
  - name: "Metadata comparison"
    pattern_exclude:
      - "**/*.bin"
    FileProperties:
      # nom/act file paths must not contain whitespace
      forbid_name_regex: "[\\s]"
      # files must have their modification timestamp within 3600 seconds
      modification_date_tolerance_secs: 3600
      # files sizes must be within 1 kb 
      file_size_tolerance_bytes: 1024

Run external comparison tool

In case you want to run an external comparison tool, you can use this option

rules:
  - name: "External checker"
    pattern_include:
      - "*.pdf"
    External:
      # this config will call `/usr/bin/pdf-diff --only-images nominal.pdf actual.pdf`
      # return code will decide on comparison result
      executable: "/usr/bin/pdf-diff"
      # optional: add as many extra params as 
      extra_params:
        - "--only-images"

JSON comparison

Compares JSON files for different keys in both files and mismatches in values. ignore_keys is a list of regexes that are matched against the individual key names, the key value pair is excluded from the comparison if a regex matches. The values are not affected by this.

rules:
  - name: "Compare JSON files"
    pattern_include:
      - "**/*.json"
    Json:
      ignore_keys:
        # drop "ignore_this_key" and "ignore_this_keys" with this regex :)
        - "ignore_this_key(s?)"

Use HavoCompare in your unit-tests

  1. Add havocompare to your dev-dependencies:
    [dev-dependencies]
    havocompare = "0.5"
    
  2. Use it in a unit-test like
    #[test]
    // works in 0.5 series
    fn integ_test_dirs() {
      let result_dir = process_whatever_test_data();
      // just write the usual yaml file
      let result = havocompare::compare_folders("../tests/data/nominal/integ_test/case", &result_dir, "../tests/data/config.yaml", "../tests/out_report").unwrap;
      assert!(result);
    }
    #[test]
    // works starting with 0.5.3 only
    fn integ_test_file() {
      let result_file = process_generate_image();
      // see docs for all options
      let compare_mode = ComparisonMode::Image(ImageCompareConfig{threshold: 0.97});
      let result = havocompare::compare_files("../tests/data/nominal.png", &result_file, &compare_mode).unwrap;
      assert!(result);
    }
    

Changelog

0.6.1

  • Add new version of json-diff, featuring a better API and better filtering options

0.6.0

  • Add new options for image compare module (a lot of options!)
  • Bump json-compare to new version fixing bugs in regex field excludes and sorting

0.5.4

  • Add option to run single file mode from CLI

0.5.3

  • Add option to sort json arrays (including deep sorting)
  • Make single file comparison function to public api
  • Update dependencies, fix broken pdf import regarding whitespaces

0.5.2

  • Preserve white spaces in CSV and PDF report instead of being collapsed by HTML
  • Add + and - symbols to the report index
  • Display combined file names in report index if the compared file names are different

0.5.1

  • Fix potential crash in JSON checking

0.5.0

  • Add JSON checking

0.4.0

  • Separate reporting logic from comparison logic
  • Implement a machine-readable JSON reporting

0.3.2

  • Allow direct opening of reports after comparison with --open
  • Parsing failures when running compare are now propagated to terminal

0.3.1

  • Fix swapped actual and nominal for hash and text-compares

0.3.0

  • Allow RGBA image comparison
  • Add file metadata comparison
  • Add external checking
  • Add and adjust reports for file metadata comparison and external checking
  • Add csv header comparison. Previously, the report only marks the differences but not returning any error.
  • Added config yaml validation command to check whether file can be loaded or not

0.2.4

  • add check for row lines of both compared csv files, and throw error if they are unequal
  • Add deletion by cell
  • Simplify report sub-folders creation: sub-folders are now created temporarily in the temp folder instead of in the current working folder
  • Change report row numbering to always start with 0, so row deletion is more understandable
  • fix floating point value comparison of non-displayable diff values

0.2.3

  • bump pdf-extract crate to 0.6.4 to fix "'attempted to leave type linked_hash_map::Node<alloc::vec::Vec<u8>, object::Object> uninitialized'"

0.2.2

  • Include files which has error and can't be compared to the report
  • Fixed a bug which caused the program exited early out of rules-loop, and not processing all

0.2.0

  • Deletion of columns will no longer really delete them but replace every value with "DELETED"
  • Expose config struct to library API
  • Fixed a bug regarding wrong handling of multiple empty lines
  • Reworked CSV reporting to have an interleaved and more compact view
    • Display the relative path of compared files instead of file name in the report index.html
    • Made header-extraction fallible but uncritical - can now always be enabled
  • Wrote a completely new csv parser:
    • Respects escaping with ''
    • Allows string-literals containing unescaped field separators (field1, "field2, but as literal", field3)
    • Allows multi-line string literals with quotes
  • CSVs with non-rectangular format will now fail

0.1.4

  • Add multiple includes and excludes - warning, this will break rules-files from 0.1.3 and earlier
  • Remove all unwrap and expect in the library code in favor of correct error propagation
  • Add preprocessing options for CSV files
  • Refined readme.md
  • fix unique key creation in the report generation
  • Add PDF-Text compare

0.1.3:

  • Add optional cli argument to configure the folder to store the report

0.1.2:

  • Add SHA-256 comparison mode
  • Fix BOM on windows for CSV comparison

0.1.1:

  • Better error message on folder not found
  • Better test coverage
  • Fix colors on Windows terminal
  • Extend CI to Windows and mac

Dependencies

~33–45MB
~678K SLoC