This week's book giveaway is in the JavaScript forum.
We're giving away four copies of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js and have Paul Jensen on-line!
See this thread for details.
Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Using Excel to generate test data for Sql tables  RSS feed

 
Ida Achi
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What role would Excel -or Excel files- play in this scenario? Are you using JUnit with something like DBUnit or SQLUnit?
 
Ida Achi
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!