Class compareResolvers

Object
compareResolvers
public class compareResolvers extends Object
Standalone executable to compare RESOLVER (old) vs RESOLVER2 (new) results. Exit codes: 0: Both resolvers return the same result (or single resolver ran successfully) 1: Resolvers return different results 2: Parse error or file error Usage: java compareResolvers [options] Options: -v, --verbose Enable detailed output messages -r1, --resolver1 Only run and print RESOLVER (old) result -r2, --resolver2 Only run and print RESOLVER2 (new) result -m, --mode Set display name mode: DISPLAY, SQL_RENDER, or CANONICAL Default: SQL_RENDER for -r1, DISPLAY for -r2 Display Name Modes: DISPLAY - Strip delimiters, preserve original case ([OrderID] -> OrderID) SQL_RENDER - Preserve delimiters for valid SQL regeneration ([Order ID] -> [Order ID]) CANONICAL - Apply vendor-specific case folding (Oracle: MyTable -> MYTABLE) Examples: java compareResolvers oracle /path/to/query.sql java compareResolvers -v mysql /path/to/query.sql java compareResolvers -r1 oracle /path/to/query.sql # RESOLVER with SQL_RENDER java compareResolvers -r2 oracle /path/to/query.sql # RESOLVER2 with DISPLAY java compareResolvers -r2 -m SQL_RENDER oracle /path/to/query.sql # RESOLVER2 with SQL_RENDER

  • Constructor Details

  • Method Details

    • main

      public static void main(String[] args)

    • run

      public static int run(String[] args)
      Main entry point that returns an exit code.
      Parameters:
      args - command line arguments
      Returns:
      0 for same results, 1 for different results, 2 for parse/file error

    • compareResolvers

      public static int compareResolvers(EDbVendor dbVendor, String sqlFilePath)
      Compare table and column resolution results between RESOLVER and RESOLVER2.
      Parameters:
      dbVendor - The database vendor
      sqlFilePath - The path to the input SQL file
      Returns:
      2 for parse/file error, 0 for same results (or single resolver success), 1 for different results