TSqlTest - Automated Unit Testing Tool

[bennido]

Hi Rob,

I have just started using CC.net, Nant and TSqlTest to unit test SSIS and some stored procedures.

I am new to Nant integration with CC.Net and would like some advice on how best to return TsqlTest test results back to Nant so that it shows up best on CC.Net.

I had a look at TSqlTest_GetResultsNant.sql and it doesn't seem to be doing anything other than printing 2 lines ...

'<AllResults><Result value="false"/></AllResults>'
'<AllResults><Result value="true"/></AllResults>'

... and the script says not to add any more PRINT statement which confuses me.

Do you have some sample CC.Net screen shots or Nant xml results from a test project that you can share ?

Thanks !

[rgarrison]

bennido,

Sorry, but I was not the one that did any of the Nant integration. I believe it was just a simple VB script that read the one-line file (containing just "true" or "false").

Rob

[bennido]

bennido,

Sorry, but I was not the one that did any of the Nant integration. I believe it was just a simple VB script that read the one-line file (containing just "true" or "false").

Rob

No problem. I did some digging around and found a way of reflecting the TSqlTest errors in the CC.NET report by modifying the appropriate XSL file.

I'll email it to you when I am done so you can add it to the TSqlTest instructions if you like.

[rgarrison]

That would be great. Thanks.