Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours on Instagram and YouTube and waste money on coffee and fast food, but won’t spend 30 minutes a day learning skills to boost our careers.
Master in DevOps, SRE, DevSecOps & MLOps!

Learn from Guru Rajesh Kumar and double your salary in just one year.



Get Started Now!

Laravel : A Comprehensive Guide of Seeders

What are Laravel Seeders?

Laravel Seeders are part of Laravel’s Database Seeder functionality, allowing developers to insert sample or default data into their database tables. This is particularly useful for initializing a fresh database with data necessary for testing or setting up default values in production.

How Laravel Seeders Work:

Seeder Classes:

In Laravel, seeders are organized into seeder classes. Each seeder class typically corresponds to a specific database table, and developers can create multiple seeders to populate various tables with different sets of data.

Defining Seed Data:

Within a seeder class, developers use the run method to define the data they want to insert into the associated table. This can include hardcoded values or dynamically generated data using Faker, Laravel’s built-in fake data generator.

Generate a Seeder Class

Use the make:seeder Artisan command to generate a new seeder class. Replace ExampleTableSeeder with the desired name for your seeder and ModelName with the name of the Eloquent model associated with the table:

php artisan make:seeder ExampleTableSeeder

Define Seeder Data

Open the generated seeder class (located in the database/seeders directory) and define the data you want to insert into the associated table within the run method. You can use Laravel’s query builder or Eloquent methods to interact with the database.

For example:

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class ExampleTableSeeder extends Seeder
{
    public function run()
    {
        DB::table('example_table')->insert([
            'column1' => 'value1',
            'column2' => 'value2',
            // Additional columns and data
        ]);
    }
}

Run the Seeder

To execute the seeder and insert the defined data into the database, use the db:seed Artisan command. You can specify the seeder class you want to run:

php artisan db:seed --class=ExampleTableSeeder

Run All Seeders (Optional)

If you have multiple seeders and want to run all of them at once, you can use the following Artisan command:

php artisan db:seed

Rollback Seeders (Optional)

To rollback the last batch of seeders and remove the seeded data from the database, you can use the --reverse option:

php artisan db:seed --class=ExampleTableSeeder --reverse

Related Posts

How We Fixed “sonar-scanner: command not found” and Successfully Analyzed Our Project with SonarQube

Running static code analysis with SonarQube is essential for maintaining clean, quality code. Recently, while working on our Laravel microservice project mhn-doctors-ms, we hit a common yet…

Is SonarQube Community free Edition Good for Laravel Projects?

When working on web development projects using Laravel, JavaScript, and jQuery, maintaining code quality becomes just as important as building features. That’s where tools like SonarQube come…

Laravel Throttle Middleware: How to Increase API Rate Limit Safely and for 429 Too Many Requests

If you’re working with Laravel APIs, you might have encountered this default throttle setting: This line lives in your app/Http/Kernel.php file and controls how many requests a…

Fixing MySQL Error: Incorrect Definition of mysql.column_stats Table

The Problem While working on your MySQL server, you might come across this error in your error log: This error usually shows up after an upgrade or…

Fixing Laravel Migration Error: “Unknown Collation: utf8mb4_0900_ai_ci”

While working with Laravel and MySQL, you might run into an error during migrations like this one: Why This Happens The collation utf8mb4_0900_ai_ci is introduced in MySQL…

Why Dental Surgery Is Good and Important

Dental health plays a vital role in our overall well-being, yet it’s often overlooked until problems become serious. Dental surgery is a powerful solution that not only…

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x