Unit tests via tSQLt and Pester, code coverage by SQLCover and codecov.io, and linting by TSQLLint and super-linter
The following prereqs are not handled by the setup script:
- SQL Server 2012+ or equivalent
- tSQLt installed on a database (install scripts located in
tests\tSQLt\
if needed)
-
Temporarily update
tests\constants.ps1
with any values specific to your local environment (Instance and Database) -
Run the following PowerShell from the project root:
.\tests\localdev_test.ps1
This will:
- Install all dependencies (except a tSQLt database)
- Produce an html code coverage report on completion in a popup browser
To skip the automated setup, use the flag -SkipSetup
when running the script.