sql backup db refinement

[bcullman]

Background

I was concern about what happens when the $RetentionPolicyCount was undefined, so I intended to add a single unit test. While doing so, I recognized that some of my other tests could be improved in quality, uncovering an issue in how files were sorted before choosing which files were deleted.

Additionally, I updated Invoke-PesterTests.ps1 to automatically unpack code under test from the json files so it's a little less annoying.

Results

validated that no action is taken if $RetentionPolicyCount is undefined. treating devices (split backup files) as a single file made pester a little less of a pest

Pre-requisites

• [✔] Id should be a GUID that is not 00000000-0000-0000-0000-000000000000
  • NOTE If you are modifying an existing step template, please make sure that you do not modify the Id property (updating the Id will break the Library sync functionality in Octopus).
• [✔] Version should be incremented, otherwise the integration with Octopus won't update the step template correctly
• [✔] Parameter names should not start with $
• [✔] Step template parameter names (the ones declared in the JSON, not the script body) should be prefixed with a namespace so that they are less likely to clash with other user-defined variables in Octopus (see this issue). For example, use an abbreviated name of the step template or the category of the step template).
• [✔] LastModifiedBy field must be present, and (optionally) updated with the correct author
• [✔] The best practices documented here have been applied
• [NA] If a new Category has been created:
• [✔] An image with the name {categoryname}.png must be present under the step-templates/logos folder
• [NA] The switch in the humanize function in gulpfile.babel.js must have a case statement corresponding to it

[bcullman]

maintainer: (consider squashing commits for cleaner history ;) )

[bcullman]

@twerthi, @ebalders, @harrisonmeister could you take a look?

[twerthi]

Please remove the deprecated function ApplyRetentionPolicy-old

[bcullman]

Please remove the deprecated function ApplyRetentionPolicy-old

ack! thanks @twerthi - nice catch.