Generate Reports from XML Output file

Easy unit testing for databases in SQL Server Management Studio

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, David Priddle

Generate Reports from XML Output file

Postby JackAce » Fri Sep 28, 2012 6:01 pm

What can I do with the XML report that is generated from the XmlResultFormatter call?

Code: Select all
:XML ON
EXEC
   tSQLt.XmlResultFormatter


I'd like to somehow integrate this in Jenkins. Is this file in a format that Jenkins would understand (JUnit, MSBuild or some other testing framework format that Jenkins might have a plug in for)?
JackAce
 
Posts: 45
Joined: Fri Jul 08, 2011 11:00 pm

Postby Brian Donahue » Mon Oct 01, 2012 12:05 pm

I'd think every build platform could understand XML, so it shouldn't be a problem to integrate the report with a build system. The people at tSQLt have documented how you would put the reports into CruiseControl:

http://tsqlt.org/177/integrating-tsqlt- ... e-control/

You may need to write a bit of XSL if you want it to look nice.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Test

Who is online

Users browsing this forum: No registered users and 0 guests