| # |
Mar 6th 2018, 23:55 |
 etipaced |
Ok. I’ve never contributed before, so I’ll see about getting things setup so I can review. |
| # |
Mar 6th 2018, 23:54 |
rafael.junqueira.sant |
@dereuromark, can you help me with the question I asked above? |
| # |
Mar 6th 2018, 23:52 |
dereuromark |
you can also confirm if it works the way you want/need it |
| # |
Mar 6th 2018, 23:52 |
dereuromark |
yes, it does |
| # |
Mar 6th 2018, 23:51 |
etipaced |
Definitely related. Does 10877 need contribution still? |
| # |
Mar 6th 2018, 23:45 |
dereuromark |
seems related to https://github.com/cakephp/cakephp/pull/11780 and https://github.com/cakephp/cakephp/issues/10877 |
| # |
Mar 6th 2018, 23:43 |
etipaced |
What is the correct way to convert user data into UTC? |
| # |
Mar 6th 2018, 23:43 |
etipaced |
When user supplied datetime values are marshaled into entity properties as FrozenTime objects, Cake is assuming the timezone is UTC, but this isn’t the case as the user is assuming that the value is in PST. So my object is erroneous: ``` object(Cake\I18n\FrozenTime) { 'time' => '2018-04-01T16:00:00+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false } ``` |
| # |
Mar 6th 2018, 22:58 |
rafael.junqueira.sant |
the documentation has an example with users (user_favorite_pages), but in this case the controller will be able to contain the Users data, but in my case, what makes me confused is what is the convention for multiple words tables so they can be contained by the controllers they are related to |
| # |
Mar 6th 2018, 22:52 |
rafael.junqueira.sant |
Hello! I have the following situation: a page named For Whom. I wanted to call the table for_whoms, and the table with translations I'd call for_whom_translations, is this the right way to do it? I want ForWhomTranslationsController to contain ForWhoms and be able to access it. |
| # |
Mar 6th 2018, 22:16 |
savant |
What orm code are you running now and what is the query it generates? |
| # |
Mar 6th 2018, 22:16 |
slackebot |
view_count >= 10) and if i run something like that in the database gives all the columns so i just assumed that is how it would be. |
| # |
Mar 6th 2018, 22:16 |
ank068 |
That makes sense, but according to the documentation this: $query = $articles->find() ->where(function ($exp) { $orConditions = $exp->or_(['author_id' => 2]) ->eq('author_id', 5); return $exp ->add($orConditions) ->eq('published', true) ->gte('view_count', 10); }); produces this: SELECT \* FROM articles WHERE ( (author_id = 2 OR author_id = 5) AND published = 1 AND |
| # |
Mar 6th 2018, 22:12 |
ricksaccous |
oh i didn't know that since i never manually join, hehe |
| # |
Mar 6th 2018, 22:12 |
savant |
if you manually join, you need to add `->select()` with the appropriate columns |
| # |
Mar 6th 2018, 22:12 |
ricksaccous |
or if you manually join them like you did |
| # |
Mar 6th 2018, 22:12 |
ricksaccous |
@ank068 you are supposed to define associations in the TimeClocks Table class, then you can reference them in a contain |
| # |
Mar 6th 2018, 22:07 |
savant |
I would instead use `contain()` for this instead of manually creating a leftJoin. |
| # |
Mar 6th 2018, 22:07 |
savant |
You didn’t specify that you wanted the Employees columns as well |
| # |
Mar 6th 2018, 22:07 |
savant |
If you dont specify columns, it will use the table’s columns |
| # |
Mar 6th 2018, 22:06 |
savant |
It retrieves all the columns specified |
| # |
Mar 6th 2018, 22:06 |
savant |
No |
| # |
Mar 6th 2018, 22:06 |
ank068 |
Isn't the find() function suppose to make it like "select * from TimeClocks..."? Why is the "*" not happening? |
| # |
Mar 6th 2018, 22:02 |
ank068 |
@ricksaccous That worked for Employees but not for Positions. Gives me an error saying that positions is not associated with TimeClocks. |
| # |
Mar 6th 2018, 21:51 |
ricksaccous |
try a contain of Employees after left join? |
| # |
Mar 6th 2018, 21:49 |
ank068 |
File uploaded https://cakesf.slack.com/files/U91GR08DV/F9LLMFF1V/-.txt / https://slack-files.com/T053DPNCM-F9LLMFF1V-3956a14658 - Just gives me the columns from TimeClocks table |
| # |
Mar 6th 2018, 21:48 |
ank068 |
Anyone know how to get all the columns from all tables on a left join using querybuilder? |
| # |
Mar 6th 2018, 21:40 |
savant |
iirc |
| # |
Mar 6th 2018, 21:40 |
savant |
FrozenTime scopes it to just Time |
| # |
Mar 6th 2018, 21:38 |
etipaced |
Is how I read that, at least. |
| # |
Mar 6th 2018, 21:38 |
etipaced |
So FrozenTime gives us Chronos plus a little more. |
| # |
Mar 6th 2018, 21:38 |
etipaced |
``` class FrozenTime extends Chronos implements JsonSerializable class Chronos extends DateTimeImmutable implements ChronosInterface ``` |
| # |
Mar 6th 2018, 21:37 |
savant |
@etipaced I think Chronos is immutable but its DateTime? |
| # |
Mar 6th 2018, 21:37 |
etipaced |
@savant Isn’t Chronos immutable as well? |
| # |
Mar 6th 2018, 21:32 |
savant |
https://github.com/Homebrew/legacy-homebrew/issues/10673 |
| # |
Mar 6th 2018, 21:31 |
ricksaccous |
i see |
| # |
Mar 6th 2018, 21:31 |
savant |
yeah I havent done homebrew-php work in a while, but it was originally _my_ project. |
| # |
Mar 6th 2018, 21:30 |
ricksaccous |
hahaha |
| # |
Mar 6th 2018, 21:30 |
ricksaccous |
also I think I remember seeing your maintenance stuff on php homebrew and thinking is that the cake guy? |
| # |
Mar 6th 2018, 21:30 |
ricksaccous |
anyway i think i'll just switch over to my mac for now to get work done, yargh |
| # |
Mar 6th 2018, 21:29 |
ricksaccous |
one thing i do like about vagrant boxes is you can set them to an ip and then use hosts to change the url |