Log message #4209203

# At Username Text
# Oct 17th 2019, 10:02 koeller If I do it your way I don’t have to do the setConnection on the loaded Model :slightly_smiling_face: Thank you!
# Oct 17th 2019, 09:52 slackebot1 <challgren>
# Oct 17th 2019, 09:51 slackebot1 <challgren>
# Oct 17th 2019, 09:50 challgren That might be your issue is your loading the config after the alias
# Oct 17th 2019, 09:49 challgren and maybe load your config before the alias
# Oct 17th 2019, 09:45 koeller To have be aware of not configured connection names passed?
# Oct 17th 2019, 09:44 challgren @koeller did you try to inspect it with `ConnectionManager::configured()`?
# Oct 17th 2019, 09:41 koeller @alexdd55976: For now I’m able to perform the action I want in loading the connection into the Model directly, like: ```$this->Users ->setConnection(ConnectionManager::get($args->getArgument('connection')))```
# Oct 17th 2019, 09:21 alexdd55976 @koeller i do not know, but if you find the solution can you add to docu and do a PR on it?
# Oct 17th 2019, 09:18 koeller Hey, How can I switch a database in a Command. I’ve tried in command execute(): `ConnectionManager::alias($args->getArgument(‘connection’), ‘default’); Configure::load($args->getArgument(‘connection’), ‘default’, true);` But that doesn’t work :S I haven’t found anything in the documentation on that topic, either.
# Oct 17th 2019, 09:08 challgren Evening all!
# Oct 17th 2019, 08:51 neon1024 Wishing everyone a great day! :tada:
# Oct 17th 2019, 08:50 neon1024 Heya everyone
# Oct 17th 2019, 07:20 jotpe Morning, folks!
# Oct 17th 2019, 06:47 javier.villanueva morning!
# Oct 17th 2019, 06:32 alexdd55976 good morning
# Oct 16th 2019, 21:42 slackebot1 'marketingthumb >' => 0 ] ]``` any ideas how to achieve that?
# Oct 16th 2019, 21:42 slackebot1 'Projectfiles', function (Query $q) { return $q->where( [ 'OR' => [ 'marketingvideo >' => 0, 'marketingthumb >' => 0 ] ] ); } ); $query->cache('project_list_video_images'); $query2 = $this->Projects->find('all')
# Oct 16th 2019, 21:42 slackebot1 'Products', 'Marketinginfos', 'Clients', 'Projectfiles' ] ); $query->where(['active' => true]); $query->order(['Projects.id' => 'DESC']); return $query; } ``` this is of course not 100% correct as the condition is to open in ``` return $q->where( [ 'OR' => [ 'marketingvideo >' => 0,
# Oct 16th 2019, 21:42 slackebot1 ->contain(['Marketinginfos', 'Products']) ->toArray(); debug($query2); return $query; } private function __prepareApiMarketingGetProjectList() { $query = $this->find(); $query->matching( 'Marketinginfos', function (Query $q) { return $q->where(['closed' => true]); } ); $query->contain( [
# Oct 16th 2019, 21:42 slackebot1 ``` public function ApiGetProjectListVideoAndImages() { $query = $this->__prepareApiMarketingGetProjectList(); $query->matching( 'Products', function (Query $q) { return $q->where( [ 'producttype_id' => [1,2], ] ); // Videos and Images Only } ); $query->matching(
# Oct 16th 2019, 21:42 mrfeedback i am not sure how i can build a query for the following example: i have projects I want to select `projects` which have in `marketinginfos.closed = true`, and `producttype_id` either `1` or `2` and if it is `producttype_id = 1` it has to have at least one `projectfiles.marketingthumb > 0` and `projectfiles.video > 0` if it is `producttype_id=2` it as to have at least one `projectfile.marketingthumb > 0` only. my approach is the following
# Oct 16th 2019, 16:49 ssalvatori I want to test the internal logic of the listerner
# Oct 16th 2019, 16:49 ssalvatori hello, hey any examples how to test a EventListener ?
# Oct 16th 2019, 16:47 javier.villanueva Im testing with 10.000 and time to save its very up
# Oct 16th 2019, 16:47 javier.villanueva I may not need lft and rght structure
# Oct 16th 2019, 16:45 javier.villanueva ok
# Oct 16th 2019, 16:44 admad MPTT is optimized for read
# Oct 16th 2019, 16:44 admad it won't crash on finds but more like on saves :slightly_smiling_face:
# Oct 16th 2019, 16:09 javier.villanueva ok i will make it
# Oct 16th 2019, 16:09 ndm Finds shouldn't be an issue even with billions of records (assuming your DBMS can handle large amounts of data in general), writes on the other hand can be very expensive. Generate some test data and try it out.
# Oct 16th 2019, 16:01 javier.villanueva really when I write finds is reorder
# Oct 16th 2019, 15:47 javier.villanueva Im using the tree behaviour in a model, probably with 2 million of records, a person tell me that probably it will be crash in finds... any advice about it?
# Oct 16th 2019, 14:00 paul_83uk ok useful to know thanks.
# Oct 16th 2019, 13:58 admad gtg
# Oct 16th 2019, 13:58 admad FYI it's the `ResponseEmitter` class with makes the `setcookie()` calls. So if you do upgrade to php 7.e then for now you can use your own reponse emitter class which overrides relevant method and pass your emitter instance to $server->emit() call in webroot/index.php
# Oct 16th 2019, 13:58 paul_83uk haha love the pic! coookieeee!!
# Oct 16th 2019, 13:58 paul_83uk ahhh ok! sorry hadn't realised that at all. no wonder CakePHP class isn't supporting it yet.
# Oct 16th 2019, 13:57 admad https://ayesh.me/PHP-Samesite-cookies
# Oct 16th 2019, 13:57 admad set you can't set `SameSite` option since php itself has no support for hit prior to 7.3
# Oct 16th 2019, 13:56 paul_83uk in production