Difference between #2 and #3 of
UUID instead of an auto-increment integer for ID with Active Record

Revision #3 has been created by grigori grigori on Nov 25, 2019, 10:13:23 PM with the memo:

fixing the markup
« previous (#2) next (#4) »

Changes

Title unchanged

UUID instead of an auto-increment integer for ID with Active Record

Category unchanged

How-tos

Yii version unchanged

2.0

Tags unchanged

mysql,active record,REST,UUID

Content changed

[...]
Adding getId()/setId() won't help - data comes from a client in JSON and fills the model object with a setAttributes() call avoiding generic magic methods.

Here's the hack:
1. add a private $idText; property
2. add two filters

 
```
['id','match', 'pattern'=>'/^[0-9a-f]{8}-[0-9a-f]{4}-[1-5][0-9a-f]{3}-[89ab][0-9a-f]{3}-[0-9a-f]{12}$/i'],
// convert UUID from text value to binary and store the text value in a private variable
// this is a workaround for lack of mapping in active record
['id','filter','skipOnError'=>true, 'filter'=>function($uuid){
$this->idText = $uuid;
[...]
5 0
4 followers
Viewed: 70 441 times
Version: 2.0
Category: How-tos
Tags: active record, mysql, REST, UUID
Written by: grigori grigori
Last updated by: samdark samdark
Created on: Nov 25, 2019
Last updated: 5 years ago
Update Article
Revert to #2 | Revert to #3

Revisions

View all history