View on
D Medved > VSGDR-UnitTest-TestSet > VSGDR::UnitTest::TestSet



Annotate this POD


New  1
Open  0
View/Report Bugs
Module Version: 1.34   Source  


VSGDR::UnitTest::TestSet - Sealed class for Microsoft Visual Studio Database Edition UnitTest Utility Suite by Ded MedVed


Version 1.34


Sealed unit. No user serviceable parts. This module, and all sub-modules exist only to support the suite of applications packaged with it. The applications offer support to creators and maintainers of Microsoft Visual Studio Database Project Unit tests, particularly those frustrated by the VS interface to these tests, who are also comfortable using perl software from the command line.

Support is given for VS2008, VS2010, and now SSDT and VS2012. The latter 2 work with Sql unit tests rather than database unit tests. In practice this means using some new .Net classes and assemblies, very little else has changed. To generate the new Sql Unit tests "-v2" should be passed as an additional argument to the scripts. See the script man/help pages. Parsing Sql Unit tests is the fallback taken in the scripts if the input unit test source code fails to parse as database unit tests.

Full support is offered for:- Scalar, EmptyResultSet, NotEmptyResultSet, RowCount conditions. Partial support for:- ExecutionTime, ExpectedSchema, Inconclusive, Checksum conditions. No support is offered for bespoke conditions, apart from what you can add yourself. No support is offered for any unit tests that have been manually edited to add code Attributes, or alter the transaction mode etc etc.

The suite offers scripts to generate unit tests from sql scripts, merge unit test files, split apart unit test files, extract the sql from unit test files, delete tests from unit test files, disable test conditions, report over unit test files, and run unit test files, with better reporting of test failures than MSTest or Visual Studio. It can also translate unit test files from VB to C# and vice-versa, as well as to Excel Spreadsheet, or XML. The test runner cannot check ExecutionTime, ExpectedSchema, Inconclusive, Checksum conditions. This is because it is pure perl, and has no access to .NET internals, or the database connection code used by .NET.


Ded MedVed, <dedmedved at>


Please report any bugs or feature requests to bug-vsgdr-unittest-testset at, or through the web interface at I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.


You can find documentation for this module with the perldoc command.

    perldoc VSGDR::UnitTest::TestSet

You can also look for information at:



Copyright 2012 Ded MedVed.

This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as published by the Free Software Foundation; or the Artistic License.

See for more information.

syntax highlighting: