*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 25
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: 25
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?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Using Excel to generate test data for Sql tables
 
Similar Threads
Hibernate is driving me crazy !
Mysql Date problems
Displaying Dynamic Nested Menu in JSP
publishing to a registry
SQL query not giving any result