v0.0.3

Implement vars

v0.0.2

Add assetsQLCheck 0.0.2 introduces significant improvements to database connection handling, enhanced assessment capabilities, and better error handling. This release focuses on modularity, simplicity, and providing more flexible configuration options for database connections.

New Features

Enhanced Connection Configuration

• YAML Configuration Support: Added support for YAML-based connection configuration files for better organization and credential management
  • Default locations: ~/.config/sqlcheck/connections.yaml or ~/.dtk/connections.yml
  • Environment variable expansion in YAML files (e.g., ${DB_PASSWORD})
  • Support for both URL format and structured connection parameters
• Multiple Connection Prefixes: Support for both SQLCHECK_CONN_{NAME} and DTK_CONN_{NAME} environment variables for compatibility
• Default Connection: New SQLCHECK_CONN_DEFAULT and DTK_CONN_DEFAULT for setting default connections when -c flag is omitted

Assessment Capabilities

• Multiple Assess Directives: Added support for multiple {{ assess(...) }} directives in a single SQL file
• Enhanced stdout/stderr Checks: New assessment tests for validating standard output and error streams
• Fail-fast Control: Moved fail-fast control to directives for more granular test control

Improvements

Refactoring & Code Quality

• Refactored database connection handling for better modularity
• Simplified discovery and execution modules
• Enhanced execution retry logic and context handling
• Improved parallel/serial case processing
• Removed unused components and test files
• Simplified connector naming in helpers

Error Handling

• Enhanced error handling in main function to display help message for missing commands
• Better error messages for connection configuration issues

Documentation

• Updated README with comprehensive connection configuration documentation
• Added GitHub installation instructions
• Clarified database connection options and driver requirements
• Updated connector driver hints to use extras