Log message #4202710

# At Username Text
# Sep 12th 2019, 02:11 ouroboros Odd question but has anybody here done a migration from adobe catalyst to cakephp?
# Sep 12th 2019, 00:55 MoanaSilva The query builder don't detect the ( and the ) in the column name
# Sep 12th 2019, 00:44 MoanaSilva Hello... I'm having troubles with a column in a table, and this column is called "Ativo (Produto)"... even with the quoteIdentifiers = true this field is being quoted as `Varietyandprocessing`.`Ativo` (Produto) AS `Varietyandprocessing__Ativo (Produto)`
# Sep 12th 2019, 00:25 dereuromark Phantom: I recommend using a better naming convention ( https://sandbox.dereuromark.de/pages/best-practices#config )
# Sep 11th 2019, 20:44 phantomwatson Also, check out the CakePHP docs regarding decoding a request in the form of a CSV file: https://book.cakephp.org/3.0/en/controllers/components/request-handling.html#automatically-decoding-request-data
# Sep 11th 2019, 20:42 phantomwatson The library that I use for reading CSV files is PhpSpreadsheet (https://github.com/PHPOffice/PhpSpreadsheet).
# Sep 11th 2019, 20:41 phantomwatson Question: Why is it recommended that `app.php` not be committed while it's also recommended that sensitive data be removed and put in environment variables? I don't get why one would still not commit it.
# Sep 11th 2019, 20:41 Kwid2019 Yes, an action to upload CSV into a table in my own application...
# Sep 11th 2019, 20:39 phantomwatson You mean you need your own application to handle the importing of a CSV file?
# Sep 11th 2019, 20:38 Kwid2019 but I need a screen in my application for the user
# Sep 11th 2019, 20:37 phantomwatson Try importing it with phpMyAdmin.
# Sep 11th 2019, 20:16 Kwid201982 Hey guys... I have a 200 thousand lines CSV file.. what's the best way to upload it to a table??? There's any plugin? :think:
# Sep 11th 2019, 18:24 itmpls n/m
# Sep 11th 2019, 18:20 itmpls obviously chaining them doesn't work because they mutate
# Sep 11th 2019, 18:19 itmpls how can I apply an extract but also have it grouped by, beforehand? currently I . have ->extract('dispatch_number') but want to groupBy('region_id')
# Sep 11th 2019, 14:05 dereuromark you can help completing the list if you want to.
# Sep 11th 2019, 14:05 dereuromark jep
# Sep 11th 2019, 14:05 mikesmoniker Can anyone tell me what “Work on the cakephp4 rector configuration has been started.” means? Does that refer to config sets in the rectorphp/rector repo?
# Sep 11th 2019, 13:52 ricksaccous yeah i agree
# Sep 11th 2019, 13:44 neon1024 Feels neater than trying to cross-call controller methods
# Sep 11th 2019, 13:44 neon1024 So figured I’d append to the endpoint and hit it from the template with JS
# Sep 11th 2019, 13:44 neon1024 Now I’ve been asked to use some of it’s data elsewhere
# Sep 11th 2019, 13:44 neon1024 Kinda, the internal endpoint is used primarily by Vue
# Sep 11th 2019, 13:43 ricksaccous @neon1024 vue?
# Sep 11th 2019, 13:41 neon1024 Think I’ll hit it with js, as it’s more in-line with the methods intended functionality :)
# Sep 11th 2019, 13:40 neon1024 ..or I hit it from the front-end with JS
# Sep 11th 2019, 13:40 neon1024 Probably the latter I would imagine, but an extra http call feels odd
# Sep 11th 2019, 13:40 neon1024 If I have an api controller which I now need elsewhere, is it easier to instanciate and call the controller method, or just use Client to hit the url
# Sep 11th 2019, 13:14 spriz we're only 5 on the team atm, so it could be years in the future :,)
# Sep 11th 2019, 13:14 spriz for now it's no problem, I just know for sure that sometime in the future some other dev will be fucked by this
# Sep 11th 2019, 13:13 ricksaccous lol okay
# Sep 11th 2019, 13:13 spriz I'll go for the least magic and only do it on the primary table :)
# Sep 11th 2019, 13:13 ricksaccous @spriz let me know what you end up doing because i'm going to have to do something similar
# Sep 11th 2019, 13:08 lubos ``` addSubcommand('exp', [ 'help' => '...', 'parser' => [ 'arguments' => [ 'file' => [ 'help' => '....' ] ] ] ])
# Sep 11th 2019, 13:07 ricksaccous oh well
# Sep 11th 2019, 13:07 ricksaccous or that you could specify
# Sep 11th 2019, 13:07 ricksaccous i kind of wish it did aftersaves as well
# Sep 11th 2019, 13:06 spriz it explicitly states `delete` in the api for that
# Sep 11th 2019, 13:06 spriz Yeah I would not expect that as well :P
# Sep 11th 2019, 13:03 ricksaccous i doubt it will though
# Sep 11th 2019, 13:03 ricksaccous just try cascadeCallbacks and see if it works, lol