| # |
Apr 30th 2019, 07:04 |
 conehead |
@nils Not really sure, but shouldnt marks queue plugin what you are looking for? https://github.com/dereuromark/cakephp-queue/tree/2.x |
| # |
Apr 30th 2019, 07:02 |
nils |
Haha, as usual, everyone's asleep when I'm awake. :slightly_smiling_face: |
| # |
Apr 30th 2019, 06:41 |
nils |
I'm on 2.x |
| # |
Apr 30th 2019, 06:39 |
nils |
Do cakephp-people use Gearman for background jobs? Or did you find a more modern way? :slightly_smiling_face: |
| # |
Apr 30th 2019, 06:00 |
admad |
it doesn't |
| # |
Apr 30th 2019, 05:58 |
hippo |
I know laravel doe sbut I'm pretty sure cake doesn't out of the box |
| # |
Apr 30th 2019, 05:58 |
hippo |
does cake cache Config::read() or .env values? |
| # |
Apr 30th 2019, 05:51 |
ra7bi |
Thanks a lot @admad |
| # |
Apr 30th 2019, 05:40 |
admad |
`['OR' => [[xxx => 1, ffff => 2], [ddd => 1, cccc = 1]]]` |
| # |
Apr 30th 2019, 05:39 |
ra7bi |
i want either ` xxxx=1 and ffff=2` or ` dddd=1 and ccccc=1` |
| # |
Apr 30th 2019, 05:38 |
ra7bi |
two days working on this query and not able to understand how to get it works |
| # |
Apr 30th 2019, 05:38 |
ra7bi |
i want to say is ` select * from users where id=12 and ( (xxxx=1 and ffff = 2) or (dddd=1 and ccccc=1) ); ` |
| # |
Apr 30th 2019, 05:37 |
voycey |
Are there any clean patterns to writing these queries with aggregates> |
| # |
Apr 30th 2019, 05:36 |
ra7bi |
How i can use contain in `exists()` |
| # |
Apr 30th 2019, 05:36 |
voycey |
ok well good to know we arent rewriting everything for nought :slightly_smiling_face: |
| # |
Apr 30th 2019, 05:35 |
voycey |
right |
| # |
Apr 30th 2019, 05:35 |
admad |
it relates to autoselecting fK fields for associations |
| # |
Apr 30th 2019, 05:35 |
voycey |
(as that is all it is whinging about I think) |
| # |
Apr 30th 2019, 05:35 |
admad |
nothign to do with your problem |
| # |
Apr 30th 2019, 05:35 |
voycey |
Would this just add the appropriate selects in this case? |
| # |
Apr 30th 2019, 05:35 |
voycey |
what is enableAutoFields()? |
| # |
Apr 30th 2019, 05:35 |
admad |
right |
| # |
Apr 30th 2019, 05:34 |
voycey |
I think we had strict mode off.... |
| # |
Apr 30th 2019, 05:34 |
admad |
@voycey there's no ORM magic here, you need to modify the query to make postgres happy, pretty sure you would have got error with this using mysql 5.7+ too |
| # |
Apr 30th 2019, 03:40 |
voycey |
Is there a setting switch anywhere to support this without re-writing them all? |
| # |
Apr 30th 2019, 03:40 |
voycey |
```$Impressions = TableRegistry::get('Impressions'); $dc = $Impressions ->find() ->group( [ 'Impressions.device_id' ] ) ->where([ 'Impressions.beacon_id' => $id, 'Impressions.timestamp >=' => $periodStart, 'Impressions.timestamp <=' => $periodEnd ])->count();``` |
| # |
Apr 30th 2019, 03:40 |
voycey |
our query is something like: |
| # |
Apr 30th 2019, 03:40 |
voycey |
We understand why this is happening but it was my understanding that the ORM abstracted a lot of this away between MySQL and Postgres |
| # |
Apr 30th 2019, 03:39 |
voycey |
Hey folks, we are migrating from MySQL to Postgres and we are seeing a few errors popping up, namely this one: `Grouping error: 7 ERROR: column "impressions.id" must appear in the GROUP BY clause or be used in an aggregate function` |
| # |
Apr 29th 2019, 22:42 |
alysson-azevedo |
(i'm not using the default hasMany because i need another table to make the join works, and the hasMany association doesn't have the `through` option) |
| # |
Apr 29th 2019, 22:35 |
slackebot |
laboratories and and each entity have one medicine. Is it possible to tell the join to create an "hasMany" relation? |
| # |
Apr 29th 2019, 22:35 |
alysson-azevedo |
Hi. I have a model called LaboratoriesTable, and for i need return the list of medicines that each laboratory makes. ``` $query->select(['medicines.id', 'medicines.ean', 'medicines.cap']) ->join([ 'medicines' => [ 'table' => 'medicines', 'type' => 'left', 'conditions' => 'medicines.id = laboratory.id', ], ]); ``` This query almost works, the problem is that it duplicates the |
| # |
Apr 29th 2019, 21:25 |
ricksaccous |
np |
| # |
Apr 29th 2019, 21:24 |
maymeow |
@ricksaccous thank you |
| # |
Apr 29th 2019, 21:22 |
ricksaccous |
@maymeow https://github.com/cakephp/cakephp/blob/master/tests/TestCase/View/Helper/TimeHelperTest.php |
| # |
Apr 29th 2019, 21:14 |
maymeow |
Hi. Please do you have any Helper test example for cakephp 3.7? |
| # |
Apr 29th 2019, 20:58 |
rightscoreanalysis |
restful routing for an add action is POST: /users.json isn't it? |
| # |
Apr 29th 2019, 18:40 |
noel |
@neon1024 and @hollistergraham123 thanks for the offers of help! So far I seem to be managing. My approach is a little different – it’s not using Vue as SPA with CakePHP as API, rather it’s just integrating the Quasar UI framework in such a way as to dress the standard web-app scaffolding created by Bake. So there’s no ajax going on. Don’t know if anyone else would agree that is useful but I’m digging it. |
| # |
Apr 29th 2019, 17:55 |
ricksaccous |
oh ok ;) cool |
| # |
Apr 29th 2019, 17:55 |
itmpls |
n/m, actually default is true to mimic mysql, it was just not setting the right prop :slightly_smiling_face: |
| # |
Apr 29th 2019, 17:54 |
ricksaccous |
@itmpls are you setting it to an empty string or is it actually null? |