| # |
Mar 14th 2018, 11:38 |
 narendravaghela |
The goal is - find all time log entries with date wise sum |
| # |
Mar 14th 2018, 11:37 |
narendravaghela |
Got it, I need to prepare array in `join` method |
| # |
Mar 14th 2018, 11:36 |
narendravaghela |
So, I tried join |
| # |
Mar 14th 2018, 11:36 |
neon1024 |
https://book.cakephp.org/3.0/en/orm/query-builder.html#subqueries |
| # |
Mar 14th 2018, 11:36 |
narendravaghela |
I got a subquery solution form stackoverflow to achieve the goal |
| # |
Mar 14th 2018, 11:36 |
neon1024 |
Join is not the method you need |
| # |
Mar 14th 2018, 11:36 |
neon1024 |
https://book.cakephp.org/3.0/en/orm/query-builder.html#adding-joins |
| # |
Mar 14th 2018, 11:35 |
narendravaghela |
The goal is - find all time log entries with date wise sum |
| # |
Mar 14th 2018, 11:34 |
narendravaghela |
I was pasting the code :slightly_smiling_face: |
| # |
Mar 14th 2018, 11:34 |
narendravaghela |
https://pastebin.com/LH9L3Z7D |
| # |
Mar 14th 2018, 11:34 |
neon1024 |
Are you using `join()` ? |
| # |
Mar 14th 2018, 11:33 |
neon1024 |
That’s a bit of a loaded question, as clearly the join you’re using is important for us to see. Especially as you’ve tried passing a Query where an array is needed. So it’s not giving an error, you’ve used it incorrectly. |
| # |
Mar 14th 2018, 11:32 |
narendravaghela |
Can we use subquery in joins? It gives an error `Cannot use object of type Cake\ORM\Query as array ` |
| # |
Mar 14th 2018, 11:25 |
neon1024 |
Hm, sounds good! Thanks for the info, I’ll have a try |
| # |
Mar 14th 2018, 11:24 |
dereuromark |
doesnt miss anything and doesnt seem to have parse issues like regex solutions do |
| # |
Mar 14th 2018, 11:23 |
dereuromark |
but I tested it and even though its slow it works good. |
| # |
Mar 14th 2018, 11:23 |
dereuromark |
in that case maybe its own yaml would make sense. |
| # |
Mar 14th 2018, 11:23 |
dereuromark |
especially since you are only interested in <=3.5 stuff |
| # |
Mar 14th 2018, 11:23 |
dereuromark |
might be missing a few things, but based on migration guide you could add them |
| # |
Mar 14th 2018, 11:23 |
dereuromark |
just run it as documented :slightly_smiling_face: |
| # |
Mar 14th 2018, 11:22 |
neon1024 |
Actually, I’ll make a cup of tea and go through it properly rather than being lazy ;) |
| # |
Mar 14th 2018, 11:22 |
dereuromark |
no |
| # |
Mar 14th 2018, 11:22 |
neon1024 |
At a quick glance, I have to create a yaml config for all the changes between my version and the target? |
| # |
Mar 14th 2018, 11:20 |
dereuromark |
this tool or my upgrade tool (a bit outdated) should do the trick |
| # |
Mar 14th 2018, 11:20 |
dereuromark |
bottom line: https://www.reddit.com/r/PHP/comments/82ddpt/the_cakephp_core_team_is_excited_to_announce_the/dvaa8kv/ |
| # |
Mar 14th 2018, 11:19 |
neon1024 |
Before 17:00 GMT? ;) |
| # |
Mar 14th 2018, 11:19 |
dereuromark |
I am posting a blog post later today :slightly_smiling_face: |
| # |
Mar 14th 2018, 11:18 |
neon1024 |
I am upgrading a plugin to Cake 3.5. Anyone have any tips on how to find and fix all the deprecations? I have run the deprecated code inspection in PHP Storm and fixed a few, but I’m not convinced it’s found them all. |
| # |
Mar 14th 2018, 10:53 |
turkles |
meh, then I find it :) |
| # |
Mar 14th 2018, 10:53 |
turkles |
argggg.. can someone remind me where the site title is set.. |
| # |
Mar 14th 2018, 10:50 |
neon1024 |
Check the test suite, perhaps there is a test which uses Postgres |
| # |
Mar 14th 2018, 10:49 |
neon1024 |
Not sure my boss would be happy with me spending time installing Postgres |
| # |
Mar 14th 2018, 10:32 |
jimesh.gajera |
Even you can check it by installing Postgres into your machine |
| # |
Mar 14th 2018, 10:31 |
jimesh.gajera |
with connection manager it is working properly |
| # |
Mar 14th 2018, 10:31 |
neon1024 |
It would need someone who knows postgres to check :slightly_smiling_face: |
| # |
Mar 14th 2018, 10:31 |
neon1024 |
Really? Sounds like a potential bug |
| # |
Mar 14th 2018, 10:31 |
jimesh.gajera |
But with postgresql ORM is not working |
| # |
Mar 14th 2018, 10:30 |
neon1024 |
You will not be able to write sql with a connection |
| # |
Mar 14th 2018, 10:30 |
neon1024 |
That’s the ORM’s job |
| # |
Mar 14th 2018, 10:30 |
neon1024 |
It won’t |
| # |
Mar 14th 2018, 10:30 |
neon1024 |
Why would the connection know about sql? |