New answers tagged database
TDD is for testing application. DB schema is not an application and you cannot test it per se. You can test application which uses that schema. Tests will help you determine if your application is still working correctly after refactoring, which may include any changes in the schema (or any other changes).
I had a similar task in the past. In order to have the maximum of flexibility I advice you to you selenium with Java. At the following address, you will find a example how to start: https://code.google.com/p/selenium/wiki/GettingStarted As your test will be written in Java, you are free to do all the check you wish in database thx to JDBC or verify if ...
With selenium you can insert data into database via a frontend and also retrieve and read the reports in a similar way. It also supports file handling as far as I know. Check out documentation on seleniumhq.org and read the manual and functions. I'm sure you will find the code piece you are looking for in there and them use them to build your logic and ...
Top 50 recent answers are included