Running tSQLt test from Continua?

Continua CI Discussion
1

I know how to run DUnitX tests with Continua. And I have started looking at tSQLt as a way of doing corrsponding tests with our sql server database. But I can’t find out a sufficiently easy way to do it.

Is there any recommended way to do this?

/Anders

2

Hi Anders,

We don’t currently have any tSQLt actions, but I have now added this to our to-do list to add in the future.

It is possible to run the tSQLt  tests and produce a JUnit style results file using the sqlcmd.exe command line. This can either be called directly from a Run DOS Command / Batch File action or using a FinalBuilder action. I have attached an example FinalBuilder project which includes the actions required.

The test results can be loaded into Continua CI using a Import JUnit Tests action.


__40417__0__tSQLt.zip (901 B)

3

Thanks, works nicely! /Anders