| # |
Apr 19th 2019, 10:56 |
 ricksaccous |
I think that you should first set the table to a variable, and isn't TableRegistry the recommended way to do that? |
| # |
Apr 19th 2019, 10:47 |
asdfgh |
anyone? |
| # |
Apr 19th 2019, 10:13 |
asdfgh |
and i have to get the ID of that record that has value "view" |
| # |
Apr 19th 2019, 10:12 |
asdfgh |
basically i have a filed named "activity" in the activity_types table |
| # |
Apr 19th 2019, 10:12 |
asdfgh |
why? |
| # |
Apr 19th 2019, 10:12 |
asdfgh |
i get this error: Using $this when not in object context |
| # |
Apr 19th 2019, 10:12 |
asdfgh |
$activityType = TableLocator::get('ActivityTypes')->findByActivity('view')->first(); |
| # |
Apr 19th 2019, 10:12 |
asdfgh |
hello |
| # |
Apr 19th 2019, 00:27 |
kanryu |
How do I define a Model that does not inherit Table in Cakephp 3 and use it from the Controller? |
| # |
Apr 18th 2019, 21:20 |
leonardo.crecente |
I have a question, it's more about html than cakephp. Hope you can help me. I have a website layout in mobile and desktop versions. The navigation menu layout changes a lot from mobile to desktop. Is there any problem on using a html structure for each navigation? I'd hide via css the mobile nav on desktop and vice versa |
| # |
Apr 18th 2019, 21:04 |
maymeow |
When I use 'plugin.Identity.Users' fixture it ends with error that can't find fixture |
| # |
Apr 18th 2019, 21:03 |
maymeow |
So I have identity plugin installed in vendor |
| # |
Apr 18th 2019, 20:57 |
admad |
you can |
| # |
Apr 18th 2019, 20:34 |
maymeow |
Can I use fixture from vendor plugin or I have to extend it in my tests? |
| # |
Apr 18th 2019, 17:52 |
devito |
in cake 2 is there a databaseengine for caching? |
| # |
Apr 18th 2019, 17:52 |
ricksaccous |
which is lengthy for many records* |
| # |
Apr 18th 2019, 17:52 |
ricksaccous |
which may be lengthy |
| # |
Apr 18th 2019, 17:52 |
ricksaccous |
saveMany will always expect hydrated entities in |
| # |
Apr 18th 2019, 17:51 |
ricksaccous |
raw queries always best option |
| # |
Apr 18th 2019, 17:51 |
pedrorocha |
As curiosity, if I were using the most recent version of cakephp, should I do it with saveMany() or raw queries is still my best option? |
| # |
Apr 18th 2019, 17:48 |
pedrorocha |
Inner loop memory usage run: 1 -> 2.89 MB Inner loop memory usage run: 2 -> 37.19 MB Inner loop memory usage run: 3 -> 37.61 MB Inner loop memory usage run: 4 -> 38.04 MB Total loop memory usage -> 31.85 MB Awesome! Thank you guys |
| # |
Apr 18th 2019, 17:37 |
pedrorocha |
Thank you! |
| # |
Apr 18th 2019, 17:36 |
ricksaccous |
what* |
| # |
Apr 18th 2019, 17:36 |
ricksaccous |
.... |
| # |
Apr 18th 2019, 17:36 |
ricksaccous |
i think that he linked up there is sufficient |
| # |
Apr 18th 2019, 17:35 |
pedrorocha |
Just to be sure $db = ConnectionManager::getDataSource('default'); $db->rawQuery("INSERT ...."); is what I should be using in case of many records? |
| # |
Apr 18th 2019, 17:34 |
ricksaccous |
thanks |
| # |
Apr 18th 2019, 17:33 |
ricksaccous |
interesting, i'll consider this if i run into bottlenecks |
| # |
Apr 18th 2019, 17:33 |
admad |
update or insert depending on what you need |
| # |
Apr 18th 2019, 17:33 |
admad |
use what i linked above |
| # |
Apr 18th 2019, 17:32 |
ricksaccous |
@admad speaking of i have a point where i might be patching in 400 records.... do you recommend saving that instead with raw sql if possible? |
| # |
Apr 18th 2019, 17:31 |
admad |
https://book.cakephp.org/3.0/en/orm/query-builder.html#inserting-data |
| # |
Apr 18th 2019, 17:31 |
ricksaccous |
yeah ;) |
| # |
Apr 18th 2019, 17:31 |
ricksaccous |
using the ORM to just build the raw save query |
| # |
Apr 18th 2019, 17:31 |
pedrorocha |
Unfortunately I'm using cakephp 3.1 and I'm afraid I can upgrade it in production.. Can it be done in cakephp 3.1? |
| # |
Apr 18th 2019, 17:31 |
ricksaccous |
and probably skipping to raw sql saves is faster |
| # |
Apr 18th 2019, 17:30 |
ricksaccous |
i'd just be worried about the patchEntities anyway |
| # |
Apr 18th 2019, 17:30 |
admad |
ORM methods are meant for bulk saves anyway. Use lower level db methods |
| # |
Apr 18th 2019, 17:30 |
ricksaccous |
no you'd have to do a saveMany |
| # |
Apr 18th 2019, 17:30 |
pedrorocha |
->save() accepts my whole array of data? |
| # |
Apr 18th 2019, 17:29 |
ricksaccous |
in one query |