Database testing (RefreshDatabase) in Laravel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to use the RefreshDatabase trait in a Laravel test class.

Laravel

<?php

namespace Tests\Feature;

use Illuminate\Foundation\Testing\[1];
use Tests\TestCase;

class UserTest extends TestCase
{
    use RefreshDatabase;

    public function test_example()
    {
        $this->assertTrue(true);
    }
}

Drag options to blanks, or click blank then click option'

ADatabaseMigrations

BWithoutMiddleware

CWithFaker

DRefreshDatabase

Attempts:

3 left

💡 Hint

Common Mistakes

Using DatabaseMigrations instead of RefreshDatabase

Forgetting to import the trait

Not using any trait to reset the database

The RefreshDatabase trait resets the database after each test, ensuring a clean state.

2fill in blank

medium

Complete the code to run a test that checks if a user record exists after creation.

Laravel

public function test_user_creation()
{
    \App\Models\User::factory()->create();

    $this->assertDatabaseHas('[1]', [
        'email' => '[e-mail]',
    ]);
}

Drag options to blanks, or click blank then click option'

Ausers

Buser

Caccounts

Dprofiles

Attempts:

3 left

💡 Hint

Common Mistakes

Using singular 'user' instead of 'users'

Using unrelated table names like 'accounts' or 'profiles'

The assertDatabaseHas method checks the users table for the given data.

3fill in blank

hard

Fix the error in the test method to correctly refresh the database before running.

Laravel

public function test_database_refresh()
{
    $this->[1]();
    $this->assertTrue(true);
}

Drag options to blanks, or click blank then click option'

AmigrateRefresh

BrefreshDatabase

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect method names like migrateRefresh

Calling refreshDatabase manually instead of using the trait

The correct method to refresh the database in a test is refreshDatabase(), but it is not a method you call manually. Instead, you use the RefreshDatabase trait. This question expects the learner to recognize the correct method name if called.

4fill in blank

hard

Fill both blanks to correctly import and use the RefreshDatabase trait in a Laravel test.

Laravel

<?php

namespace Tests\Unit;

use Illuminate\Foundation\Testing\[1];
use Tests\TestCase;

class ProductTest extends TestCase
{
    use [2];

    public function test_product_creation()
    {
        $this->assertTrue(true);
    }
}

Drag options to blanks, or click blank then click option'

ARefreshDatabase

BDatabaseMigrations

DWithFaker

Attempts:

3 left

💡 Hint

Common Mistakes

Importing one trait but using another

Forgetting to use the trait inside the class

You must import RefreshDatabase and then use it inside the class to refresh the database between tests.

5fill in blank

hard

Fill all three blanks to write a test that creates a user and asserts the database has the user email.

Laravel

public function test_user_database_entry()
{
    $user = \App\Models\User::factory()->create();

    $this->assertDatabaseHas([1], [
        [2] => [3],
    ]);
}

Drag options to blanks, or click blank then click option'

A'users'

B'email'

C'[e-mail]'

D'name'

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong table name or missing quotes

Using wrong column name

Using a value that does not match the created user

The assertDatabaseHas method checks the 'users' table for a record where 'email' equals '[e-mail]'.