Added Always First Functionality

[CaptCorpMURICA]

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]

Is there an update on when this will be reviewed?

[sfc-gh-tmathew]

@CaptCorpMURICA Will discuss this next week and get back to you. Thank you for your contribution and your patience while we catchup on open items and PRs.

[jzking]

Any discussion on when this might make it into a release? Thank you

[CaptCorpMURICA]

Any discussion on when this might make it into a release? Thank you

I just welcomed my first child, so I haven't had the ability to implement the requested changes. I'll try to get it wrapped up in the next month or so.

[jzking]

Any discussion on when this might make it into a release? Thank you

I just welcomed my first child, so I haven't had the ability to implement the requested changes. I'll try to get it wrapped up in the next month or so.

Congratulations !! Let me know if I can help (with this PR, you are on your own with the baby LOL!)

[mw243270]

Any update on this one?