| # |
May 7th 2021, 17:37 |
 ndm |
Technically it doesn't even need to be a real constraint, but just defined in the table class, but that won't work with auto-tables. |
| # |
May 7th 2021, 17:35 |
ndm |
Again, all is needed is a primary key constraint, it doesn't matter whether it's an additional field, or whether it's created over the existing foreign key fields. |
| # |
May 7th 2021, 17:31 |
kevin.pfeifer |
but from a pure cakephp standpoint it isn't necesarry for a pure N:M aka HABTM connection between 2 tables |
| # |
May 7th 2021, 17:30 |
kevin.pfeifer |
if you don't have any additional data that needs to be stored inside that junction table then you are fine without the id. If you need it for future data that needs to be stored inside there then sure, the ID is needed |
| # |
May 7th 2021, 17:27 |
mehov |
Thank you Kevin! Also reading https://blog.jooq.org/2019/03/26/the-cost-of-useless-surrogate-keys-in-relationship-tables/ right now, they do say unnecessary surrogate keys are bad for performance. So I will try to go ahead without it this time. Thanks again! |
| # |
May 7th 2021, 17:22 |
kevin.pfeifer |
see this comment and the one bellow it |
| # |
May 7th 2021, 17:21 |
kevin.pfeifer |
1. no you don't need a seperate id column 2. if you stick with the cakephp naming conventions for table and column names it should auto-generate just fine with `cake bake all tablename` |
| # |
May 7th 2021, 17:20 |
mehov |
Hi everyone! Quick question about a join table design for a HABTM association. Let's call it `articles_tags`. - Does it require a surrogate id? So `id | article_id | tag_id` - Or can I have only `article_id | tag_id` and simply make them a combined primary key? If I go for the latter, will Cake automatically recognise it, or will I have to configure something in the Table class? And am I going to regret this decision? |
| # |
May 7th 2021, 16:46 |
thomas078 |
New Authentication seems to have token based auth as well |
| # |
May 7th 2021, 16:45 |
thomas078 |
@greg138 Thanks. Just started to look new plugin and doing some tests to get an idea of everything i have to change. |
| # |
May 7th 2021, 16:44 |
greg138 |
I believe that it's one or the other. The new plugins work just fine with 3.9, so you can do that conversion any time. |
| # |
May 7th 2021, 16:16 |
thomas078 |
sure, this is an old project. Need to do plan for migrating 4 |
| # |
May 7th 2021, 16:12 |
kevin.pfeifer |
sorry, but I haven’t used the Cake3 AuthComponent in quite some time so I don’t want to give you some wrong info ^^ Someone else has to answer that |
| # |
May 7th 2021, 16:06 |
thomas078 |
@kevin.pfeifer Can i use Auth component and Authentication side by side. Have not yet migrated 3.9 to 4 |
| # |
May 7th 2021, 16:04 |
kevin.pfeifer |
@thomas078 currently cakephp4 has 2 separate plugins for authentication and authorization See https://book.cakephp.org/4/en/tutorials-and-examples/cms/authentication.html and https://book.cakephp.org/4/en/tutorials-and-examples/cms/authorization.html The AuthComponent from Cake3 is deprecated (as stated in https://book.cakephp.org/3/en/controllers/components/authentication.html) |
| # |
May 7th 2021, 16:02 |
ndm |
Just explicitly call `all()` beforehand |
| # |
May 7th 2021, 16:01 |
neon1024 |
Don’t worry. Just a bit frustrated that I couldn’t chase a method to find out what the second param meant :) |
| # |
May 7th 2021, 16:00 |
kevin.pfeifer |
sorry @neon1024 but what are you trying to fix aka what is the problem? ,:) |
| # |
May 7th 2021, 15:57 |
thomas078 |
using Auth Component currently |
| # |
May 7th 2021, 15:52 |
thomas078 |
I have Cake3.9 and need to do quasar.dev frontend to it. Thinking of Token based auth. Any strategies/ideas? |
| # |
May 7th 2021, 15:51 |
neon1024 |
Should link to the right version :man-facepalming: https://github.com/cakephp/cakephp/blob/4.0.10/src/ORM/Query.php#L54 |
| # |
May 7th 2021, 15:50 |
neon1024 |
Which from here is really hard, for me, to find out the method declaration |
| # |
May 7th 2021, 15:50 |
neon1024 |
https://github.com/cakephp/cakephp/blob/master/src/ORM/Query.php#L54 |
| # |
May 7th 2021, 15:50 |
neon1024 |
In Query.php. :) |
| # |
May 7th 2021, 15:48 |
kevin.pfeifer |
and on what object you are using it on |
| # |
May 7th 2021, 15:48 |
kevin.pfeifer |
depends on in which context you are |
| # |
May 7th 2021, 15:48 |
kevin.pfeifer |
well there are many `function max(` present in vendor |
| # |
May 7th 2021, 15:46 |
neon1024 |
I didn’t find the file it was declared in! I searched the docs for max |
| # |
May 7th 2021, 15:46 |
neon1024 |
I think it’s because that Query class has all that weird import stuff for the query trait, then the query ResultSet includes Collections, etc |
| # |
May 7th 2021, 15:46 |
kevin.pfeifer |
you mean from the CollectionInterface? |
| # |
May 7th 2021, 15:45 |
neon1024 |
But clicking it in PHP Storm takes me to an `@method` declaration which is a dead end and still doesn’t describe the params, it’s a bit frustrating :( |
| # |
May 7th 2021, 15:44 |
neon1024 |
Hah, no, it’s in Collections apparently |
| # |
May 7th 2021, 15:44 |
kevin.pfeifer |
you mean this one? https://github.com/cakephp/cakephp/blob/master/src/Database/FunctionsBuilder.php#L76 |
| # |
May 7th 2021, 15:41 |
neon1024 |
I’ll guess that `int type` can be `1` :shrug: |
| # |
May 7th 2021, 15:41 |
neon1024 |
:facepunch: |
| # |
May 7th 2021, 15:41 |
neon1024 |
> max() > Calculate the max of a column. Assumes arguments are literal values. |
| # |
May 7th 2021, 15:41 |
neon1024 |
I mean the docs are just as helpful |
| # |
May 7th 2021, 15:40 |
neon1024 |
Just a docblock with type int |
| # |
May 7th 2021, 15:40 |
neon1024 |
Anyone know how to use `max()` doesn’t seem to exist in the actual code |
| # |
May 7th 2021, 13:55 |
kailas |
anyway, works now |
| # |
May 7th 2021, 13:55 |
kailas |
@neon1024 ugh, i could have sworn i did just this before and it didn’t work… |