MassDataHandler: database unit testing assistant
The MassDataHandler is a framework to assist with Database Unit Testing. The framework makes it very easy to insert test data into a database, which in turn makes it very easy to write database unit tests. The user merely needs to specify their relevant data in a simple XML fragment, and then the framework uses knowledge of the database schema to do all the grunt work and convert that XML data into SQL, from which it populates the database.
The XML fragments that contain the test data are robust and refactorable. You can include expressions like variables substitution and identity lookup, default row templates, and include statements to import sub-templates. Because the framework already knows the database schema, you only need to specify the relevant data, and the framework can auto-populate the rest of the row’s required columns with dummy data.
This tool is intended for:
* Supplying data for Database unit testing.
* Easily creating your own data script to insert data for development.
* Extracting data from one database and inserting it into another as test data.
* Getting snapshots of data, and them converting them to xml files for easy diff comparisons.
link
