DEV Community

Test automation for Laravel 7 and MySQL with GitHub Actions

Roberto B. on June 04, 2020

GitHub Actions (https://github.com/features/actions) is a powerful service provided by GitHub for continuous integration and continuous delivery. ...

Read full post

Oleg Andreyev • Oct 3 '22

Few things:

when running unit test you don’t need database, otherwise it’s not a unit tests. I’d suggest split test cases in test suites, e.g.: unit and functional (running unnecessary steps is just taking seconds and billed)
no needs to store test database as a secret, how cares about it? I personally use secrets for “real secret” as PAT

Roberto B. • Oct 4 '22

thank you for the feedback. very useful and everything make sense. i will update the article with latest version of the tools, and i will also take in consideration your feedback. thank you again!!!

Jonathan Zarate • Aug 28 '20

Hi, Roberto.
I have the same configuration, but github actions throws me the exception.

 SQLSTATE[HY000] [2002] Connection refused (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')

Roberto B. • Aug 29 '20

Hi Jonathan. Thank you for the feedback.
I woul like to check one thing. Assuming that all things are correct, how is confogured your DB_HOST?
On your .env file :
DB_HOST=127.0.0.1
Later i will be at my laptop and i will try to replicate your issue.

Jonathan Zarate • Aug 31 '20

Yeah, the DB_HOST is 127.0.0.1

Can I share my configuration of my yaml file?

Roberto B. • Aug 31 '20

Sure!

Jonathan Zarate • Aug 31 '20

gist.github.com/zaratedev/e385c948...

Roberto B. • Sep 1 '20

I see you are using MYSQL_ALLOW_EMPTY_PASSWORD.
Just to give a try , instead of MYSQL_ALLOW_EMPTY_PASSWORD , please try to use a password.
MYSQL_ROOT_PASSWORD: secret

and setting the same passoword in the env section with DB_PASSWORD: secret

Jonathan Zarate • Sep 1 '20

Hello Roberto.

I'm trying to run the laravel dusk tests, but sadly I keep getting the connection refused error.
The phpunit tests with database migrations trait run successful.

Roberto B. • Sep 8 '20

Ok, I was able to replicate your problem with your YML file.
The difference is that the phpunit is executed via command line and dusk is executed with the webserver (php artisan serve). The problem is to pass the env to the right process.
With phpunit is enough to set the env before executing the command.
With dusk , you need to set the env variables before to launch the webserver.
Try to take a look this one:
github.com/roberto-butti/laravel7-...

Roberto B. • Feb 16 '21

I created an Open Source tool for creating GitHub Actions workflow for Laravel application. The source code is: github.com/Hi-Folks/gh-actions-yam... . You can use a demo here: ghygen.hi-folks.dev/

Bobby Iliev • May 28 '21

This tool is supper cool!

Roberto B. • Jun 2 '21

Thank you! If you have any feedback or suggestion or feature request, feel free to raise your hand 🚀