In memory database leads to The table is empty.

Does this affect multiple/all of your tests? Are you sure that the tests are working? Have you run them on a different database before?

All the setup is correct. Tried it with multiple database types including :memory: and a full mysql database. Been troubleshooting this for two weeks as I continue to build with no tests.

Wrap the code that should create the user in \DB::enableQueryLog(); [...] dd(\DB::getQueryLog()); and check the output.

Here is is:

        \DB::enableQueryLog();
        $this->post('register', [
            'username' => 'TestUser',
            'email' => '[email protected]',
            'password' => 'Password123',
            'password_confirmation' => 'Password123',
            'terms' => '1',
        ]);

        dd(\DB::getQueryLog());

Output:

[]

So, no query....do you have a validation failure? Can you dump the response?

$response = $this->post('register', [
    'username' => 'TestUser',
    'email' => '[email protected]',
    'password' => 'Password123',
    'password_confirmation' => 'Password123',
    'terms' => '1',
]);
$response->dump();

Weird it seems to be dumping the whoops page. Edit I don't have the ->dump() method.

This is the entire test file:

<?php

namespace Tests\Feature;

use App\User;
use Tests\TestCase;

class UserTest extends TestCase
{
    /**
     * @test
     */
    public function a_guest_should_be_able_to_register()
    {
        $this->post('register', [
            'username' => 'TestUser',
            'email' => '[email protected]',
            'password' => 'Password123',
            'password_confirmation' => 'Password123',
            'terms' => '1',
        ]);

        $this->assertDatabaseHas('users', [
            'email' => '[email protected]',
            'username' => 'TestUser',
        ]);
    }

    /**
     * @test
     */
    public function a_guest_should_be_able_to_see_the_register_page()
    {
        $response = $this->get('/register');

        $response->assertStatus(200);
    }

    /**
     * @test
     */
    public function a_guest_should_be_able_to_see_the_login_page()
    {
        $response = $this->get('/login');

        $response->assertStatus(200);
    }

    /**
     * @test
     */
    public function a_loggedin_user_should_not_be_able_to_see_the_login_page()
    {
        $user = factory(User::class)->create();
        $this->actingAs($user);

        $response = $this->get('/login');

        $response->assertRedirect('/dashboard');
    }

    /**
     * @test
     */
    public function a_loggedin_user_should_not_be_able_to_see_the_register_page()
    {
        $user = factory(User::class)->create();
        $this->actingAs($user);

        $response = $this->get('/register');

        $response->assertRedirect('/dashboard');
    }



    /**
     * @test
     */
    public function a_guest_should_be_able_to_login_with_valid_credentials()
    {
        $user = factory(User::class)->create();

        $response = $this->post('/login', [
            'email' => $user->email,
            'password' => 'secret'
        ]);
        $response->assertStatus(302);
        $this->assertAuthenticatedAs($user);
    }

    /**
     * @test
     */
    public function a_loggedin_user_can_see_the_dashboard()
    {
        $user = factory(User::class)->create();
        $this->actingAs($user);

        $response = $this->get('/dashboard');

        $response->assertOk();
    }
}

and here is my Testcase file

<?php

namespace Tests;

use Illuminate\Foundation\Testing\RefreshDatabase;
use Illuminate\Foundation\Testing\TestCase as BaseTestCase;

abstract class TestCase extends BaseTestCase
{
    use CreatesApplication, RefreshDatabase;
}

No dump(); what Laravel version?

Is that code snippet from your test?

EDIT did you assign the (TestResponse) result of $this->post(.... to a variable, and then call dump() on that?

Laravel 5.6. The whole file is above but here is a screencast attempting to dump the things:

https://d.pr/v/kNczwW

$response->dump();

It would appear that the test response is an instance of Query Builder.

The dumped response appears to be the Whoops page; question is why? Your test should capture the Exception rather than Whoops package. Are you somehow running your tests in the local environment rather than testing?

Can you dd(get_class($response)); you should expect Illuminate\Foundation\Testing\TestResponse?

One of the million things I tried. I have dumped all the env, every database config etc... nothing seems to work. Here is a screencast proving the environment

https://d.pr/v/6YwEAH

And yeah its a TestResponse:

vagrant@homestead:~/Code/wpcore-app2$ vendor/bin/phpunit
PHPUnit 7.3.2 by Sebastian Bergmann and contributors.

F"Illuminate\Foundation\Testing\TestResponse"
vagrant@homestead:~/Code/wpcore-app2$

Struggling here too....

• Can you confirm if there is a POST route with /register URI?
• Can you check that the route is being hit correctly; maybe dd(__FILE__) in the first line of the controller to ensure you are getting to where you expect?

Yeah it’s insane. I can tell you it’s the same issue with other tests. And definitely have the routes in place. I’m going to try your test above when I get back to the office. Thanks for the help so far really appreciated!

Yup correct file and everything. This is for sure going to be one of insanely stupid things I am sure of it.

What are the contents of the whoops page (You should also be able to get the error from storage/logs/Laravel.log)

I'm wondering if it might be something like a missing APP_KEY but error message will help determine

Stupid question have you tried to use /registerinstead of just register?

Try adding $this.->withoutExceptionHandling(); in the beginning of the test.

And what is the content of the oops page?

So that was it. /register fixed it. Crazy. Thanks @Tray2

You are very welcome.

I've made that mistake too ans pulled what little is left of my hair ;)

@STUEYNET - Bro am having this exact same issue, i have tried what you later did to resolve it, still having the same issue, please help