| # |
Oct 4th 2016, 06:08 |
 ra7bi |
i want to know how many records returning from the query |
| # |
Oct 4th 2016, 06:08 |
ra7bi |
why i cant use count method with $query->get |
| # |
Oct 4th 2016, 06:08 |
ra7bi |
hi |
| # |
Oct 4th 2016, 04:07 |
ndm |
http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#countercache-cache-your-count |
| # |
Oct 4th 2016, 04:07 |
ndm |
However you could write that query using joins too... or use a counter cache |
| # |
Oct 4th 2016, 04:06 |
ndm |
@justrohu Then you're going to have a bad time in case `fields` doesn't accept (subquery) expressions (haven't used 2.x for quite some now, not sure if it works): http://book.cakephp.org/2.0/en/models/retrieving-your-data.html#sub-queries |
| # |
Oct 4th 2016, 04:03 |
justrohu |
@ndm: what if I want to run subquery like select user.id, (select count(*) from cars where cars.user_id = users.id) as car_count from users |
| # |
Oct 4th 2016, 04:00 |
justrohu |
@ndm: Thank you |
| # |
Oct 4th 2016, 03:59 |
slackebot1 |
association conditions in case you've defined some in your association setup. |
| # |
Oct 4th 2016, 03:59 |
ndm |
@justrohu You must for `hasMany` and `hasAndBelongsToMany` associations, as they are being retrieved in a separate query if you include them via `contain` or an according `recursive` level. For `belongsTo` and `hasOne` it should be possible to just include the associations via `contain` or `recursive` as they are being retrieved in the main query (they may not use the `INNER` join type though). Also don't forget that you may have to include poss |
| # |
Oct 4th 2016, 03:50 |
justrohu |
@ndm : thank you, please correct me if I am wrong here, "For data with conditions on associated hasMany table I must / always have to use join" |
| # |
Oct 4th 2016, 03:47 |
savant |
@backstageel any reason why you requested the github integration? |
| # |
Oct 4th 2016, 03:46 |
slackebot1 |
<http://book.cakephp.org/2.0/en/models/retrieving-your-data.html#complex-find-conditions |
| # |
Oct 4th 2016, 03:46 |
ndm |
@justrohu You can't refer to something that doesn't exist in your query, you need to join the car table in. http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#joining-tables> Use an `INNER` join, and in case a user can have multiple cars of the same name, don't forget to group by the users primary key (or do a distint select on it) in order to avoid getting duplicate results. |
| # |
Oct 4th 2016, 03:38 |
justrohu |
any body please help me |
| # |
Oct 4th 2016, 03:35 |
justrohu |
Hello all, I have users hasmany association with cars table... now I want to get all the user who have Ferrari Elemento ... How do I write query for this .. I did try doing $this->User->find('all',['conditions'=>['Car.name' => 'Ferrari Elemento' ]]); but this is giving me invalid Car.name column database error |
| # |
Oct 4th 2016, 03:30 |
cjohnson |
Is there a way to call callbacks for the Expandable behavior without calling the callbacks for the model itself? specifically when saving |
| # |
Oct 4th 2016, 02:11 |
froodley |
there's only one entry in the routing, Router::connect('/', array('controller' => 'users', 'action' => 'login')); |
| # |
Oct 4th 2016, 02:11 |
froodley |
this is cake 2 |
| # |
Oct 4th 2016, 02:10 |
froodley |
like if I go <domain>/asdf, I get AsdfController could not be found. |
| # |
Oct 4th 2016, 02:10 |
froodley |
instead of throwing 404s, one of my apps is throwing 500s when it can't find a controller |
| # |
Oct 4th 2016, 02:10 |
froodley |
Hello... having a strange problem... |
| # |
Oct 4th 2016, 01:49 |
waspinator |
and seemingly only in the shell. I'm probably doing something different than when I'm calling it from a controller |
| # |
Oct 4th 2016, 01:48 |
waspinator |
it's just a really strange bug, that it works as long as you do it every 1-2 minutes. any faster and it fails |
| # |
Oct 4th 2016, 01:48 |
waspinator |
yeah that makes sense. I'll look into it and maybe try other html to pdf options that cakepdf supports. |
| # |
Oct 4th 2016, 01:46 |
ndm |
@waspinator That's a kinda wkhtmltopdf specific problem, you may get better help if you isolate the problem and ask wkhtmltopdf folks for help. Given the stuff you can find around the net, this is likely related to (external) assets in one way or another. https://github.com/wkhtmltopdf/wkhtmltopdf/issues/2051 |
| # |
Oct 4th 2016, 01:35 |
waspinator |
good night |
| # |
Oct 4th 2016, 01:34 |
robodna |
Yes, I'm asking for the purpose of discovering the lowest common denominator for my API code. |
| # |
Oct 4th 2016, 01:34 |
waspinator |
http://discourse.cakephp.org/t/cakepdf-not-working-in-a-shell/1275 |
| # |
Oct 4th 2016, 01:34 |
waspinator |
I'm trying to get cakepdf to work from a shell, but I've come across a strange error. I can get it to run once every few minutes. otherwise it won't work. anyone tried running cakepdf from a shell? |
| # |
Oct 4th 2016, 01:31 |
slackebot1 |
myself ok. |
| # |
Oct 4th 2016, 01:31 |
robodna |
I see many APIs only partially implement REST, typically for crud, and then hobble together RPC calls for loose ends. I realize I'm beating a dead horse but I want to just drop the REST idea if it cannot be fully implemented. It boils down to deciding if I want to use conventional cakephp controller/actions ( RPC ) or creating more cakephp controllers to act as REST resource 'nouns' to do the work actions would normally do. hope i'm ex |
| # |
Oct 4th 2016, 01:24 |
sinusss |
nah it's okay i'll give this a shot another time thanks |
| # |
Oct 4th 2016, 01:24 |
robodna |
@savant ha! i see the api is read only... so only GET methods |
| # |
Oct 4th 2016, 01:18 |
sinusss |
@savant mind sharing your php dockerfile? |
| # |
Oct 4th 2016, 01:14 |
robodna |
cool |
| # |
Oct 4th 2016, 01:13 |
robodna |
I've also considered just using GET /user/1/edit and then POST /user/1/edit like the default cakephp routes and use and RPC type API, with verbs in the URL |
| # |
Oct 4th 2016, 01:11 |
robodna |
http://www.tbray.org/ongoing/When/200x/2009/03/20/Rest-Casuistry#c1237592841.237066 |
| # |
Oct 4th 2016, 01:11 |
robodna |
that was a real example, from another example I was reading:) |
| # |
Oct 4th 2016, 01:11 |
robodna |
@savant I'm actually writing a business app... the /vm was just a simple example :slightly_smiling_face: |
| # |
Oct 4th 2016, 01:08 |
robodna |
yep, just needed all the info I can gather to decide which direction to head in, thanks |