| # |
Apr 30th 2019, 10:18 |
 neon1024 |
Should be in the Application.php |
| # |
Apr 30th 2019, 10:15 |
charolastra |
hi, working on upgrading an app from 3.4 to 3.7 but get warnings with "RoutingMiddleware should be passed an application instance." where is the RoutingMiddleware instantised? |
| # |
Apr 30th 2019, 09:47 |
neon1024 |
Morning all :wave: |
| # |
Apr 30th 2019, 08:58 |
nils |
I'm looking to use Gearman more effectively. Right now I can't use any of the native cakephp functions. Or at least, I don't know how. Anyone with experience from this? |
| # |
Apr 30th 2019, 07:07 |
nils |
Oh, I thought that was just a plugin to use Gearman more effectively. My bad. :slightly_smiling_face: |
| # |
Apr 30th 2019, 07:06 |
conehead |
But it says ```Overall functionality is inspired by systems like Gearman, Beanstalk or dropr, but without any illusion to compete with these more advanced Systems.``` |
| # |
Apr 30th 2019, 07:06 |
conehead |
Well you were asking for a more modern way ;) |
| # |
Apr 30th 2019, 07:05 |
nils |
@conehead I haven't used a plugin, simply using it "natively" - it works quite alright. |
| # |
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 |