schemachange icon indicating copy to clipboard operation
schemachange copied to clipboard

Added Always First Functionality

Open CaptCorpMURICA opened this issue 1 year ago • 7 comments

This pull request resolves #164.

  • This enables the new file type F__*.sql which is processed before all other file types.
  • This option defaults to False but can be enabled with the configuration -af or --always-first. This ensures that these files can be selectively executed depending on the environment.
    • e.g. In the CI/CD pipeline, you enable this configuration option when you need to clone the production environment to create the QA environment. However, this option is turned off for the elevation from QA to Prod because no cloning operation is taking place.
  • Tests were added to ensure the functionality works as designed. These tests cove:
    • Returning the proper number of files executed when the option is turned on or off.
    • Returning expected errors based on naming conventions.
    • Validating the appropriate data for the Change History Table.
  • Added this new functionality to the README documentation.

CaptCorpMURICA avatar Apr 26 '23 17:04 CaptCorpMURICA