DEV Community

Easily use UUIDs in Laravel

Wilbur Powery on October 29, 2018

First published on my website What are UUIDs? UUID stands for Universal Unique Identifier. It's a 128-bit number used to uniquely ident...

Read full post

Rising • Apr 17 '19 • Edited

I am getting issue with sync() method.
I did somthing like:

$page->users()->sync([auth()->id() => ['status_id' => 1]]);

then i got this error:

SQLSTATE[HY000]: General error: 1364 Field 'page_id' doesn't have a default value

Bodrosh • Apr 8 '22

I also encountered this problem, if you want to add a uuid to the table additionally when it already has a key, you can do this:

protected static function bootUsesUuid() { static::creating(function ($model) { if (! $model->uuid) { $model->uuid = (string) Str::uuid(); } }); }

Rising • Apr 17 '19

Wilbur Powery

I am using laravel version 5.7

Owen Andrews • Nov 5 '18

Great post Wilbur, thank you. I think you can also just set public $incrementing = false;, which saves a few lines.

Wilbur Powery • Nov 6 '18

Thanks Owen. You're right, setting that to false is much easier, thanks for pointing it out.

St Pierre d'Guernsey • May 11 '19

Using public $incrementing = false; doesn't work as it gives you a dual declaration if you use the trait - stick to getIncrementing

Steve Kamanke • Jun 10 '19

That's only if you use do decide to use a Trait. If you're only using it on only one model then you don't need to create a Trait. public $incrementing = false; would work as intended.

farid • Sep 25 '20

Hi Wilbur, nice point. I'm using phpStan to check my code and the trait fires an error in following line:
$model->{$model->getKeyName()} = (string) Str::uuid();

Error:
Cannot cast Ramsey\Uuid\UuidInterface to string

slipperydippery • May 14 '19

Great post, I didn't know that it was so easy! I am running into a problem with my foreign keys:

SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table `groups` add constraint `groups_user_id_foreign` foreign key (`user_id`) references `users` (`id`) on delete cascade)

Any idea on what I'm doing wrong?

Nwosu Cyprian • May 15 '19

Check that both groups.user_id and users.id have same type definition e.g if users.id is UNSIGNED Integer, groups.user_id should be same

Keith Mifsud • Sep 23 '19

Great mini tutorial. Thank you for sharing :)

I would only make one point here regarding Dependency Inversion:

When possible try to generate your UUIDs before your domain/source code and not through the database model. Otherwise, your source is dependant on the database.