Log message #4218292

# At Username Text
# Dec 11th 2019, 13:13 scuadra Hello. I have a field `expire_date` of type `DATE` in a table. I want to select the `DATEDIFF` between this field and today. How can I do this in Cake 3.x? In Cake 2.x I used the following: 'DATEDIFF(Event.expire_date, CURDATE()) as days_remaining'
# Dec 11th 2019, 13:02 jh as for logging, did you configure to auto expire
# Dec 11th 2019, 13:02 jh Is anyone of you using redis with https://github.com/lorenzo/cakephp-redis to filter/search/index/display redis data?
# Dec 11th 2019, 13:01 jh Is anyone of you using redis for logging?
# Dec 11th 2019, 12:12 challgren https://getcomposer.org/doc/05-repositories.md#loading-a-package-from-a-vcs-repository
# Dec 11th 2019, 12:12 boydbuenodemesquita Yeah, we're planning to go live next week, so I was setting up production right now. Talking about bad timing.
# Dec 11th 2019, 12:12 narendravaghela or you can move to your app's plugin directoruy
# Dec 11th 2019, 12:11 challgren Yep
# Dec 11th 2019, 12:11 boydbuenodemesquita I'll take that route. I can just require packagest directly from git right? I don't need to publish them somewhere?
# Dec 11th 2019, 12:11 narendravaghela :)
# Dec 11th 2019, 12:10 challgren Thats the one thing I dont like about composer is the package can go missing and totally wreck your world
# Dec 11th 2019, 12:10 challgren Thats what I would do take the files in vendor and make my own repo.
# Dec 11th 2019, 12:09 narendravaghela both packages are different
# Dec 11th 2019, 12:08 narendravaghela @boydbuenodemesquita That package does not exists in their github account. So, you have to update the vendor files itself or as @challgren suggested create one from the files.
# Dec 11th 2019, 12:08 boydbuenodemesquita This one doesn't seem to use the same method of setting the response though. So it doesn't seem like it's just a drop in replacement. But I'll definitely try one of the other ones.
# Dec 11th 2019, 12:05 narendravaghela This is an improved version
# Dec 11th 2019, 12:05 boydbuenodemesquita Thanks for the help guys. :slightly_smiling_face:
# Dec 11th 2019, 12:04 narendravaghela check this one as well - https://github.com/sprintcube/cakephp-rest
# Dec 11th 2019, 12:04 boydbuenodemesquita Yeah, it seems to be gone since a week or so. I'll try a fork, one of the forks you sent seems promising.
# Dec 11th 2019, 12:04 narendravaghela the company has removed that repo from their account
# Dec 11th 2019, 12:03 challgren Yeah, so @boydbuenodemesquita maybe use a fork
# Dec 11th 2019, 12:03 narendravaghela if you see the readme, he hasn't change the installation line ```composer require multidots/cakephp-rest-api```
# Dec 11th 2019, 12:02 narendravaghela years ago under my organization - multidots
# Dec 11th 2019, 12:02 narendravaghela The original repo was created by me, someone has duplicated i
# Dec 11th 2019, 12:02 narendravaghela I mean yes
# Dec 11th 2019, 12:01 narendravaghela Nah
# Dec 11th 2019, 12:01 challgren What I would suggest since its in vendor/ maybe creating a repo for yourself and upload it so you still have it
# Dec 11th 2019, 12:01 challgren Thats not you?
# Dec 11th 2019, 12:01 challgren https://github.com/vishal2995/cakephp-rest-api/commit/61f0e999224d776fb0bd797aedc32f1d6b3a787c
# Dec 11th 2019, 12:00 narendravaghela nope
# Dec 11th 2019, 12:00 challgren I found https://github.com/vishal2995/cakephp-rest-api
# Dec 11th 2019, 12:00 challgren @narendravaghela didnt you make a fork of this?
# Dec 11th 2019, 12:00 boydbuenodemesquita Yeah, I was looking for that as well. Thanks for checking! I still have the package locally, so I think I can make it work.
# Dec 11th 2019, 12:00 challgren Ahh maybe! https://github.com/innovato/cakephp-rest-api
# Dec 11th 2019, 11:58 challgren @boydbuenodemesquita Ive been searching around for a fork you could use but cant really find any
# Dec 11th 2019, 11:43 neon1024 That would get frustrating for users I think, but it depends on your use-case I suppose. More secure systems might need a shorter session :thinking_face:
# Dec 11th 2019, 11:43 neon1024 15 minute sessions is super quick imo
# Dec 11th 2019, 11:40 challgren Seems like the repo owner deleted the project
# Dec 11th 2019, 11:37 boydbuenodemesquita I'm working on an old project that uses the `multidots/cakephp-rest-api` package. When trying to set up the project on a new environment it seems that this package no longer exists. Does anyone here have any information about what happened?
# Dec 11th 2019, 11:27 jotpe Okay, thanks @challgren :slightly_smiling_face:
# Dec 11th 2019, 11:19 challgren 15 would probably be more reasonable. On every request the db is updated with the last_activity_time