| # |
Feb 14th 2020, 15:57 |
 ndm |
@val Have you tried a custom (eager) loader as I've suggested? You can do all sorts of crazy things that way: https://gist.github.com/ndm2/b417e3fa683a972e295dc0e24ef515e3 |
| # |
Feb 14th 2020, 15:57 |
simon781 |
Afternoon - I have had a dig through the docs but can't see any obvious pattern for using read replicas - we'd probably be looking at offloading reads to a replica DB for some tables. I know we could hook into before events and switch config but is there support for this? |
| # |
Feb 14th 2020, 15:53 |
sebastian.krzewinski. |
Hi all |
| # |
Feb 14th 2020, 15:52 |
lilhermit |
Changing the saveStrategy to replace I don't get duplicates but replacing isn't idea for my solution |
| # |
Feb 14th 2020, 15:43 |
lilhermit |
Hi I'm trying to save an entity with hasMany associations, it always creates new records. I fetch the record initially with the association then patch it with an array. The associated data is the same but it always shows are new and dirty |
| # |
Feb 14th 2020, 14:14 |
slackebot |
{$__cakeID__$};` |
| # |
Feb 14th 2020, 14:14 |
val |
> A complete SQL query CakePHP can use to fetch associated model records. This should be used in situations that require highly customized results. If a query you’re building requires a reference to the associated model ID, use the special `{$__cakeID__$}` marker in the query. For example, if your Apple model hasMany Orange, the query should look something like this: `SELECT Orange.* from oranges as Orange WHERE Orange.apple_id = |
| # |
Feb 14th 2020, 14:14 |
val |
from 2.x cookbook: |
| # |
Feb 14th 2020, 14:13 |
val |
@lpj145 It is not clear what you mean. How would you get the same ids in 3.x query builder as they are in `{$__cakeID__$}` in 2.x? |
| # |
Feb 14th 2020, 13:22 |
lpj145 |
more simple clear and secure. |
| # |
Feb 14th 2020, 13:21 |
lpj145 |
on finder option you can pass a query builder with really you want... |
| # |
Feb 14th 2020, 13:21 |
lpj145 |
@val https://api.cakephp.org/3.8/class-Cake.ORM.Table.html#_hasMany |
| # |
Feb 14th 2020, 13:17 |
lpj145 |
@val have a good way to conditionable contained data. |
| # |
Feb 14th 2020, 13:07 |
val |
> 'hasMany' => [ > 'ShopCategory' => [ > 'conditions' => [ > 'ShopCategory.id IN ( > SELECT ShopCategoryItem.shop_category_id > FROM shops AS Shop > LEFT JOIN shop_category_items AS ShopCategoryItem > ON ShopCategoryItem.shop_id = Shop.id > WHERE Shop.resource_type = "event" AND Shop.resource_id = {$__cakeID__$} > )', > ], > 'foreignKey' => false, > ], > ], |
| # |
Feb 14th 2020, 13:07 |
val |
@lorenzo, here is a bit simplified example: |
| # |
Feb 14th 2020, 12:56 |
neon1024 |
Good thanks :thumbsup: |
| # |
Feb 14th 2020, 12:34 |
lorenzo |
@val can you explain a bit more? there is no 1:1 way to translate that for cake 3, but in general is easy as cake 3 makes custom association conditions quite easy |
| # |
Feb 14th 2020, 12:34 |
lorenzo |
@neon1024 thanks! Things are going fine here. How about yourself? |
| # |
Feb 14th 2020, 12:32 |
neon1024 |
:) Thanks |
| # |
Feb 14th 2020, 12:29 |
storkovo |
@neon1024 that is cool :) thank you very much - I’m exploring options, Proffer looks sexy :+1: |
| # |
Feb 14th 2020, 12:29 |
dereuromark |
mentioning works :) Does that work with chuck norris too? |
| # |
Feb 14th 2020, 12:27 |
neon1024 |
@lorenzo :wave: Hey! Hope all is well with you |
| # |
Feb 14th 2020, 12:27 |
val |
@lorenzo> Hi, we use `{$__cakeID__$}` in 'conditions' in associations in 2.x. What is the proper way to migrate that to 3.x? |
| # |
Feb 14th 2020, 12:27 |
neon1024 |
:question: |
| # |
Feb 14th 2020, 12:27 |
lorenzo |
? |
| # |
Feb 14th 2020, 12:25 |
val |
@lorenzo? |
| # |
Feb 14th 2020, 12:24 |
neon1024 |
I haven’t tried converting pdf to image though. Not sure what library might do that job :) |
| # |
Feb 14th 2020, 12:24 |
neon1024 |
@storkovo Yeah, that should work :) |
| # |
Feb 14th 2020, 12:23 |
storkovo |
@neon1024 Hello! I am looking at your Proffer plugin (version for cake 3.x at the moment) - I will need to upload and store pdf files and transform them to image (for preview and other things) - am I right with my assumption that custom “transformClass” is desired way and solution for that, please? |
| # |
Feb 14th 2020, 12:22 |
val |
Hi, we use `{$__cakeID__$}` in 'conditions' in associations in 2.x. What is the proper way to migrate that to 3.x? |
| # |
Feb 14th 2020, 09:45 |
lpj145 |
The first filter can't nothing, second try, I can't understand what my consurmer talking ? The problem is not me... |
| # |
Feb 14th 2020, 09:43 |
lpj145 |
Try add two filter for same filder with different filter type :$ |
| # |
Feb 14th 2020, 09:43 |
lpj145 |
And express is based on concept functional programing |
| # |
Feb 14th 2020, 09:42 |
lpj145 |
Is a era of typed information, devs, meetups, organization, some people talking about stop use arrays, stop turn code with a breach's |
| # |
Feb 14th 2020, 09:40 |
dereuromark |
Interesting |
| # |
Feb 14th 2020, 09:40 |
lpj145 |
@dereuromark yes |
| # |
Feb 14th 2020, 09:40 |
lpj145 |
Express plugin ia based a group information about api query consulting |
| # |
Feb 14th 2020, 09:40 |
dereuromark |
You think Search plugin is not easy to use? |
| # |
Feb 14th 2020, 09:38 |
lpj145 |
Symfony and laravel have a similar concept, and express plugin try to help dev by powerful api softwares |
| # |
Feb 14th 2020, 09:35 |
lpj145 |
@dereuromark because approachable, broke changes, the existing plugin increase all of new or veterans devs needs to know about cake things, and turn more difficult for devs migrate from other fws, because have a new curve of learning. |
| # |
Feb 14th 2020, 09:25 |
revillosakristianpaol |
its actually overkill hahaha, but its already on prod so i have no choice hehe :,) |