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

Revision #6 has been created by grigori on Nov 25, 2019, 10:40:51 PM with the memo:

fixing the markup
« previous (#5) next (#7) »

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

[...]
If you design the application from ground up, you can use defferent fields for a binary and text representation of UUID, and reference them in different parts of an application, but I am bound to the legacy code.

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:

 
Step 1 add a private $idText; property
 
Step 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
[...]
5 0
4 followers
Viewed: 61 347 times
Version: 2.0
Category: How-tos
Tags: active record, mysql, REST, UUID
Written by: grigori
Last updated by: samdark
Created on: Nov 25, 2019
Last updated: 4 years ago
Update Article
Revert to #5 | Revert to #6

Revisions

View all history