GoEddie / GoEddie/SQLCover

System diagram procedures are currently included in the code coverage results

Open
#45 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
TSQL
Stars
69
Forks
55
PR merge metrics
No merged PRs in 30d

Description

The system diagram procedures are currently included in the code coverage results.
These shoudn't be included as they are system procedures so we shouldn't need to write tests for them, and it negatively impacts the total coverage %.

I believe they can be recognised by either their name (sp_%diagram) or by the extended property microsoft_database_tools_support.

![2019-10-31 08_44_18-SQL Test - Microsoft SQL Server Management Studio](https://user-images.githubusercontent.com/57195303/67894157-db1c5000-fbbc-11e9-9119-42e3847ff174.png)

I am currently using Code Coverage as part of the RedGate SQLTest plugin.
I had approached RedGate about this and they pointed me to here :)
https://forum.red-gate.com/discussion/85304/how-can-i-exclude-the-system-stored-procedures-for-diagrams-from-code-coverage-results

@GoEddie

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the code that identifies stored procedures and assembles code coverage results; the issue suggests matching sp_%diagram names or the microsoft_database_tools_support extended property. Verify that system diagram procedures are excluded from coverage while ordinary procedures remain included, and add or update the relevant coverage tests if the repository provides them.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.