Release MergeSourceFile v1.1.1 · alegorico/MergeSourceFile

[1.1.1] - 2025-10-17

Improved DEFINE syntax support
- Enhanced regex pattern to support decimal values (e.g., DEFINE price = 3.14)
- Added support for hyphenated values (e.g., DEFINE code = ABC-123)
- Extended support for complex alphanumeric values with special characters
- Maintains full backward compatibility with existing quoted and unquoted syntax
- Validates compliance with Oracle SQL*Plus DEFINE standards
Better error reporting for DEFINE statements
- Invalid DEFINE syntax now reported in verbose mode with line numbers
- Clear distinction between ignored invalid DEFINE and successful definitions
- Examples: "Ignorando DEFINE con sintaxis invalida en linea 4: 'DEFINE var = ;'"
- Empty string values (DEFINE var = '';) now supported as valid
- Better user feedback for troubleshooting problematic variable definitions

Critical bug fix: DEFINE statements without quotes now process correctly
- Previously: DEFINE VAR = value would fail with "variable used before defined" error
- Now: Both DEFINE VAR = value and DEFINE VAR = 'value' work correctly
- Affected real-world database deployment scripts
Windows compatibility improvements
- Fixed Unicode encoding issues causing CLI integration test failures on Windows
- Replaced problematic Unicode characters (→, Á, └) with ASCII equivalents (-, A, |--)
- Improved error codes: CLI now returns proper exit codes (1) for errors
- Enhanced file path resolution for nested includes with correct base_path calculation
- All 56 tests now pass successfully on Windows systems

Comprehensive test coverage
- Added 17 new tests covering DEFINE syntax improvements and error reporting
- Enhanced integration test suite with 6 CLI tests covering all major functionality
- 100% test pass rate achieved (56/56 tests passing)
- Full coverage of edge cases including space handling and Unicode compatibility

Complete Jinja2 template support
- New CLI parameters: --jinja2 / -j to enable Jinja2 processing
- New parameter --jinja2-vars / -jv to specify JSON file with variables
- Custom filters:
  - sql_escape: Escapes single quotes for SQL
  - strftime: Date formatting
- Variable support: {{ variable }}
- Conditional support: {% if condition %}
- Loop support: {% for item in list %}
- Complex nested structure support
- Customizable delimiters
- Strict mode for undefined variables

Perfect integration with existing functionality
- Jinja2 templates are processed BEFORE SQL variables
- Maintains full compatibility with file inclusions (@, @@)
- Works together with DEFINE/UNDEFINE variables
- Cascading processing: Files → Jinja2 → SQL Variables