StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POLaravel LastInsertId with UUID PK
primarykey
Id
17280616
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-06-24T16:41:40.200
FavoriteCount
2
LastActivityDate
2013-09-16T14:47:03.540
LastEditDate
LastEditorUserId
0
OwnerUserId
444871
ParentId
0
PostTypeId
1
Score
5
ViewCount
1766
LastEditorDisplayName
text
Body
I am attempting to use a UUID as a primary key using Laravel 4. Not finding much info about this topic I decided to use a trigger in MySQL to set the id column with a value of UUID() on insert. From what I have read, I need to set a var in the model of <pre><code>public $incrementing = false; </code></pre> In my migrations file I have something like this for each table: <pre><code>//set default id to UUID, requires thread_stack in my.cnf to be 196k function makeTrigger($tableName) { DB::unprepared('CREATE TRIGGER '.$tableName.'_trigger_id BEFORE INSERT ON '.$tableName.' FOR EACH ROW SET NEW.id = UUID()'); } $tableName = 'sites'; Schema::create($tableName, function($table) { $table->string('id', 36)->primary(); $table->string('name', 50); $table->string('development_url', 50); $table->string('production_url', 50); $table->boolean('launched')->default(0); $table->string('test'); $table->timestamps(); $table->softDeletes(); }); makeTrigger($tableName); </code></pre> While I can insert a record like this that has a UUID, I cannot return the ID if $incrementing = false is set in the model. If I remove that var and I am using a UUID, the id returned is 0. If I use increments('id') in the migrations file, I get the real id returned. I am building an app that UUIDs for ids in the spec, so I am trying to figure out if this is possible in Laravel 4. If I am unable to get that id back using <pre><code>$user = User::create($userdata); return $user->id; </code></pre> then how will the id be used for relationships? (Same issue using $user->save();) From what I understand Eloquent is expecting an auto_increment back, but it seems like there should be a way to get any id back. Why won't this work? Any insight into this area would be appreciated, as I can't seem to find any real documentation on this topic.
Tags
<mysql><laravel><laravel-4><uuid><eloquent>
Title
Laravel LastInsertId with UUID PK
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJazzy
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POLaravel LastInsertId with UUID PK
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POLaravel LastInsertId with UUID PK
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.