Log message #4190438

# At Username Text
# Jun 21st 2019, 09:30 conehead I don't really get what you are trying to achive. Count all where `role = 1`)
# Jun 21st 2019, 09:27 kgb.acct.personal It looks like this. But it seems hackish ``` $users->func()->count('DISTINCT CASE WHEN role = 1 THEN role END') ```
# Jun 21st 2019, 09:27 conehead https://book.cakephp.org/3.0/en/orm/table-objects.html#afterdelete
# Jun 21st 2019, 09:27 kgb.acct.personal How do I do conditional count?
# Jun 21st 2019, 09:26 conehead Well you could check in afterSave or afterSaveCommit
# Jun 21st 2019, 09:12 peppejaripappalardo Hi guys, i need an help please. I adding muffin/trash behavior a run time into the controller, because i have many entity related and that can give problem if i put the behavior into the table, e.g. Historical View. I need to cascade soft-delete item, there is a way to append into the table AddBehavior if Users deleted entity is not null?
# Jun 21st 2019, 07:36 graziel then its in link i gave : )
# Jun 21st 2019, 07:35 nuzulfikrie i am using the latest version
# Jun 21st 2019, 07:35 graziel dont remember the older
# Jun 21st 2019, 07:35 graziel in newer i think yes, https://github.com/cakephp/app/blob/master/config/routes.php#L58
# Jun 21st 2019, 07:27 nuzulfikrie my question now is does CAKEPHP CSRF is enabled by default ? .
# Jun 21st 2019, 07:26 nuzulfikrie disabling this line 'code' $this->loadComponent('Csrf'); 'code' resolve error.
# Jun 21st 2019, 07:26 nuzulfikrie hi team, need help. i am having ' CRSF token mismatch error ' on delete action.
# Jun 21st 2019, 06:49 conehead Good morning everyone
# Jun 21st 2019, 06:09 noypi2020 Hi, Good day! mod_rewrite is enabled on the server and the .htaccess files were intact. I cannot figure out where to fix those errors.
# Jun 21st 2019, 04:19 joey.mukherjee Looks like this works! In case someone else searches for it: ` $routes->connect ('/:uuiid', ['controller' => 'Plots', 'action' => 'view']) ->setPatterns (['uuid' => '[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}']);`
# Jun 21st 2019, 04:11 joey.mukherjee Is there a better way of capturing a UUID from the url?
# Jun 21st 2019, 04:03 joey.mukherjee I copied directly from that page in the book! That's how I got the errors. Ok, I also have this: `$routes->connect ('/**', ['controller' => 'Plots', 'action' => 'view']);` I need that since I want to pass a UUID on the url?
# Jun 21st 2019, 03:59 mrfeedback @joey.mukherjee https://book.cakephp.org/3.0/en/development/routing.html#prefix-routing
# Jun 21st 2019, 03:59 challgren Just do something like this @joey.mukherjee
# Jun 21st 2019, 03:57 joey.mukherjee question about admin routing... If I want an admin prefix, I add ```Router::prefix('admin', function (RouteBuilder $routes) { $routes->connect ('/', ['controller' => 'admin', 'action' => 'index']);
# Jun 20th 2019, 20:04 ricksaccous I think it's because I'm not using the OrmPolicy but the mapper policy which runs in the middleware before the controller is hit
# Jun 20th 2019, 19:59 ricksaccous is not stopping the policy from happening
# Jun 20th 2019, 19:59 ricksaccous my skipAuthorization method from my component
# Jun 20th 2019, 19:59 ricksaccous hmmm
# Jun 20th 2019, 19:53 ricksaccous actually i think i'll be fine pushing them back to their dashboard
# Jun 20th 2019, 19:52 ricksaccous i suppose i'll just have to write a handle that extends redirect
# Jun 20th 2019, 19:41 ricksaccous hmm
# Jun 20th 2019, 19:41 ricksaccous there must be an easy way to redirect to referer
# Jun 20th 2019, 19:40 ricksaccous https://book.cakephp.org/authorization/1.1/en/middleware.html#handling-unauthorized-requests
# Jun 20th 2019, 18:06 mdotobie gotcha. well this actually might be a better way to do this
# Jun 20th 2019, 18:05 admad Webservice is akin to db connection and Driver is akin to pdo driver
# Jun 20th 2019, 18:04 admad Endpoint is akin to Table and Resource is akin to Entity
# Jun 20th 2019, 18:02 mdotobie Any insight on the difference between Endpoint and Resource?
# Jun 20th 2019, 18:00 admad Endpoint is your model abstraction. You would create a driver which reads the json file instead of making a GET request
# Jun 20th 2019, 17:59 mdotobie The other thing I would have wanted to add @admad would be a way to define the schema of the loaded data for validation purposes (since it’s handwritten). But I really liked the _transformResults method it has for parsing the JSON, however, I’m basically using `JsonConfig` through the `Configure` class to perform the same function.
# Jun 20th 2019, 17:57 mdotobie @admad on this particular use the JSON is written by hand in advance it isn’t coming from a service. But I was thinking about how I could extend it in the future. I did come across Webservice when I was researching if what I was trying to do was possible and how would I architect it. My only question was around whether an “endpoint” could be a file or was a URL you’re only option.
# Jun 20th 2019, 17:52 admad @mdotobie if you are fetching data from an external API is suggest you checkout muffin/webservice
# Jun 20th 2019, 17:48 mdotobie I think a really good way I intend to extend this is for caching JSON data from sources. Then the cached JSON can be read in as config data and can be updated on a schedule or on demand. But it doesn’t need to be retrieved fresh on each request because it won’t change often.
# Jun 20th 2019, 17:46 mdotobie I think I like this architecture.
# Jun 20th 2019, 17:46 slackebot1 `\App\Model\Table` namespace as `ShippingItemTable`. Instead of extending `\Cake\ORM\Table` like a normal Table, it extends `App\Model\Datasource\Json`. In turn, the Entity is in the `\App\Model\Entity` namespace as `ShippingItem`