# |
Apr 27th 2017, 13:48 |
Lurdekan |
with a binding key |
# |
Apr 27th 2017, 13:48 |
Lurdekan |
I mean, when you define an association |
# |
Apr 27th 2017, 13:48 |
Lurdekan |
how can I pass more conditions to the association subquery? |
# |
Apr 27th 2017, 13:48 |
Lurdekan |
didn't find it in the docs |
# |
Apr 27th 2017, 13:48 |
Lurdekan |
I need some piece of information |
# |
Apr 27th 2017, 13:48 |
Lurdekan |
how u doin? |
# |
Apr 27th 2017, 13:47 |
Lurdekan |
hello fellas |
# |
Apr 27th 2017, 13:27 |
megan |
:parrotparty: |
# |
Apr 27th 2017, 13:22 |
btx |
41 DAYS TIL CAKEFEST! |
# |
Apr 27th 2017, 13:08 |
inoas |
what's the recommended practise to create where conditions where the left side would clash |
# |
Apr 27th 2017, 12:53 |
inoas |
I can conjunct things with $value but then I will lose injection protection |
# |
Apr 27th 2017, 12:53 |
inoas |
I will only get locale_code LIKE once as it gets overwritten |
# |
Apr 27th 2017, 12:53 |
inoas |
when I run code like this pr($collection->unfold()->map(function($value) { return ['locale_code LIKE' => $value]; })->toArray()); |
# |
Apr 27th 2017, 12:53 |
inoas |
https://gist.github.com/inoas/e127826d9c9be368757169bbb370f2e0#file-find-best-locale-path-sql-L8-L11 |
# |
Apr 27th 2017, 12:53 |
inoas |
on the left side I have always the same (or just 2) identifier |
# |
Apr 27th 2017, 12:48 |
Neon1024 |
https://lh3.googleusercontent.com/-o8JIe_Ojh3g/UP-_1ge3t_I/AAAAAAAAB60/MdeISNEMetc/w500-h277-no/8fy4MdZ.gif |
# |
Apr 27th 2017, 12:48 |
Neon1024 |
American politics feels like this to me |
# |
Apr 27th 2017, 12:40 |
inoas |
without net neutrality the net will transform to a few centralist gateways even faster than ever |
# |
Apr 27th 2017, 12:40 |
inoas |
Neon1024: very concerning |
# |
Apr 27th 2017, 12:33 |
Neon1024 |
This makes me sad, http://www.theverge.com/2017/4/26/15439622/fcc-net-neutrality-internet-freedom-isp-ajit-pai |
# |
Apr 27th 2017, 12:33 |
Neon1024 |
(thumbsup) |
# |
Apr 27th 2017, 12:32 |
birdy247 |
thansk for the tips |
# |
Apr 27th 2017, 12:32 |
birdy247 |
I got that function to "merge" accounts working yesterday |
# |
Apr 27th 2017, 12:32 |
birdy247 |
Hey Neon1024 |
# |
Apr 27th 2017, 12:26 |
Neon1024 |
Afternoon everyone |
# |
Apr 27th 2017, 12:13 |
inoas |
aka using inner join |
# |
Apr 27th 2017, 12:13 |
inoas |
https://gist.github.com/inoas/e127826d9c9be368757169bbb370f2e0#gistcomment-2076285 |
# |
Apr 27th 2017, 12:13 |
inoas |
but this should be transformable to ORM code |
# |
Apr 27th 2017, 12:13 |
inoas |
it is already doing subqueries - the problem was that WHERE doesn't support composite identifiers on the left side |
# |
Apr 27th 2017, 12:12 |
hiromi2424 |
inoas possible.search subquery on the cookbook |
# |
Apr 27th 2017, 12:04 |
inoas |
WHERE (id, revision_id) IN (subquery)? |
# |
Apr 27th 2017, 12:04 |
inoas |
AND (id, revision_id) IN ( |
# |
Apr 27th 2017, 12:04 |
inoas |
is this possible in the 3.x ORM? |
# |
Apr 27th 2017, 11:37 |
paul_83uk |
@inoas From what i can see in the source this is correct use of TableRegistry and it just gets and stores the Table in the registry once: ```for ($i = 0 ; $i count($this->user_accesses) ; $i++) { $this->user_accesses[$i]->jobId = $jobId; TableRegistry::get('UserAccesses')->save($this-user_accesses[$i]; ... ``` |
# |
Apr 27th 2017, 11:29 |
dereuromark |
Jonas: Most Like These should be CI for a reason :) ich |
# |
Apr 27th 2017, 11:18 |
inoas |
but sounds kinda wrong to me |
# |
Apr 27th 2017, 11:18 |
inoas |
if you are creating say 100 table class objects |
# |
Apr 27th 2017, 11:18 |
inoas |
paul_83k as that is pretty non standard I'd just either look into the source or save it in an array and after the loop is over unset |
# |
Apr 27th 2017, 11:14 |
inoas |
lets try :) |
# |
Apr 27th 2017, 11:14 |
inoas |
cool https://book.cakephp.org/3.0/en/orm/query-builder.html#case-statements |
# |
Apr 27th 2017, 11:10 |
inoas |
if it exists. |