Results 1 to 7 of 7

Thread: TSqlTest - Automated Unit Testing Tool

  1. #1
    Join Date
    Dec 2006
    Location
    Portland, Oregon
    Posts
    64

    TSqlTest - Automated Unit Testing Tool

    If you have questions or comments regarding TSqlTest, please reply here.

    Rob

  2. #2
    Join Date
    Nov 2007
    Posts
    1

    How to integrate this tests with code

    Rob,

    I am following your SqlCredit from introduction. In the 3rd installment you introduced this TSqlTest. I am unable to integrate this with sqlcredit database that was created. Please guide me.

    Thanks,
    Sunil

  3. #3
    Join Date
    Dec 2006
    Location
    Portland, Oregon
    Posts
    64

    Question Help?

    Sunil,

    Can you help with any details? What problem are you running into?

    Are you having trouble installing and setting up TSqlTest?

    Are the tests not running properly?

    Thanks,
    Rob

  4. #4
    Join Date
    Jan 2008
    Posts
    3
    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 !

  5. #5
    Join Date
    Dec 2006
    Location
    Portland, Oregon
    Posts
    64

    Nant integration with TSqlTest

    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

  6. #6
    Join Date
    Jan 2008
    Posts
    3
    Quote Originally Posted by 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
    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.

  7. #7
    Join Date
    Dec 2006
    Location
    Portland, Oregon
    Posts
    64
    That would be great. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •