CODEWITHSUNDEEP
phpdatabaseunit-testing
ryanzec
ryanzec

Reputation: 28040

What are standard/best practices for creating unit tests for functionality using databases?

I get the idea behind unit testing however am trying to think of a clean simple way do it when it requires database functionality. For instance I have a function that return result based off a database select query. Would the database alway have to remain the same for me to properly see that only the correct results are being returned. What is the best way to perform unit testing (in PHP) when it requires database inactivity (whether it be read, write, update, or delete)?

Upvotes: 16

Views: 5018

Answers (3)

Gordon
Gordon

Reputation: 316969

There is a whole chapter on that in the PHPUnit manual:

It's like with everything else when Unit-Testing. Create a known state and test your code against it to see if it returns the expected results.

Upvotes: 14

Stephan Eggermont
Stephan Eggermont

Reputation: 15907

It is not a unit test if it needs the database.

Upvotes: 0

ircmaxell
ircmaxell

Reputation: 165191

Personally, I create a dummy testing database and populate it with a known data set for each testing run (I do that right in the setUp functions). Then the tests run against that data set, and then it's removed on tearDown...

Now, this is more of a Integration test than an Unit test (And personally I treat it differently from a unit test, run on its own schedule along with other integration tests), but it's still quite useful.

Upvotes: 4

Related Questions