Laravel Seeder - Update all records with a Unique ID (UUID)

Question

I have just added a UUID for my users table.

I want to update all the records with a UUID that is unique.

In my seeder I have the following code that generates a UUID and populates this new column in the database. However, the generated UUID is the same in each row.

public function run()
{
  DB::table('users')->update([
    'public_id' => Uuid::generate(4)->string
  ]);
}

I would like the UUID to be generated for each user in the database. So each row has a unique UUID.

Hat tip to this SO question for help so far.

The Laravel UUID Package I'm using.

Lizesh Shakya · Accepted Answer · 2019-06-28T08:36:19.897

6

It is not working because it is taking only one generated uuid for all of the user data.

You need to loop through each model data and generate the unique uuid and save.

public function run(){
        $users = \App\User::get();

        try{
            DB::beginTransaction();
            foreach($users as $user){
                $user->public_id = Uuid::generate(4)->string;
                $user->save();  
            }
            DB::commit();
       }
       catch(Exception $e){  
           DB::rollback();
    }
   //if incase you get exception during database seeding.
}

edited Jun 28 '19 at 08:36

answered Jun 28 '19 at 08:23

Lizesh Shakya

2,482
2
18
42

Thanks! However, I get the following error: Call to undefined method stdClass::save() – ejntaylor Jun 28 '19 at 08:28
I edited ```DB::table('users')->get(); to User::get();```. This should work fine. – Lizesh Shakya Jun 28 '19 at 08:29
1

Fab that works - I had to change User::get() to App\User::get -- tried to make a change to your answer but SO doesn't allow edits < 6chars. Thanks again! – ejntaylor Jun 28 '19 at 08:32

Laravel Seeder - Update all records with a Unique ID (UUID)

1 Answers1