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>...)
 
Line 6: Line 6:
 
- DBUnit<br>
 
- DBUnit<br>
 
- Serialised java objects<br>
 
- Serialised java objects<br>
 +
 +
<br>
 +
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
 +
** 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 <br>

Revision as of 21:43, 28 June 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


Two 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