| # |
Apr 26th 2021, 09:19 |
 noel |
So it should set this association on the PeopleTable, but it doesn’t. |
| # |
Apr 26th 2021, 09:19 |
noel |
from this: `className' => 'People'` – that’s what makes it an alias. |
| # |
Apr 26th 2021, 09:18 |
neon1024 |
As if ‘Notaries’ isn’t in the Registry, I wonder how Cake would know what table that it |
| # |
Apr 26th 2021, 09:17 |
neon1024 |
Although, I might be barking up the wrong tree! |
| # |
Apr 26th 2021, 09:17 |
neon1024 |
Might be worth looking in the TableRegistry to see what keys exist? |
| # |
Apr 26th 2021, 09:16 |
neon1024 |
Yep, probably. My brain was over here https://github.com/cakephp/cakephp/blob/3.9.9/src/ORM/Table.php#L240 |
| # |
Apr 26th 2021, 09:15 |
noel |
```$this->belongsTo('Notaries', ['className' => 'People', 'foreignKey' => 'notary_id']);``` |
| # |
Apr 26th 2021, 09:14 |
noel |
As far as I can tell, that’s precisely what I’m doing. |
| # |
Apr 26th 2021, 09:14 |
neon1024 |
Just thinking you might want to alias People as Notaries :) |
| # |
Apr 26th 2021, 09:13 |
neon1024 |
Haha, fair enough. To be honest, I don’t use CakePHP much these days and I’m still on 3.9 :) |
| # |
Apr 26th 2021, 09:13 |
noel |
You’ve lost me now. |
| # |
Apr 26th 2021, 09:13 |
neon1024 |
Well you can alias a table class |
| # |
Apr 26th 2021, 09:12 |
noel |
No.. `belongsTo` |
| # |
Apr 26th 2021, 09:12 |
neon1024 |
Maybe, I thought you had `belongsToMany` |
| # |
Apr 26th 2021, 09:12 |
noel |
What does that mean? |
| # |
Apr 26th 2021, 09:12 |
neon1024 |
Maybe it needs a specific alias? |
| # |
Apr 26th 2021, 09:12 |
noel |
It’s a manyToOne – can’t be inversed as I understand it. |
| # |
Apr 26th 2021, 09:11 |
neon1024 |
Perhaps it needs to be inversed? Do you have an association in PeopleTable? |
| # |
Apr 26th 2021, 09:11 |
noel |
No warnings |
| # |
Apr 26th 2021, 09:11 |
neon1024 |
`Cake\ORM\Table` instance instead of concrete? |
| # |
Apr 26th 2021, 09:11 |
neon1024 |
Do you get a warning about ` |
| # |
Apr 26th 2021, 09:10 |
noel |
I think so… it returns a query object anyway. |
| # |
Apr 26th 2021, 09:08 |
neon1024 |
Can you traverse the association? `$this->Enquiries->Notaries->find()` ? |
| # |
Apr 26th 2021, 09:07 |
noel |
In concrete terms. I have `people` and `enquiries` tables. I’m trying to set up a relationship between the two via the following association on the `enquiries` table: ```$this->belongsTo('Notaries', ['className' => 'People', 'foreignKey' => 'notary_id']);``` However if I then grab the PeopleTable instance and look at the `_associations` property, `enquiries` is not listed as an associated table. |
| # |
Apr 26th 2021, 09:06 |
neon1024 |
My first guess would be a typo :) |
| # |
Apr 26th 2021, 09:02 |
noel |
Hi all. I’m having trouble with associations. The issue is that if I try to create a manyToOne association with a custom name and an aliased foreignKey, that association does not get listed in $table->_associations. |
| # |
Apr 26th 2021, 09:02 |
neon1024 |
Yeah, okay, thanks. I’ll keep hunting in the docs and do some testing on my docker db instance :) |
| # |
Apr 26th 2021, 09:01 |
noel |
@neon1024 mm… that doesn’t sound right no. I might be wrong but my understanding of lock means that it is locked by a process, so that only that process can use the table. Which means inserts that are part of that transaction can happen but any queries (INSERT or otherwise) that are not part of that transaction cannot happen. |
| # |
Apr 26th 2021, 09:00 |
neon1024 |
Ah right, thanks! So if I am running a transaction, no inserts can happen right? |
| # |
Apr 26th 2021, 08:58 |
noel |
Yes |
| # |
Apr 26th 2021, 08:56 |
neon1024 |
Do transaction queries lock db tables? |
| # |
Apr 26th 2021, 03:56 |
admad |
@turkles https://github.com/itosho/easy-query#bulk-upsert |
| # |
Apr 26th 2021, 02:26 |
slackebot |
save_or_update maybe? (up to 10k entries in a go.. though..) |
| # |
Apr 26th 2021, 02:26 |
turkles |
Hi all, I have an app which grabs data from an external API. They recently changed ID format from INT to CHAR and it broke my app a little.. The order of items in the API is not great, and my saving fails when an entry is duplicated. Previously I was using a query on 'id IN' => $api_ids and skipping ones I had already. This doesn't work with chars, is there a better way of dealing with this? Should I just turn on |
| # |
Apr 25th 2021, 16:35 |
kevin.pfeifer |
thx admad for clearing that up :man-bowing: |
| # |
Apr 25th 2021, 16:33 |
kevin.pfeifer |
ha, i missed that completely |
| # |
Apr 25th 2021, 16:32 |
admad |
Casing matters |
| # |
Apr 25th 2021, 16:32 |
admad |
Which not the same as 'Cake.pdf'. |
| # |
Apr 25th 2021, 16:30 |
kevin.pfeifer |
to be fair, `$this->viewBuilder()->setClassName('CakePdf.Pdf');` is present in the usage section of https://github.com/FriendsOfCake/CakePdf |
| # |
Apr 25th 2021, 16:29 |
admad |
Class names configs never take extensions |
| # |
Apr 25th 2021, 16:28 |
admad |
mogpusse: just read the plugin docs instead of crappy tutorials like that. `setClassName('CakePdf.pdf')` is incorrect |