How to exclude database objects from coverage reports? about sqlcover HOT 4 CLOSED

hi @KrylixZA ,

Found a working solution where sql objects can be excluded from coverage.

$excludeArray = “\[dbo\].\[sp_sysproc1\]","\[dbo\].\[sp_sysproc2\]” $coverage = new-object SQLCover.CodeCoverage($connectionString, $database, $excludeArray, $logging)

Referece : https://the.agilesql.club/2016/04/sqlcover-code-coverage-for-sql-server-t-sql/

Thanks

from sqlcover.

Hi @GoEddie ,

I am also looking to tackle similar issue reported above. My usecase is to exclude a list of stored procedures for which I Know I will not write unit tests. In that scenario, I would want to exclude those in the total coverage metrics as well. Could you help suggest if this is possible in the existing version ?

Thanks,
Priya

from sqlcover.

Hello @KrylixZA ,

Were you able to find any solution for the issue you have reported ? Please let me know if you have found something.

Thanks,
Priya

from sqlcover.

hi @KrylixZA ,

Found a working solution where sql objects can be excluded from coverage.

$excludeArray = “\[dbo\].\[sp_sysproc1\]","\[dbo\].\[sp_sysproc2\]” $coverage = new-object SQLCover.CodeCoverage($connectionString, $database, $excludeArray, $logging)

Referece : https://the.agilesql.club/2016/04/sqlcover-code-coverage-for-sql-server-t-sql/

Thanks

Closing this issue with this comment. Thanks @priyasomangali 👍

from sqlcover.