"The table is empty :-("

You need to log in as a user first, try this in your test method:

$user = factory(User::class)->create();
$this->be($user);

Doesn't your post have a user_id attirubute there? If so, pass in the user_id too.

Hmm I am simply following the tutorial and there is no user / id in ProjectsTest.php , however I have included your snippet for the user and I get the following repsonse:

1) Tests\Feature\ProjectsTest::a_user_can_create_a_project
Error: Class 'Tests\Feature\User' not found

/Users/damienk.sedgwick/Sites/birdboard/vendor/laravel/framework/src/Illuminate/Database/Eloquent/FactoryBuilder.php:291
/Users/damienk.sedgwick/Sites/birdboard/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/GuardsAttributes.php:122
/Users/damienk.sedgwick/Sites/birdboard/vendor/laravel/framework/src/Illuminate/Database/Eloquent/FactoryBuilder.php:300
/Users/damienk.sedgwick/Sites/birdboard/vendor/laravel/framework/src/Illuminate/Database/Eloquent/FactoryBuilder.php:219
/Users/damienk.sedgwick/Sites/birdboard/vendor/laravel/framework/src/Illuminate/Database/Eloquent/FactoryBuilder.php:178
/Users/damienk.sedgwick/Sites/birdboard/tests/Feature/ProjectsTest.php:20

@b1narylife

Are you sure the columns title and description exists or are there more required fields?

If a remove $this->withoutExceptionHandling() and a have a wrong column name / missing a required field I get the same error/failere.

Here is my create_projects_table:

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateProjectsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('projects', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('title');
            $table->text('description');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('projects');
    }
}

This is copied directly from Jeff in the tuts. I am sure the columns exist but I could be missing something so I will go back through the video up until this point to check!

@b1narylife are you sure $this->withoutExceptionHandling(); is in your test and not disabled?

Can you give us the store method (where you save a new project) code from your projects controller?

** Update -> I am going back through the first two episodes and will return if I encounter the same problem. I am going to use the same version of laravel this time too instead of 6.0 although I doubt that was the issue.

Oh, man. You need to import the App\User on the top, you do know that, right?

in your Project model just put

protected $guarded = [];

You need to persist the data in the database:

in ProjectController - store method:

$attributes=request(['title', 'description']);

Project::create($attributes);

off course you need to validate the data too

Hi,

First of all try to use for this method "public function a_user_can_create_a_project()"  the word "test" instead of the word "a" like this : 

• "test_user_can_create_a_project" , because you can find errors because of this. Second of all the error "The table is empty" says that the table "projects" does not exist inside your database or can not find it for some kind of reason. You can find over here, https://laravel.com/docs/7.x/database-testing, what assertDatabaseHas does.

Hope you can find the problem or already resolved it!

I am having the same issue, I am using Laravel 8 when I refactor to use controllers it pops up. Is this a difference in how data is persisted in laravel 8, anyone else have the same problem and fixed it?

nevermind found the issue I had misconfigured my routes to swapping index and store Route::get('/projects', [ProjectsController::class, 'store']); Route::post('/projects', [ProjectsController::class, 'index']); :)