Level 102
- What is the error
- What is phpunit.xml set to use as database?
<server name="DB_CONNECTION" value="testing"/>
<server name="DB_DATABASE" value=":memory:"/>
1 like
Aug 11, 2020
7
Level 2
Problem with DB connection on Unit Testing
Greetings friends developers !
I'm a noob on Unit Testing and i try to follow the series on unit testing, i'm on the beggining.
I searched for someone who had the same problem but i didnt find one...
I try to do a basic UserTest to make some practise of what i learned. But when i want to fetch my Users, i ve got an error on my "php artisan test" that i dont understand.
I guess its my DB connection that doesnt work and i dont know why. What do i miss to make my DB connection work on testing purposes ?
Is there anyone that could help me please ?
There is my basic test.
** NB : i've tested my DB connection on tinker and everything works fine
`<?php
namespace Tests\Unit;
use App\User; use PHPUnit\Framework\TestCase; use Illuminate\Database\Eloquent\Factory; use Illuminate\Foundation\Testing\RefreshDatabase; use Illuminate\Foundation\Testing\DatabaseTransactions; use Database\Factories\UserFactory;
class UserTest extends TestCase { use DatabaseTransactions;
protected function createUser()
{
$user1 = User::create([
'name' => "test",
'email' => "[email protected]",
'password' => "secret"
]);
}
/** @test */
public function there_are_2_users()
{
$this->createUser();
// $users = User::all();
// // $count = $users->count();
$count = 2;
$this->assertEquals(2, $count);
}
}`
Level 2
Sorry i forgot to copy paste my error messages :
I ve got this error message on my console :
Call to a member function connection() on null
at C:\laragon\www\laravel-testing\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1342 1338| * @return \Illuminate\Database\Connection 1339| */ 1340| public static function resolveConnection($connection = null) 1341| {
1342| return static::$resolver->connection($connection); 1343| } 1344| 1345| /** 1346| * Get the connection resolver instance.
1 C:\laragon\www\laravel-testing\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1308 Illuminate\Database\Eloquent\Model::resolveConnection()
2 C:\laragon\www\laravel-testing\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1114 Illuminate\Database\Eloquent\Model::getConnection()
And there is my PHPUNIT config file :
<phpunit xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="./vendor/phpunit/phpunit/phpunit.xsd" bootstrap="vendor/autoload.php" colors="true"
<testsuites>
<testsuite name="Unit">
<directory suffix="Test.php">./tests/Unit</directory>
</testsuite>
<testsuite name="Feature">
<directory suffix="Test.php">./tests/Feature</directory>
</testsuite>
</testsuites>
<filter>
<whitelist processUncoveredFilesFromWhitelist="true">
<directory suffix=".php">./app</directory>
</whitelist>
</filter>
<php>
<server name="APP_ENV" value="testing"/>
<server name="BCRYPT_ROUNDS" value="4"/>
<server name="CACHE_DRIVER" value="array"/>
<server name="DB_CONNECTION" value="mysql"/>
<server name="DB_DATABASE" value="laravel_testing"/>
<server name="MAIL_MAILER" value="array"/>
<server name="QUEUE_CONNECTION" value="sync"/>
<server name="SESSION_DRIVER" value="array"/>
<server name="TELESCOPE_ENABLED" value="false"/>
</php>
Level 102
Level 18
Instead of use PHPUnit\Framework\TestCase use use Tests\TestCase; instead.
You need to extend the Laravel TestCase to give you access to the framework.
You're also using both of these:
use Illuminate\Foundation\Testing\RefreshDatabase;
use Illuminate\Foundation\Testing\DatabaseTransactions;
You just need one.
3 likes
Level 2
Thanks a lot for your reply.
I have made the changes and everything works fine !
Level 80
@codingstuff91 The “problem” you have is: unit tests shouldn’t be interacting with a database. Unit tests should test a single unit of code only, so think testing individual methods. Unit tests shouldn’t touch other methods or classes, or rely on services such as a database being present—they’re integration tests.
3 likes
Level 2
@martinbean Thanks for your explanations. Indeed im a newbie on testing, i have still a lot of things to learn
Please or to participate in this conversation.