MYSQL UUID PRIMARY KEY DEFAULT HOW TO
I hope you are now a bit more familiar with how to use UUIDs in a Laravel application. Now let’s see if our primary key is indeed a UUID. 'album' => 'A Mother to Scare Away the Darkness I will go with the song ‘ The Machine‘ from the album ‘ A Mother to Scare Away the Darkness‘ by the Greek band Halocraft. Now let’s use tinker to create a new recordĪnd let’s create a new Track object which we then insert into the database. Now let’s run the migration and let’s create a new record in our database. Let’s also tell our Model that we want the table to be named ‘tracks’ and we want the ‘title’, ‘artist’, and ‘album’ columns to be fillable. Now let’s get back to our Model and use the Trait. If it doesn’t have a value, we then dynamically set the primary key using the uuid() method provided by the Str Class in Laravel. We check if the Model’s primary key doesn’t have a value. In this case, we’re going to use the creating event which dispatches when a new Model is saved for the first time. Like I said earlier, we’re going to leverage Eloquent’s Model Events to create the UUIDs. The third one is the public function getKeyType() method that just specifies that the IDs on the table should be stored as strings. The second one is the public function getIncrementing() method that is used by Eloquent to know if the IDs on the table are incrementing or not. The first one is the protected static function boot() where we can hook into our Model and listen for any Eloquent events. Next, create a new file called Uuid and create a trait with the same name. Inside the app folder, create a new Trait folder if you don’t have one already.
Let’s go ahead and create the Trait that can be used in any Model in which we want to use UUIDs. That’s because we’re going to make use of Eloquent’s Model Events to create the UUIDs. Since we’re using Laravel, I would assume you’d be using Eloquent to interact with the database.
MYSQL UUID PRIMARY KEY DEFAULT CODE
The code should look similar to this one: The album column can be nullable because a song can be a single. I’ll add the title, artist, and album columns. Let’s also add other columns, just for the flavor. To use UUIDs we must change the id() to uuid('id')->primary() We’re going to create a Tracks table where we can store our favorite songs.īy default, Laravel migrations include a $table->id() column in each migration you create. Let’s start off by generating a new Model and a migration. In this case, we completely remove the chances of iterating the ID in the URL and thus adding a layer of security.Īlright, enough with the theory, let’s get to the fun part and implement the UUID mechanism. Now let’s see what the same API endpoint would look like with a UUID instead of an auto-incremented integer: Your app has many RESTful endpoints that look similar to this one:Īs you can see, we can start getting users just by iterating the ID in the URL which can sometimes pose a security risk for some applications. There are many variants and versions, one more complicated than the other but they ultimately serve the same purpose of uniquely identifying an entity, or in our case, a record in the database. Sometimes you’ll also hear about GUID which stands for Globally Unique Identifier, a term most often used by Microsoft fanbois.Ī UUID is basically a string of generated characters based on a set of rules. UUID stands for Universal Unique Identifier.
0 kommentar(er)
