| # |
Aug 20th 2019, 20:12 |
 maymeow |
for mysql doesnt matter ... |
| # |
Aug 20th 2019, 20:11 |
slackebot |
$query->distinct(['Posts.created', 'Posts.sender_name'])->combine('sender_name', 'sender_name'); } ``` |
| # |
Aug 20th 2019, 20:11 |
maymeow |
@ricksaccous what i found for example if you ordering something by created field postgres will return error if you selecting distinct on another field so you have to select on both and mssql will return error when you selecting distinct on both :) ``` if ($conn['driver'] == Sqlserver::class) { $senders = $query->distinct(['Posts.sender_name'])->combine('sender_name', 'sender_name'); } else { $senders = |
| # |
Aug 20th 2019, 20:06 |
daniel.upshaw |
Thanks for the info @admad :slightly_smiling_face: |
| # |
Aug 20th 2019, 20:06 |
ricksaccous |
weird |
| # |
Aug 20th 2019, 20:06 |
maymeow |
@ricksaccous it dont have problem when i use postgres or MSSQL |
| # |
Aug 20th 2019, 20:05 |
ricksaccous |
yeah that makes more sense @maymeow i don't see how inserting a class makes sense from a migrations standpoint so i don't know how it was working before but glad it's working now |
| # |
Aug 20th 2019, 20:04 |
admad |
so basically anything you can do with chronos instance you can with frozentime |
| # |
Aug 20th 2019, 20:04 |
maymeow |
dont know if its good idea but forkink for me :) |
| # |
Aug 20th 2019, 20:04 |
admad |
@daniel.upshaw frozentime wraps chronos and all some i18n formatting features |
| # |
Aug 20th 2019, 20:03 |
maymeow |
refresh ... updated |
| # |
Aug 20th 2019, 20:03 |
ricksaccous |
heh intersting |
| # |
Aug 20th 2019, 20:03 |
daniel.upshaw |
Now I'm curious about that lol |
| # |
Aug 20th 2019, 20:03 |
daniel.upshaw |
But seems the docs always mention `FrozenTime` |
| # |
Aug 20th 2019, 20:03 |
daniel.upshaw |
And active too: https://github.com/cakephp/chronos |
| # |
Aug 20th 2019, 20:02 |
daniel.upshaw |
This is the first I'd seen Chronos actually... looks interesting |
| # |
Aug 20th 2019, 20:02 |
maymeow |
old file in git... just changed it in notebook |
| # |
Aug 20th 2019, 20:02 |
maymeow |
sorry |
| # |
Aug 20th 2019, 20:01 |
daniel.upshaw |
Not using `FrozenTime`? |
| # |
Aug 20th 2019, 20:00 |
maymeow |
changed `'created' => \Cake\Chronos\Date::now(),` to `'created' => \Cake\Chronos\Date::now()->toDateTimeString(),` and its now working |
| # |
Aug 20th 2019, 19:59 |
maymeow |
@ricksaccous https://gist.github.com/MayMeow/c03b0cda19e0703bede81190fa13c56e |
| # |
Aug 20th 2019, 19:56 |
ricksaccous |
whatever |
| # |
Aug 20th 2019, 19:56 |
ricksaccous |
or i mean obfuscate them |
| # |
Aug 20th 2019, 19:56 |
ricksaccous |
feel free to comment out stuff/etc |
| # |
Aug 20th 2019, 19:56 |
ricksaccous |
can you gist the migration? I'm curious now |
| # |
Aug 20th 2019, 19:55 |
maymeow |
i think its same CEST... when i change app config to CEST or europe/something even on datasource config still not working |
| # |
Aug 20th 2019, 19:54 |
maymeow |
my notebook has CEST timezone and mysql has SYSTEM |
| # |
Aug 20th 2019, 19:54 |
ricksaccous |
so you have the default admin on those? |
| # |
Aug 20th 2019, 19:54 |
ricksaccous |
weird... |
| # |
Aug 20th 2019, 19:54 |
maymeow |
i didnt have this problem on dokce or on review server on digital ocean but on my notebook yes |
| # |
Aug 20th 2019, 19:54 |
ricksaccous |
hehe |
| # |
Aug 20th 2019, 19:53 |
ricksaccous |
also I still use seeds I just make sure they only run once ;) I do that by doing a find() and if there are results I just skip the seed |
| # |
Aug 20th 2019, 19:53 |
ricksaccous |
okay well it depends how you are doing the migration |
| # |
Aug 20th 2019, 19:53 |
maymeow |
migrations can run only once thats why |
| # |
Aug 20th 2019, 19:52 |
maymeow |
@ricksaccous no migration. I wanted to create admin on install application so i created new migration where i insert new user.. |
| # |
Aug 20th 2019, 19:52 |
ricksaccous |
you're literally just saving a string to db |
| # |
Aug 20th 2019, 19:52 |
ricksaccous |
in migrations you don't have cake magic doing the saving |
| # |
Aug 20th 2019, 19:52 |
ricksaccous |
also you don't want a datetime object, what you want is a string that the database expects |
| # |
Aug 20th 2019, 19:51 |
ricksaccous |
@maymeow do you mean seed rather than migration? |
| # |
Aug 20th 2019, 19:45 |
pedrorocha |
Thank you guys! |
| # |
Aug 20th 2019, 19:35 |
maymeow |
@Dan yes its returning UTC date time i think... i have set app.ini to europe/bratislava and datasource timezone is same |