Log message #4193679

# At Username Text
# Jul 17th 2019, 10:53 neon1024 At least, that’s always been my experience of it
# Jul 17th 2019, 10:53 neon1024 Most of the posts you’ll find if you Google will tell you that Symfony or Laravel are quicker depending on which one the author prefers
# Jul 17th 2019, 10:52 aivaras.godliauskas i see.
# Jul 17th 2019, 10:52 neon1024 You’ll get the results you want to get and learn nothing about the frameworks performance
# Jul 17th 2019, 10:52 neon1024 Benchmarking frameworks is a pointless venture
# Jul 17th 2019, 10:51 neon1024 At least, that’s what I’ve put in the ticket for myself to look at
# Jul 17th 2019, 10:51 neon1024 I was going to run my test suite, note the time, refactor my use of fixture loading and run the suite again to see if it was quicker
# Jul 17th 2019, 10:51 aivaras.godliauskas thats sad
# Jul 17th 2019, 10:51 neon1024 @aivaras.godliauskas I’m not.
# Jul 17th 2019, 10:50 neon1024 :white_check_mark:
# Jul 17th 2019, 10:50 aivaras.godliauskas @neon1024 can you tell how are you running benchmarks on cake?
# Jul 17th 2019, 10:50 neon1024 It’s a non-standard table name, so you must declare `public $table = 'script_composed_of'` then it’ll work
# Jul 17th 2019, 10:46 neon1024 Seems that because I have database constraints, I have to execute the fixtures in a specific order
# Jul 17th 2019, 10:26 neon1024 Points if you can tell me why my Fixture isn’t actually creating a database table https://pastebin.com/UEnGV6vQ
# Jul 17th 2019, 10:11 neon1024 Guess I could benchmark that myself actually :thinking_face:
# Jul 17th 2019, 10:10 neon1024 Is it worthwhile to manually load fixtures for test-cases which need extra fixtures? So they’re not loaded for every test-case
# Jul 17th 2019, 09:58 neon1024 Hey @dereuromark when doing a `@property` in the class, with or without a dollar? `@property \App\Model\Table\ExamplesTable $Examples`
# Jul 17th 2019, 09:09 ankitgsolanki I have following line of code for update mysql mariaDB view. ```$stmt = $conn->execute('update `listing` set `longitude` = ?, `latitude` = ? where `id` = ?',[-96.1080, 31.7356, 1922]);``` And I am getting following error *General error: 1221 Incorrect usage of UPDATE and ORDER BY*
# Jul 17th 2019, 08:45 maymeow @graziel i found reason why it isnt working. It looks like you can translate only default cakephp files if you want to translate own classes like me it will return error
# Jul 17th 2019, 08:08 graziel @maymeow did quick check on cake 3.8.1 and works ok for me
# Jul 17th 2019, 08:01 maymeow @graziel no i have config in app.php i didnt update anything :slightly_smiling_face:... problem is caused with i18n in my opinion
# Jul 17th 2019, 07:59 admad sorry gtg
# Jul 17th 2019, 07:57 h.mavisakalian @admad Can you give me an example of a raw SQL query that you’re talking about.
# Jul 17th 2019, 07:54 maymeow @admad How? `$this->addPlugin('I18n');` i have installed package 3.79
# Jul 17th 2019, 07:52 admad if you can't then use the search plugin and figure out the solution by trail and error :slightly_smiling_face:
# Jul 17th 2019, 07:51 admad that's still pseudo SQL, not actual SQL :slightly_smiling_face:
# Jul 17th 2019, 07:50 h.mavisakalian $array will have values like this … %Value1%, %Value2%, %Value3%
# Jul 17th 2019, 07:49 h.mavisakalian “SELECT name FROM Users WHERE name LIKE {$array}”
# Jul 17th 2019, 07:47 admad @h.mavisakalian step 1: Figure out the SQL query you need to get the result you want
# Jul 17th 2019, 07:47 conehead I think `IN` is at least one. So Even with 2 or more values it should show up
# Jul 17th 2019, 07:46 h.mavisakalian also bring the results that have 2 of the array values in the title
# Jul 17th 2019, 07:46 h.mavisakalian but
# Jul 17th 2019, 07:46 h.mavisakalian $query = $this->Users->find(‘all’,[ ‘conditions’ => [‘name LIKE’ => $searchArray], ‘order’ => [‘Users.id’ => ‘ASC’] ]);
# Jul 17th 2019, 07:46 h.mavisakalian something like this
# Jul 17th 2019, 07:45 h.mavisakalian that is why I mentioned the LIKE
# Jul 17th 2019, 07:45 h.mavisakalian @conehead Thank you, but I need something else… you see the problem is I need the query to give me the results of the rows that for example have 2 values from the array as well
# Jul 17th 2019, 07:42 admad yes
# Jul 17th 2019, 07:41 koeller @admad So the proper way would be that the client sends another index request?
# Jul 17th 2019, 07:41 conehead @h.mavisakalian probably you need something like this: ``` $query = $this->Users->find(‘all’,[ ‘conditions’ => ['yourField IN' => $searchArray], ‘order’ => [‘Users.id’ => ‘ASC’] ]); ```
# Jul 17th 2019, 07:40 admad @koeller for a REST API for a delete request you just respond with a success/failure status
# Jul 17th 2019, 07:39 admad @maymeow if it's a standalone plugin first plug it into an app :slightly_smiling_face: