Seeding data in Laravel - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ component_behavior

intermediate

What is the output after running this Laravel seeder?

Consider this Laravel seeder code snippet. What will be the number of users in the database after running it once?

Laravel

<?php

use Illuminate\Database\Seeder;
use App\Models\User;

class UserSeeder extends Seeder
{
    public function run()
    {
        User::factory()->count(5)->create();
    }
}

// Assume the users table is empty before running.

A 5 users will be added to the database.

B 10 users will be added because the seeder runs twice automatically.

C An error will occur because the count method is invalid here.

D No users will be added because the factory is not called correctly.

💡 Hint

Think about what the count(5) method does in a factory call.

The count(5) method tells Laravel to create 5 user records. Since the users table is empty before running, 5 new users will be added.

📝 Syntax

intermediate

Which option correctly defines a seeder class in Laravel?

Select the option that shows a valid Laravel seeder class syntax.

A

<?php

use Illuminate\Database\Seeder;

class ProductSeeder extends Seeder
{
    public function run()
    {
        // seeding logic
    }
}

B

<?php

class ProductSeeder
{
    public function run()
    {
        // seeding logic
    }
}

C

<?php

use Illuminate\Database\Seeder;

class ProductSeeder extends Seeder
{
    public function execute()
    {
        // seeding logic
    }
}

D

<?php

use Illuminate\Database\Seeder;

class ProductSeeder extends Seeder
{
    public function run()
    // missing braces
}

💡 Hint

Look for the correct method name and class inheritance.

Laravel seeders must extend Seeder and define a run() method with braces. Option A follows this pattern.

🔧 Debug

advanced

Why does this seeder fail with a SQL error?

This seeder code throws a SQL error when run. What is the most likely cause?

Laravel

<?php

use Illuminate\Database\Seeder;
use App\Models\Post;

class PostSeeder extends Seeder
{
    public function run()
    {
        Post::create([
            'title' => 'First Post',
            'content' => 'Welcome to the blog!'
        ]);
    }
}

// The posts table has a NOT NULL 'user_id' foreign key column.

A The 'title' field is not allowed to be null, but it is missing.

B The 'user_id' field is missing in the create array, causing a NOT NULL constraint violation.

C The Post model does not have a create method.

D The seeder class is missing the run method.

💡 Hint

Check the database table columns and their constraints.

The posts table requires a 'user_id' because of a foreign key constraint. Not providing it causes the SQL error.

❓ state_output

advanced

What is the state of the database after running this seeder twice?

Given this seeder code, what will be the total number of categories in the database after running it two times in a row?

Laravel

<?php

use Illuminate\Database\Seeder;
use App\Models\Category;

class CategorySeeder extends Seeder
{
    public function run()
    {
        Category::firstOrCreate(['name' => 'Laravel']);
        Category::firstOrCreate(['name' => 'PHP']);
    }
}

// The categories table is empty before the first run.

A 0 categories, because firstOrCreate does not insert anything.

B 4 categories total, because the seeder runs twice and adds duplicates.

C 2 categories total, because firstOrCreate prevents duplicates.

D An error occurs because firstOrCreate is used incorrectly.

💡 Hint

Think about what firstOrCreate does when the record exists.

firstOrCreate checks if a record exists with the given attributes. If yes, it returns it without creating a new one. So running twice adds only 2 unique categories.

🧠 Conceptual

expert

Which statement best describes Laravel's seeding and factory relationship?

Choose the most accurate description of how Laravel seeders and factories work together.

A Seeders use factories to generate fake data, but factories cannot be used outside seeders.

B Seeders and factories are unrelated; seeders manually insert data without factories.

C Factories are only for testing and cannot insert data into the database during seeding.

D Factories define how to create model instances with fake data; seeders call factories to insert data into the database.

💡 Hint

Consider the roles of factories and seeders in Laravel's data generation.

Factories define blueprints for fake data. Seeders call these factories to create and insert data into the database during seeding.