Difference between revisions of "Best Ways to Manage/Seed Test Data"

Latest revision as of 04:06, 6 July 2009

Several possible options were discussed:

Specific tools were mentioned that can assist in managing the data:

Liquibase http://www.liquibase.org
- Version control schema and seed data
- Automatic handling of RDBMS schema upgrades/downgrades
- Handling of seed/reference data
- Handling of test data driven by environment variables
- support or Refactoring of RDBMS
Unitils http://unitils.org
- Manages simple insertion of test data with DBUnit on a test by test basis
GenerateData.com
- a free site that generates real adddresses and data based on factors a random amount of times that you can then inject into SQL
HSQL (Hypersonic)
- a good way to create databases from Hibernate, in memory

@@ Line 1: / Line 1: @@
-Several possible options were discussed:<br>
+Several possible options were discussed:
-<br>
+* Using the DAOs to help seed/examine data (eg. testSaveAndGet)
-- Using the DAOs to help seed/examine data (eg. testSaveAndGet)<br>
+* SQL Scripts to seed test data
-- SQL Scripts to seed test data<br>
+* JDBC statements
-- JDBC statements<br>
+* DBUnit
-- DBUnit<br>
+* Serialised java objects
-- Serialised java objects<br>
-<br>
+Specific tools were mentioned that can assist in managing the data:
-Two specific tools were mentioned that can assist in managing the data:
 * Liquibase [http://www.liquibase.org http://www.liquibase.org]
 ** Version control schema and seed data
@@ Line 16: / Line 14: @@
 ** support or Refactoring of RDBMS
 * Unitils [http://unitils.org http://unitils.org]
-** Manages simple insertion of test data with DBUnit on a test by test basis <br>
+** Manages simple insertion of test data with DBUnit on a test by test basis
+* GenerateData.com
+** a free site that generates real adddresses and data based on factors a random amount of times that you can then inject into SQL
+* HSQL (Hypersonic)
+** a good way to create databases from Hibernate, in memory