| # |
Jun 9th 2021, 10:32 |
 steinkel |
try `->select(["'' as column_name"])` |
| # |
Jun 9th 2021, 10:23 |
slackebot |
->find('FinderMethod') ->select([. 'column_name' => '', ]);``` Is there any way to output a blank column? |
| # |
Jun 9th 2021, 10:23 |
y.teruyacookie |
Hi, I would like to ask my question. I would like to intentionally output blank columns in the CakePHP3 query builder. In the case of MySQL, you can write the following ```SELECT '' AS 'column_name' FROM hogeModel;``` It will return a column with column_name and a blank value. I would like to do the same thing with CakePHP3's query builder. If I write the following, I get a DataBase error. ```return $query |
| # |
Jun 9th 2021, 10:01 |
ndm |
https://explainextended.com/2009/09/24/adjacency-list-vs-nested-sets-postgresql/ |
| # |
Jun 9th 2021, 09:57 |
eax |
Oh thanks @ndm I’ll look into that! :relaxed: |
| # |
Jun 9th 2021, 09:56 |
ndm |
If you just have an adjacency list with `parent_id`, then you'd need something recursive, which could for example be achieved using common table expressions. |
| # |
Jun 9th 2021, 09:50 |
eax |
@ndm: Ok, then I don’t think it’s an option here, but thanks :$ |
| # |
Jun 9th 2021, 09:48 |
ndm |
Yes, that's the fields for a nested set. |
| # |
Jun 9th 2021, 09:48 |
eax |
Thanks @ndm! But doesn’t that require me to have the lft and rght fields in my table? |
| # |
Jun 9th 2021, 09:46 |
ndm |
@eax If you have a nested set, then you can use the `path` finder: `find('path', ['for' => $childId])` https://book.cakephp.org/3/en/orm/behaviors/tree.html |
| # |
Jun 9th 2021, 09:30 |
eax |
Hey folks! Cake3 question: Is it possible to do a “reverse” threaded find? I have the “bottom” child, and would like to get the parents all the way “up” in the same Query :$ |
| # |
Jun 9th 2021, 07:46 |
philo.hamel |
that's what we use to continue to use the property access |
| # |
Jun 9th 2021, 07:45 |
dereuromark |
Saves also inline type annotations |
| # |
Jun 9th 2021, 07:45 |
birdy247 |
So maybe we do that ->property for any code that has got defined properties |
| # |
Jun 9th 2021, 07:44 |
dereuromark |
If u know the fields exist, use prop access imo. |
| # |
Jun 9th 2021, 07:44 |
birdy247 |
Yes, good point |
| # |
Jun 9th 2021, 07:43 |
dereuromark |
Get method is better for generic Code, like behaviors often. Phpstan likes it more then |
| # |
Jun 9th 2021, 07:43 |
birdy247 |
I prefer the look of ->property in the code |
| # |
Jun 9th 2021, 07:30 |
philo.hamel |
this, and I also use `$entity->property` because it's less error prone and easier with refactoring, but it's an interesting question so I'm also interested to hear from `$entity->get('property')` users |
| # |
Jun 9th 2021, 07:27 |
jpramirez |
If you define the properties' types in the entity's annotations, your IDE and static analyzers will prefer `$entity->property`. |
| # |
Jun 9th 2021, 07:16 |
birdy247 |
Do people recmoned direct access $entity->property or $entity->get('property') |
| # |
Jun 9th 2021, 07:15 |
birdy247 |
When accessing a property in cake 3 |
| # |
Jun 8th 2021, 15:08 |
neon1024 |
Ah, simple `applyOptions` |
| # |
Jun 8th 2021, 15:07 |
neon1024 |
So now I wonder how to pass `beforeFind` options to contained associations |
| # |
Jun 8th 2021, 15:06 |
neon1024 |
Found my issue, it was a beforeFilter in a table class that I am containing! |
| # |
Jun 8th 2021, 14:36 |
neon1024 |
I loop the data, so I’ve been filthy and solved it in the php :grimacing: |
| # |
Jun 8th 2021, 14:36 |
neon1024 |
Hah, fair enough |
| # |
Jun 8th 2021, 14:35 |
ndm |
@neon1024 That reads as if every sentence is missing like 4 or 5 words :P But it kinda sounds like you want to use `leftJoinWith()`, as `matching()` uses an `INNER` join, so you cannot use it for optional filtering. |
| # |
Jun 8th 2021, 13:39 |
paolo.bragagni |
,:) |
| # |
Jun 8th 2021, 13:39 |
paolo.bragagni |
till now I port (to 4) csv :P |
| # |
Jun 8th 2021, 13:38 |
paolo.bragagni |
and use tinybutstrong to build their own odt template |
| # |
Jun 8th 2021, 13:37 |
paolo.bragagni |
me too. cls - xlsx - and pdf |
| # |
Jun 8th 2021, 13:37 |
kevin.pfeifer |
I let users download a XLSX |
| # |
Jun 8th 2021, 13:36 |
paolo.bragagni |
do you advice to use other lib ? |
| # |
Jun 8th 2021, 13:36 |
paolo.bragagni |
I only need pdf library to let users download as pdf index table |
| # |
Jun 8th 2021, 13:34 |
neon1024 |
I was so sure I managed it before using a combination of `matching()` and `notMatching()`, but I can’t find the post now |
| # |
Jun 8th 2021, 13:34 |
kevin.pfeifer |
@neon1024 sorry, but your query filtering questions are a bit too high for me so I can’t help you ,:) |
| # |
Jun 8th 2021, 13:33 |
admad |
Fair enough |
| # |
Jun 8th 2021, 13:32 |
paolo.bragagni |
I had in my old temp'late and I'm desperately trying to port all 'old' work in cake4 .. |
| # |
Jun 8th 2021, 13:32 |
paolo.bragagni |
thanks @admad |
| # |
Jun 8th 2021, 13:30 |
erwane |
i'm using it in all my projects they need PDF ... just because i know it. I like the specific text/image positioning. Every time i want to switch, i always found "html to pdf" library type, not my needs. Maybe i need to take time to test another one. |