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

From CitconWiki
Jump to navigationJump to search
(New page: Several possible options were discussed:<br> <br> - Using the DAOs to help seed/examine data (eg. testSaveAndGet)<br> - SQL Scripts to seed test data<br> - JDBC statements<br> - DBUnit<br>...)
 
 
(One intermediate revision by one other user not shown)
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>
+
 
 +
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
 +
** 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 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

Latest revision as of 05:06, 6 July 2009

Several possible options were discussed:

  • Using the DAOs to help seed/examine data (eg. testSaveAndGet)
  • SQL Scripts to seed test data
  • JDBC statements
  • DBUnit
  • Serialised java objects

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
Retrieved from "http://citconf.com/wiki/index.php?title=Best_Ways_to_Manage/Seed_Test_Data&oldid=7496"