laravel assertDatabaseHas() testing method doesn't work

Question

I'm using Laravel 5.4 and PHPUnit 6.5.5. I keep getting the following error when using Laravel's assertDatabaseHas() method in my tests.

Error: Call to undefined method Illuminate\Http\Response::assertDatabaseHas()

This is my code fragment using assertDatabaseHas():

$response = $this->withSession(['user_id' => $this->user_id])
    ->json('post',
        route('some_route'),
        $request //an array 
    );

    $request['myuser_id'] = $this->user_id;

    $response->assertStatus($expected['code'])
        ->assertDatabaseHas('profiles',$request);

I also tried to use $this->assertDatabaseHas(), but a new error appeared:

TypeError: Argument 2 passed to PHPUnit\Framework\Assert::assertThat() must be an instance of PHPUnit\Framework\Constraint\Constraint, instance of Illuminate\Foundation\Testing\Constraints\HasInDatabase given, called in /project_path/vendor/laravel/framework/src/Illuminate/Foundation/Testing/Concerns/InteractsWithDatabase.php on line 22

I searched for a while for the problem's solution and found this question , but downgrading PHPUnit version to 5.* didn't work for me.

$request is just an associative array ['id' => 2 , 'name' => 'test' , ....] @JonasStaudenmeir — blank94
– blank94, Commented May 19, 2018 at 13:36

miken32 · Accepted Answer · 2020-02-04 16:45:43Z

3

assertDatabaseHas() always worked, you were just using it incorrectly and a change in Laravel versions would not have fixed your problem.

You're dealing with two separate entities here – an HTTP response and a database entry – and they need to be treated as such. The return from a method such as json() or assertStatus() is an instance of Illuminate\Http\Response and has no database methods.

Keep these things separate: make the HTTP request and check the response, then check the database.

$this
    ->withSession(['user_id' => $this->user_id])
    ->json('post', route('some_route'), $request)
    ->assertStatus($expected['code']);

$request['myuser_id'] = $this->user_id;

$this->assertDatabaseHas('profiles', $request);

answered Feb 4, 2020 at 16:45

miken32

42.5k16 gold badges127 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

dulerong Over a year ago

This is actually the correct answer and should be accepted as the accepted one. Original post please review and change.

blank94 · Accepted Answer · 2018-05-21 08:36:58Z

0

I upgraded my laravel version from 5.4.37 to 5.5.40 and problem solved. assertDatabaseHas() works fine now.

answered May 21, 2018 at 8:36

blank94

4046 silver badges21 bronze badges

Collectives™ on Stack Overflow

laravel assertDatabaseHas() testing method doesn't work

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related