Log message #4020596

# At Username Text
# 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.
# Apr 27th 2017, 11:10 inoas basically when you enter a domain and I have to real link objects I want to redirect to a nice slug "in your language"
# Apr 27th 2017, 11:10 inoas dereuromark that's the reason I want case sensitivity... probably ascii_ci will work ok but meh
# Apr 27th 2017, 11:09 inoas forgot the gist