I’m using UUID’s as PK in my tables. They’re stored in a BINARY(16) MySQL column. I find that they’re being mapped to string type in YII. The CRUD code I generate breaks down though, because these binary column types are being HTML encoded in the views. Example:
<?php echo CHtml::link(CHtml::encode($data->usr_uuid), /* This is my binary uuid field */ array('view', 'id'=>$data->usr_uuid)); ?>
To work around this problem, I overrode
in my model where I convert the values to/from hex using
respectively. See this for more details.
This takes care of the view problems.
However, now the search on PK when accessing a url of the form:
being called which in turn calls:
This doesn’t work since the SQL is being generated (on account of it being mapped to php string type) is
select ... where usr_uuid='EC12EF8EBF90460487ABD77B3F534404'
What would have worked is if I could, for these uuid fields change the condition to:
select ... where usr_uuid=unhex('EC12EF8EBF90460487ABD77B3F534404')
I was wondering how I take care of this problem cleanly. I see one possiblity - extend
and override the necessary methods to special case and handle binary(16) columns as uuid type.
This doesn’t seem neat as there’s no support for uuid natively either in php (where it is treated as string) or in mysql (where I have it as binary(16) column).
Does anyone have any recommendation?