| # |
Mar 12th 2019, 15:27 |
 jeremyharris |
but char(36) is still what you want |
| # |
Mar 12th 2019, 15:27 |
half2me |
just wondering if there is a behavior for that |
| # |
Mar 12th 2019, 15:27 |
half2me |
no problem, yeah I thought I would need to |
| # |
Mar 12th 2019, 15:26 |
jeremyharris |
sorry I misunderstood |
| # |
Mar 12th 2019, 15:26 |
half2me |
I mean it doesn't cause any problems if we always stamp it |
| # |
Mar 12th 2019, 15:26 |
jeremyharris |
then if it’s just a field like that you will have to populate it yourself |
| # |
Mar 12th 2019, 15:26 |
half2me |
but only sometimes stamped |
| # |
Mar 12th 2019, 15:26 |
jeremyharris |
ooooh |
| # |
Mar 12th 2019, 15:26 |
half2me |
its just an identifier stamped on an entity |
| # |
Mar 12th 2019, 15:26 |
half2me |
none |
| # |
Mar 12th 2019, 15:26 |
jeremyharris |
is this for a FK or a PK? |
| # |
Mar 12th 2019, 15:26 |
half2me |
Seems to me like it shouldn't by default |
| # |
Mar 12th 2019, 15:26 |
half2me |
would the default behavior stamp anyway? |
| # |
Mar 12th 2019, 15:25 |
half2me |
if its allowed to be null though |
| # |
Mar 12th 2019, 15:25 |
half2me |
but still no stamping :) |
| # |
Mar 12th 2019, 15:25 |
half2me |
@jeremyharris I changed my migration, and its generating a CHAR(36) nicely |
| # |
Mar 12th 2019, 15:19 |
jeremyharris |
and bake your fixture, if your fixture doesn’t show up as a type=uuid something was wrong |
| # |
Mar 12th 2019, 15:18 |
half2me |
just as a normal one |
| # |
Mar 12th 2019, 15:18 |
half2me |
I don't want it as the primary index |
| # |
Mar 12th 2019, 15:18 |
jeremyharris |
yeah that would be best :slightly_smiling_face: |
| # |
Mar 12th 2019, 15:18 |
jeremyharris |
also, set it as the primary index |
| # |
Mar 12th 2019, 15:18 |
half2me |
maybe I'll just use the uuid type in the migration :) |
| # |
Mar 12th 2019, 15:18 |
half2me |
ah okay :) |
| # |
Mar 12th 2019, 15:18 |
jeremyharris |
you want char(36) |
| # |
Mar 12th 2019, 15:18 |
half2me |
but when I create a new entity and save, it stays null |
| # |
Mar 12th 2019, 15:17 |
half2me |
its a varchar(36) |
| # |
Mar 12th 2019, 15:17 |
half2me |
my uuid field is just null |
| # |
Mar 12th 2019, 15:17 |
jeremyharris |
you shouldn’t need to do anything in initializeSchema |
| # |
Mar 12th 2019, 15:17 |
half2me |
but it doesn't seem to be generating one automatically |
| # |
Mar 12th 2019, 15:16 |
half2me |
@jeremyharris I even tried setting the column type to uuid manually in the initializeSchema |
| # |
Mar 12th 2019, 14:13 |
half2me |
alright, I'll try that, thanks @jeremyharris |
| # |
Mar 12th 2019, 14:12 |
jeremyharris |
and if you want to validate your keys, using `uuid` in validation will do the trick |
| # |
Mar 12th 2019, 14:11 |
half2me |
haha yes, a bit minimal |
| # |
Mar 12th 2019, 14:11 |
jeremyharris |
yeah that’ll be good |
| # |
Mar 12th 2019, 14:11 |
jeremyharris |
I just realized that section doesn’t say much hah |
| # |
Mar 12th 2019, 14:11 |
half2me |
I think I have my migration as 'string' with char(36) |
| # |
Mar 12th 2019, 14:11 |
half2me |
sweet |
| # |
Mar 12th 2019, 14:11 |
jeremyharris |
if you generate a migration with bake using the “uuid” abstract type, it will do the work for you. If not and using mysql, char(36) will make cake recognize it as a uuid |
| # |
Mar 12th 2019, 14:10 |
jeremyharris |
yep! see: https://book.cakephp.org/3.0/en/intro/conventions.html#database-conventions |
| # |
Mar 12th 2019, 14:09 |
half2me |
validation etc. |
| # |
Mar 12th 2019, 14:09 |
half2me |
Things I would need are automatic generation of uuid on saving an entity |