| # |
Apr 29th 2017, 14:23 |
 loginews |
@metoyoko I still can't make it work. Note that users.param_id =1 and param.id=1 therefore hasOne and belongsTo will both work. Also there are many records in users table and only one record in param table. I can give you access to the live site. Do you want to try to help me debug this ? |
| # |
Apr 29th 2017, 14:13 |
joop |
how can i acces BeforeRender() variable in controller? |
| # |
Apr 29th 2017, 13:44 |
loginews |
@metoyoko let me try. |
| # |
Apr 29th 2017, 13:44 |
rudy1976s |
Can i bother someone regaring events in cake 3.x ? |
| # |
Apr 29th 2017, 13:41 |
metoyoko |
you tried this? $this->belongsTo('Params' => ['foreignKey'=>'param_id']); only.. and your params model is class ParamsTable extends Table{ } and not paramsTable extends Table{ }? because I already solved my problem same as this. |
| # |
Apr 29th 2017, 13:39 |
metoyoko |
you tried this? $this->belongsTo('param' => ['foreignKey'=>'param_id']); only.. and your params model is class ParamsTable extends Table{ } and not paramsTable extends Table{ }? because I already solved my problem same as this. |
| # |
Apr 29th 2017, 13:21 |
loginews |
yes |
| # |
Apr 29th 2017, 13:21 |
metoyoko |
hi @loginews is ADDRESS1 is your field name? and it is all caps? |
| # |
Apr 29th 2017, 13:15 |
slackebot1 |
for table param. [cake bake all param] No effect. Same results. Now, since param_id and id follow CakePHP conventions, I tried this: $this->belongsTo('param'); ERROR: THE USER COULD NOT BE SAVED $this->belongsTo('Params'); ERROR: TABLE PARAMS DOES NOT EXIST $this-belongsTo('anythingelse'); DOES NOT SAVE param.ADDRESS1 |
| # |
Apr 29th 2017, 13:15 |
loginews |
Regarding : https://gist.github.com/loginews/78dbc099fe1689332c299002d361f472> $this->belongsTo('param')->setForeignKey('id')->setProperty('param_id'); DOES NOT SAVE param.ADDRESS1 $this->belongsTo('anythingelse')->setForeignKey('id')->setProperty('param_id'); DOES NOT SAVE param.ADDRESS1 $this->belongsTo('Params')->setForeignKey('id')->setProperty('param_id'); DOES NOT SAVE param.ADDRESS1 I had not yet baked a crud for table param. So I |
| # |
Apr 29th 2017, 12:42 |
bravo-kernel |
thanks for taking the time to reflect, this was driving me crazy |
| # |
Apr 29th 2017, 12:42 |
bravo-kernel |
small things do matter ;) |
| # |
Apr 29th 2017, 12:42 |
bravo-kernel |
I stand corrected sir, thank you for pointing that out :relaxed: |
| # |
Apr 29th 2017, 12:41 |
dereuromark |
its actually char(36) - not that it matters :P |
| # |
Apr 29th 2017, 12:41 |
bravo-kernel |
feels just right for this user-land customer :) |
| # |
Apr 29th 2017, 12:41 |
dereuromark |
jep |
| # |
Apr 29th 2017, 12:41 |
bravo-kernel |
will probably be aweful but at least that will be standard cake for now |
| # |
Apr 29th 2017, 12:41 |
bravo-kernel |
5) use cake's varchar(36) uuid now, migrate to binary(16) when things grow beyond performance |
| # |
Apr 29th 2017, 12:40 |
bravo-kernel |
@dereuromark thanks, I wish I had the time to do it but unfortunately. I just came up with option 5) |
| # |
Apr 29th 2017, 12:39 |
dereuromark |
thats the quickest woraround for the time beeing - but actualy finishing up uuid16 should only be a few hours tops. might be worth going there |
| # |
Apr 29th 2017, 12:39 |
bravo-kernel |
@dereuromark right, I forgot about reading that one as well |
| # |
Apr 29th 2017, 12:39 |
dereuromark |
using ints internally (for joins), and using a separate uuid column "identifier" or sth for simple get() lookup etc. speed here does not matter |
| # |
Apr 29th 2017, 12:38 |
bravo-kernel |
PR? haha |
| # |
Apr 29th 2017, 12:38 |
metoyoko |
@loginews is param is your actual table name? |
| # |
Apr 29th 2017, 12:38 |
dereuromark |
there is a 4) option. |
| # |
Apr 29th 2017, 12:38 |
bravo-kernel |
correct? |
| # |
Apr 29th 2017, 12:38 |
bravo-kernel |
3) obfuscate the ints |
| # |
Apr 29th 2017, 12:38 |
bravo-kernel |
2) use cake's UUID (all just works but 36, slow) |
| # |
Apr 29th 2017, 12:37 |
bravo-kernel |
1) use ints (fast but not too handy, harvestable) |
| # |
Apr 29th 2017, 12:37 |
bravo-kernel |
@dereuromark I see. So at this point in time I have three choices for my "valuable" ids: |
| # |
Apr 29th 2017, 12:37 |
chris-andre |
@metoyoko It's well documented https://book.cakephp.org/3.0/en/orm/associations.html#belongstomany-associations |
| # |
Apr 29th 2017, 12:36 |
dereuromark |
but fact is: I tried as well as others to raise awareness - and hoped someone would implement it for real :slightly_smiling_face: |
| # |
Apr 29th 2017, 12:36 |
dereuromark |
dont know myself: https://github.com/cakephp/cakephp/issues/7013#issuecomment-121382943 - I tried it in early 3.0 days |
| # |
Apr 29th 2017, 12:35 |
bravo-kernel |
no info on migrations, etc. |
| # |
Apr 29th 2017, 12:35 |
bravo-kernel |
@dereuromark got a bit lost from there on. Not a clue how to approach it basically |
| # |
Apr 29th 2017, 12:34 |
bravo-kernel |
@dereuromark I was re-reading earlier feedback, looked at your plugin readme again, took in the binary(16) advice and thought.... well, let's try it |
| # |
Apr 29th 2017, 12:34 |
metoyoko |
how about hasMany and belongsToMany |
| # |
Apr 29th 2017, 12:33 |
dereuromark |
bravo: concerning? what do you mean? |
| # |
Apr 29th 2017, 12:33 |
bravo-kernel |
@cleptric right, hence my confusion about being advised to use binary(16) uuid :face_with_rolling_eyes: |
| # |
Apr 29th 2017, 12:33 |
metoyoko |
thanks @chris-andre |
| # |
Apr 29th 2017, 12:33 |
metoyoko |
belongsTo: The foreign key is in the same table (Managers has a department_id) hasOne: The foreign key is in the other table. (Department hasOne Manager) |