John, this is exactly what I used DbUnit (http://www.dbunit.org/) for in
the past. You can drive this from Ant or thru code, so it's as flexible
as you need it to be.
Check out some of the information up on their site - as well as this
(slightly dated) article written about them -
http://www.onjava.com/pub/a/onjava/2004/01/21/dbunit.html . What we did
was extend their DatabaseTestCase and load and clear data based upon the
test case or test suite that we were running - using dynamically
generated resource paths based upon the package and class names of the
files.
If you're interested and I can be of help - I'm here to answer more Q's
Cheers,
Tim
--
Tim Ruppert
HotWax Media
http://www.hotwaxmedia.com
o:801.649.6594
f:801.649.6595
John Martin wrote:
Grinder does look really interesting and appears to me to be geared
more for testing the application for a UI and performance perspective.
What I am really after is something that is more database oriented to
allow a test suite to initialize data appropriately, run the test, and
then clean out the test data. I'm writing new services to
insert/update data and want to have a simple way of building tests to
make sure that my code is working correctly.
Currently, I write a test script that invokes the service and I
inspect the results and walk through the code in the debugger. I
agree with Brett that "creating data driven tests were still difficult
to create and maintain." There's got to be an easier way...
Brett - I would be interested in the JXUnit integration with ofBiz
since that appears to be inline with what I'm trying to do. Can point
me to where I can get what I would need to use it?
Thanks,
John
