Make custom ID automatic in seeder Laravel

Question

I want to make custom id using haruncpi/laravel-id-generator packages. I have 2 data that will insert into database. the program is work but the id of those data is duplicate

here is code

class ArtisSeeder extends Seeder
{
    public function CustomId() 
    {
        $config = [
            'table' => 'artis', 
            'field' => 'kd_artis',
            'length' => 4, 
            'prefix' => 'A'
        ];

        return IdGenerator::generate($config);
    }

    public function run()
    {
        DB::table('artis')->insert([
            [
                'kd_artis' => $this->CustomId(),
                'nm_artis' => 'ROBERT DOWNEY',
                'jk' => 'PRIA',
                'bayaran' => 10000000000,
                'award' => 2,
                'negara' => 'AS',
            ], 
            [
                'kd_artis' => $this->CustomId(),
                'nm_artis' => 'ANGELINA JOLIE',
                'jk' => 'WANITA',
                'bayaran' => 700000000,
                'award' => 1,
                'negara' => 'AS',
            ], 
        ]);
    }
}

note : kd_artis is the id.

So how to make the id not duplicate?

why don't you use default helper to generate ids? `Str::uuid()->toString()` — Kavan Prajapati, May 31 '23 at 13:34
@Kavan Prajapati because i want my id like this 'A001 A002 A003' — Muhammad Hakim, May 31 '23 at 13:51
You could use faker and something like `$faker->unique()->numerify('A###');` — Ron van der Heijden, May 31 '23 at 13:58
@RonvanderHeijden is it possible to make the id sequentially? — Muhammad Hakim, May 31 '23 at 14:04

cengsemihsahin · Answer 1 · 2023-05-31T14:19:12.823

0

You can save and manage much more easily through Eloquent. Use like this in Seeder:

Artis::insert([
    [
        'nm_artis' => 'ROBERT DOWNEY',
        'jk' => 'PRIA',
        'bayaran' => 10000000000,
        'award' => 2,
        'negara' => 'AS',
    ],
    [
        'nm_artis' => 'ANGELINA JOLIE',
        'jk' => 'WANITA',
        'bayaran' => 700000000,
        'award' => 1,
        'negara' => 'AS',
    ],
]);

Don't forget to include this in your Model. You can customize it according to you:

public static function boot()
{
    parent::boot();
    self::creating(function ($model) {
        $model->kd_artis = IdGenerator::generate([
            'table' => $this->table,
            'field' => 'kd_artis',
            'length' => 4,
            'prefix' => 'A',
        ]);
    });
}

edited May 31 '23 at 14:19

answered May 31 '23 at 13:40

cengsemihsahin

921
2
8
21

i little bit confused about use Artis::createMany. i get error like this 'Call to undefined method App\Models\Artis::createMany() Bad Method Call: Did you mean App\Models\Artis::created() ?' – Muhammad Hakim May 31 '23 at 14:01
i also add 'use App\Models\Artis;' – Muhammad Hakim May 31 '23 at 14:02
@MuhammadHakim try using `insert()` instead of `createMany()`. – cengsemihsahin May 31 '23 at 14:18
laravel outputs this error "General error: 1364 Field 'kd_artis' doesn't have a default value" – Muhammad Hakim May 31 '23 at 14:30
Can u check here: https://stackoverflow.com/a/64570060/10542740 – cengsemihsahin May 31 '23 at 14:39

Make custom ID automatic in seeder Laravel

1 Answers1