Example of PHP Unit Tests of Complex Raw Queries

I work with a lot of complex MYSQL queries where there are a bunch of Case Statements, Sums, etc.. Basically there is a lot of logic inside the query itself. Whenever changes are made to the query it is super had to test. I am working on moving everything over to Laravel in hope that with PHPUnit tests, it would help to maintain and make changes to the queries.

This is what I am thinking of doing:

Create tables via migrations
Create factories for all tables being queried on
Create First Test - add defined values for factories and define assert statements
Create a class that performs queries
Update Test to call class

Does anyone have a good example of doing this?

Robstar

7 years ago

Level 50

There are lots of testing helpers, that make it pretty easy to test database stuff, see https://laravel.com/docs/5.7/database-testing and in particular https://laravel.com/docs/5.7/database-testing#available-assertions

You'll need to ensure you have a full suite of migrations, factories and seeds though.

i.e. you should be able to run php artisan migrate:fresh --seed at will, to wipe you database, run all migrations and seed dummy data.

Please or to participate in this conversation.