| # |
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 |
| # |
Mar 6th 2018, 21:28 |
ricksaccous |
I've got a docker going on my mac but I'm running into trouble with vagrant boxes on my windows |
| # |
Mar 6th 2018, 21:28 |
savant |
and then deploy to a paas like dokku (which I maintain) or heroku |
| # |
Mar 6th 2018, 21:28 |
savant |
or `brew install postgres` since postgres is a nicer database |
| # |
Mar 6th 2018, 21:28 |
savant |
i used to maintain homebrew-php and so am _very_ comfortable with that setup |
| # |
Mar 6th 2018, 21:27 |
ricksaccous |
i see |
| # |
Mar 6th 2018, 21:27 |
savant |
works fine |
| # |
Mar 6th 2018, 21:27 |
savant |
brew install mysql |
| # |
Mar 6th 2018, 21:27 |
savant |
source in my env vars, run that |
| # |
Mar 6th 2018, 21:27 |
savant |
`bin/cake server` |
| # |
Mar 6th 2018, 21:27 |
savant |
php on my mac |
| # |
Mar 6th 2018, 21:27 |
ricksaccous |
a vagrant box? |