o227786060@gmail.com's avatar

laravel test

Community experts, please help me take a look at this error.

The error message I'm getting while using Laravel test, is it because I'm not using use RefreshDatabase?

test code test('user_who_is_logged_in_shows_voted_if_idea_already_voted_for',function()

{
    $user = User::factory()->create();
    $idea = Idea::factory()->create();

    Vote::factory()->create([
        'idea_id' => $idea->id,
        'user_id' => $user->id,
    ]);

    $idea->votes_count = 1;
    $idea->voted_by_user = 1;

    Livewire::actingAs($user)
        ->test(IdeaIndex::class, [
            'idea' => $idea,
            'votesCount' => 5,
        ])
        ->assertSet('hasVoted', true)
        ->assertSee('Voted);
    });

Tests\Feature\VoteIndexPageTest > user_who_is_logged_in_can_remove_vote_for_idea QueryException SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed (Connection: sqlite, SQL: insert into "ideas" ("user_id", "category_id", "status_id", "title", "description", "slug", "updated_at", "created_at") values (14, 1, 4, Et Voluptas Dolores Error, Qui accusamus delectus voluptatem nemo. Rerum a praesentium consequatur. Et nihil dolor ut. Sed expedita et est et eos voluptatum ut. Earum accusantium porro molestias quos et., et-voluptas-dolores-error, 2023-10-14 21:31:08, 2023-10-14 21:31:08))

0 likes
5 replies
LaryAI's avatar
LaryAI
AI
2 years ago
Level 58

The error message you're seeing is a SQL integrity constraint violation. It seems that there is a foreign key constraint failure when inserting a new record into the "ideas" table. This could be due to a mismatch between the foreign key values being inserted and the values in the referenced table.

To resolve this issue, you should check the foreign key constraints in your database schema and ensure that the values being inserted are valid. Additionally, make sure that the referenced tables (e.g., "users", "categories", "statuses") have the necessary records for the foreign key constraints to be satisfied.

Regarding the use of RefreshDatabase, it is a trait provided by Laravel that helps with resetting the database state before each test. It can be used to ensure a clean slate for each test case. If you're encountering issues related to database state, you can try adding the RefreshDatabase trait to your test class.

Here's an example of how you can use the RefreshDatabase trait in your test:

use Illuminate\Foundation\Testing\RefreshDatabase;
use Tests\TestCase;

class VoteIndexPageTest extends TestCase
{
    use RefreshDatabase;

    // Your test methods...
}

By adding the RefreshDatabase trait, Laravel will automatically reset the database before each test method is executed.

Please note that the provided solution is based on the information provided in the question. If you need further assistance, please provide more details about your database schema and any relevant code.

kokoshneta's avatar
kokoshneta
2 years ago
Best Answer
Level 27

The error would appear to be coming from your idea factory. Note that the SQL error comes from the query insert into "ideas" (…) values (…), with ideas being presumably the table used for your Idea model.

There are three foreign keys in the query: user_id, category_id and status_id. The user ID will be correct, since it’s taken from the User model you just created, but you don’t specify the other two, so those values must be coming from your factory, and I’m guessing one (or both) of them doesn’t correspond to a row in the categories or statuses table.

1 like
kokoshneta's avatar

@o227786060@gmail.com If that solved the issue, you can use the “Set Best Answer” box to mark the question as solved and get the thread off the Unsolved list.

1 like

Please or to participate in this conversation.