Composer test does not work as expeceted

rabol · 5 Sept 2022, 09:50

Hi

Composer test command does not work in a standard installation and there is no documentation stating how to set up the testing

e.g
composer test fails with this:

set -e
@php artisan migrate:fresh --env=testing

Dropping all tables .................................................................................................................... 10ms FAIL

In Connection.php line 759:

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

In Exception.php line 18:

SQLSTATE[HY000] [2002] Connection refused

In PDOConnection.php line 40:

SQLSTATE[HY000] [2002] Connection refused

Normally testing uses SQlite not the same connection

does one have to have a special .env or how can I make testing work ?

Kind regards
Steen

sanjay-webkul · 5 Sept 2022, 10:35

Connection refused

Hi there,
Please check your .env file, i guess you are not configure your databse credentials

rabol · 5 Sept 2022, 13:55

@sanjay-webkul but normally one does not need to create a connection.
Test should run using a separate database

when you specify --env=testing there NEED to be a .env file named .env.testing

Maybe a note in the documentation

even with a .env.testing and using SQLite (Which I think is quite normal) it does not work

sanjay-webkul · 6 Sept 2022, 05:10

Hi there,
But the databse should be created which in mentioned on your .env.test file.