MySQL Forums
Forum List  »  Quality Assurance

Database Refactoring: testing and data validation
Posted by: Wayne Rasmussen
Date: October 09, 2014 07:05PM

In the Refactoring Databases, they suggest testing your database. To test the schema, the db application, VALIDATE data migration. In particular, when refactoring you have to check: Stored proceedures, Triggers, Referential Integrity (rules), View Definitions, Default values for columns, and Data Invariations. They suggest using a TDD approach.

The first thing that is needed is to write unit tests. How are devs creating these tests? Is there some mySQL tool for that? Should I use PHP to create them myself?

They also mention SQLUnit and DBUnit for managing test data and testing Stored Procedures. Any other tools that people might recommend?

When the schema is modified through refactoring, you will have data migration that needs to be validated. Is this also normally done through manually created code or are there tools to test that conversions are valid? Is this also a good time to use rollbacks?

Options: ReplyQuote

Written By
Database Refactoring: testing and data validation
October 09, 2014 07:05PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.