How can I exclude the system stored procedures for diagrams from Code coverage results?

Answers

• Alex B Redgate › Posts: 1,158 Diamond 4

  May 17, 2019 4:25PM

  Hi @DLyes,
  
  I can see severa parts in the static analysis code base where it's looking for objects but excluding diagram related things like:
  

  <div>Where	SPECIFIC_NAME COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI LIKE 'sp[_]%'</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; And SPECIFIC_NAME COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI NOT LIKE '%diagram%'</div>

  And
  

  AND name Not In('sp_helpdiagrams','sp_upgraddiagrams','sp_creatediagram')

  And
  

  And TABLE_NAME <> 'sysdiagrams'

  So it seems like it is excluding them in at least some cases.  Can you give specific example of what and where it is being included?
  
  Kind regards,
  Alex

  Product Support Engineer | Redgate Software
  
  Have you visited our Help Center?

  0 · Share on Twitter
• DLyes Posts: 16 Bronze 1

  May 30, 2019 10:47PM

  Thanks for the reply Alex, sorry this reply took so long.
  
  What you've mentioned above sounds like it should exclude most of them, but it doesn't line up with what I can see.
  
  When I run my tests on a database which has the diagramming objects, these ones show up in the Code coverage section.
  
  

  [dbo].[sp_upgraddiagrams]	7	0	0.00
  [dbo].[sp_helpdiagrams]	5	0	0.00
  [dbo].[sp_helpdiagramdefinition]	16	0	0.00
  [dbo].[sp_creatediagram]	21	0	0.00
  [dbo].[sp_renamediagram]	25	0	0.00
  [dbo].[sp_alterdiagram]	24	0	0.00
  [dbo].[sp_dropdiagram]	16	0	0.00
  [dbo].[fn_diagramobjects]	19	0	0.00

  
  I am using the latest available version - SQL Test Version 3.1.3.585 

  0 · Share on Twitter
• Alex B Redgate › Posts: 1,158 Diamond 4

  June 4, 2019 2:59PM

  Hi @DLyes,
  
  Righto, the bits I saw were related to some of the SQL Cop static analysis tests rather than code coverage.
  
  The code coverage is handled by SQL Cover which is this open source project: https://github.com/GoEddie/SQLCover and so you will need to direct questions or requests for it there as we don't control it!
  
  Kind regards,
  Alex

  Product Support Engineer | Redgate Software
  
  Have you visited our Help Center?

  1 · Share on Twitter
• DLyes Posts: 16 Bronze 1

  June 4, 2019 8:48PM

  Thanks for confirming that @Alex B. 
  

  0 · Share on Twitter
• Alex B Redgate › Posts: 1,158 Diamond 4

  June 5, 2019 2:45PM

  No worries, sorry I couldn't help more!
  

  Product Support Engineer | Redgate Software
  
  Have you visited our Help Center?

  0 · Share on Twitter
• DLyes Posts: 16 Bronze 1

  October 30, 2019 11:23PM

  Hello, 
  
  I came across the need for this again this week, and posted it as an issue on the SQLCover github page.
  
  Eddie replied confirming that SQLCover already has the ability to take a filter to exclude specific objects ("sp_.*diagram" would work in this instance) but there is nothing in the SQLTest ui to allow you to specify anything that can be passed to SQLCover.

  
  Is this something which could be added to SQLTest?
  
  Link to GitHub comment : https://github.com/GoEddie/SQLCover/issues/45#issuecomment-548136446
  
  

  1 · Share on Twitter
• Azhkanizkael Posts: 25 Bronze 2

  January 28, 2020 5:32PM

  If this isn't going to get added any time soon, could we at least get a guide of how to update the SQLCover ourselves?

  0 · Share on Twitter