Release: V1.0.5686.18945 – 2015-07-27
- The XML output now validates against the JUnit test result XML schema at
While there is no “official” JUnit schema, the above is the one that is
referenced most often online.
- tSQLt.DropClass now handles XML schemata correctly.
- All tSQLt assertions can now be called with a @Message parameter. In case of a
failure, the value of that parameter will be output before the default failure
For backward compatibility, tSQLt.AssertEqualsTable still has a @FailMsg
parameter. Its use is now deprecated.
- tSQLt.Info() now returns the version and build of the SQL Server Instance it is installed on:
SELECT * FROM tSQLt.Info() AS I; Version ClrVersion SqlVersion SqlBuild -------------- -------------- ---------- -------- 1.0.5479.30419 1.0.5479.30419 12.00 4213.00
- Verbose execution mode
Executing EXEC tSQLt.SetVerbose @Verbose = 1; before running the tests will cause
tSQLt to output the test name at the beginning and the end of each test’s execution.
That makes it easier in large test suites to find the output of a particular test.
The new procedure tSQLt.RunC behaves identical to tSQLt.Run. However, instead of
expecting the test (class) name in a parameter, it parses the INPUTBUFFER and
extracts the name from a specially formed comment:
EXEC tSQLt.RunC;--Run_Methods_Tests.[test tSQLt.RunC calls tSQLt.Run with everything after ;-- as @TestName]
This makes for a more powerful SQL Query shortcut in SSMS as test names now do not have to be quoted anymore.
tSQLt.AssertEqualsTableSchema is called like tSQLt.AssertEqualsTable. Instead of
the table contents, it compares the columns including name, datatype, collation,
NULL-ability and identity property.
- The test runner now captures start and end time for each test. This information
is included in the XML output. The default output contains the execution duration
for each test.
- Both tSQLt.SpyProcedure and tSQLt.FakeFunction now handle table type parameters.
The content of a table type parameter in a spied procedure is converted into
XML and included in the _SpyProcedureLog table.
- Farewell Sourceforge
Because of several issues over the last months and because of even more complaints
about Sourceforge’s business practices by tSQLt users, we decided to find a more appropriate space.
The official downloads are now available directly on tSQLt.org. The source code
repository will find its new home either on github or bitbucket over the next few days.
- The fail message of tSQLt.AssertEqualsString is now broken into two lines
with aligned string values for easier comparison.
- The installation script now prints a welcome message.
Release: V1.0.5325.27056 – 2014-07-31
- FakeTable now handles CHAR UDTs
- SQL 2014 now officially supported
- tSQLt.ApplyConstraint now handles UNIQUE and PRIMARY KEY constraints
- tSQLt.DropClass now handles UDTs
- tSQLt.ExpectNoException can be followed by tSQLt.ExpectException
- Added @IfExists parameter to tSQLt.RemoveObject
- Added tSQLt.RemoveObjectIfExists
- Added tSQLt.AssertObjectDoesNotExist