This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes Testing and the fly likes Using Excel to generate test data for Sql tables Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Engineering » Testing
Bookmark "Using Excel to generate test data for Sql tables" Watch "Using Excel to generate test data for Sql tables" New topic
Author

Using Excel to generate test data for Sql tables

Ida Achi
Greenhorn

Joined: Oct 02, 2009
Posts: 26
I just need a direction, ideas on how and where to begin.
I need to use Excel to write test cases for a database with several tables. What should I be looking for?
For instance can I write test data in excel for table below? Please help. Thanks



- Table `viterra`.`partner`
-- -----------------------------------------------------
Lester Burnham
Rancher

Joined: Oct 14, 2008
Posts: 1337
What role would Excel -or Excel files- play in this scenario? Are you using JUnit with something like DBUnit or SQLUnit?
Ida Achi
Greenhorn

Joined: Oct 02, 2009
Posts: 26
All I have is a MySQL database with a couple of tables. I need to use Excel to generate test cases ( stored procedure test, type test, data size test, input verification) for the database. No Junit or SQL unit.
Is this even possible?
Lester Burnham
Rancher

Joined: Oct 14, 2008
Posts: 1337
The question was really: why do you need to use Excel? What particular features does Excel have that help with DB testing? Or, to put it in yet another way: How do you intend to test the DB with whatever data/information ends up in Excel?
 
 
subject: Using Excel to generate test data for Sql tables