Proper interaction with relational databases is incredibly important in most pieces of software. The importance of this interaction is underscored by the fact that many software architectures have at least one entire layer or system devoted to data persistence and data loading. When dealing with critical data in enterprise level applications it becomes even more important to make sure your data is being stored and retrieved correctly.
As responsible developers, one of our goals should be to test database interaction and test it well. To help achieve this goal, we will take a close look at tools and techniques that can be used with projects of any size to help create reliable tests capable of validating your database interaction.
The discussion will begin with various techniques for testing your database layer. The focus will then move toward the functionality in the database extension for PHPUnit. Then, utilizing the tools provided in the database extension, examples will be given of how to create basic tests validating that the database is correctly manipulated and data from your database is successfully retrieved. This will be followed by an in depth discussion of “best practices” that can be utilized when you are developing “database aware” fixtures and tests.
Once the ground work is laid, we will look at how all of these tools and techniques can be utilized in both your unit tests and functional tests.
Sebastian Bergmann holds a degree in Computer Science and is a pioneer in the field of quality assurance in PHP projects. His test framework PHPUnit is a de-facto standard. He is actively involved in the development of PHP and creator of various development tools. Sebastian Bergmann is an internationally sought-after expert. As an author he shares his long-standing experience in books and articles. He is a frequent speaker at conferences around the world.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts