| # |
Jul 6th 2018, 09:21 |
 neon1024 |
Seems like it makes sense to me at least :slightly_smiling_face: Thanks @josbeir |
| # |
Jul 6th 2018, 09:20 |
neon1024 |
File uploaded https://cakesf.slack.com/files/U1BT622HW/FBL4E7XQD/check_for_resetting_a_password.php / https://slack-files.com/T053DPNCM-FBL4E7XQD-05df9508df |
| # |
Jul 6th 2018, 09:19 |
lorenzo |
what are you iterating? is it just an array? |
| # |
Jul 6th 2018, 09:18 |
k4t |
ok, thanks |
| # |
Jul 6th 2018, 09:18 |
lorenzo |
you can switch from one mode to the other easily |
| # |
Jul 6th 2018, 09:18 |
josbeir |
* @param string|int|\DateTime|\DateTimeImmutable $value The value to convert. |
| # |
Jul 6th 2018, 09:17 |
lorenzo |
there is though, an optimization in place, that if the collection detects that the underlying data is just an array, it will iterate all elements. As it is actually faster doing all operations than streaming them |
| # |
Jul 6th 2018, 09:17 |
josbeir |
public static $dateTimeClass = 'Cake\I18n\Time'; |
| # |
Jul 6th 2018, 09:17 |
josbeir |
DateTimeType uses Time i think |
| # |
Jul 6th 2018, 09:17 |
lorenzo |
@k4t well, for the most pat collections are lazy, you will not iterate all elements until you demand them |
| # |
Jul 6th 2018, 09:17 |
josbeir |
Time |
| # |
Jul 6th 2018, 09:16 |
neon1024 |
DateTime, Chronos, Time or Date? |
| # |
Jul 6th 2018, 09:16 |
neon1024 |
Ah, but which one?! |
| # |
Jul 6th 2018, 09:16 |
josbeir |
check datetimetype |
| # |
Jul 6th 2018, 09:16 |
josbeir |
cake knows what to do with it |
| # |
Jul 6th 2018, 09:16 |
josbeir |
just pass a DateTime object |
| # |
Jul 6th 2018, 09:16 |
k4t |
@lorenzo if order or returned object will meet my needs than yes, ->first will be enough but still... I have to iterate over whole collection. I am curious if it is possible to do not do this |
| # |
Jul 6th 2018, 09:16 |
neon1024 |
So i guess `DATE_FORMAT()` |
| # |
Jul 6th 2018, 09:16 |
josbeir |
then you need to convert that into a datetime string to |
| # |
Jul 6th 2018, 09:16 |
neon1024 |
Nope, I used `datetime` |
| # |
Jul 6th 2018, 09:15 |
neon1024 |
@josbeir Thanks, I’ll go write some code rather than second guessing myself! :thumbsup: |
| # |
Jul 6th 2018, 09:15 |
josbeir |
is your reset_token_created a unix timestamp neon? |
| # |
Jul 6th 2018, 09:15 |
josbeir |
as seconds are a part of the datetime type :P |
| # |
Jul 6th 2018, 09:15 |
braeden |
The <=' => is a bit of an eye-sore :) |
| # |
Jul 6th 2018, 09:15 |
lorenzo |
@k4t is calling $collection->first() not enough? |
| # |
Jul 6th 2018, 09:15 |
josbeir |
it should... |
| # |
Jul 6th 2018, 09:15 |
neon1024 |
To the database-a-majig! |
| # |
Jul 6th 2018, 09:14 |
josbeir |
do it using an expression then :) |
| # |
Jul 6th 2018, 09:14 |
neon1024 |
But does datetime compare with seconds? |
| # |
Jul 6th 2018, 09:14 |
k4t |
yes @lorenzo, my collection contain multiple objects which meet certain condtion but I am only interested in first one and I did not want to iterate over whole collection |
| # |
Jul 6th 2018, 09:14 |
neon1024 |
Man I don’t like that `d <=' => s` |
| # |
Jul 6th 2018, 09:14 |
josbeir |
there you go :slightly_smiling_face: |
| # |
Jul 6th 2018, 09:14 |
neon1024 |
`->where(['reset_token_created <=' => strtotime('-1 hour')])` |
| # |
Jul 6th 2018, 09:14 |
josbeir |
? |
| # |
Jul 6th 2018, 09:14 |
josbeir |
< DATE_SUB(NOW(),INTERVAL 1 HOUR) |
| # |
Jul 6th 2018, 09:13 |
lorenzo |
@k4t is there a reason you need to do that? |
| # |
Jul 6th 2018, 09:13 |
neon1024 |
Sorry for a stupid question, but my brain is rebelling. I want to see if a `datetime` mysql column is not older than 1 hour. |
| # |
Jul 6th 2018, 09:13 |
k4t |
Hi I am filtering collection of object using ->filter method. How I can break the iteration under certain condition in filter function callback? |
| # |
Jul 6th 2018, 09:12 |
josbeir |
most obfuscation techniques are easily unobfuscated |
| # |
Jul 6th 2018, 09:12 |
josbeir |
i would also think twice in doing it, ask yourself what the purpose is and why you want to do it |
| # |
Jul 6th 2018, 09:11 |
a.didier |
ok thx |