# |
Apr 13th 2021, 11:23 |
paolo.bragagni |
@kevin.pfeifer have you got some examples of plugin so that I can pick some ideas |
# |
Apr 13th 2021, 11:23 |
kevin.pfeifer |
well in the long term if your app grows and grows I would very much recommend to you to split up your individual parts into custom plugins |
# |
Apr 13th 2021, 11:21 |
paolo.bragagni |
many changes ... :( |
# |
Apr 13th 2021, 11:21 |
paolo.bragagni |
in my old cake 2 I had a folder inside Console/Templates/ |
# |
Apr 13th 2021, 11:21 |
paolo.bragagni |
thanks so the best way is to create a plugin |
# |
Apr 13th 2021, 11:18 |
kevin.pfeifer |
i personally created a separate plugin for that where all my custom generated templates are gathered together |
# |
Apr 13th 2021, 11:18 |
kevin.pfeifer |
https://book.cakephp.org/bake/2/en/development.html#bake-template-syntax |
# |
Apr 13th 2021, 11:18 |
paolo.bragagni |
yep |
# |
Apr 13th 2021, 11:18 |
kevin.pfeifer |
you mean like bake templates? |
# |
Apr 13th 2021, 11:17 |
paolo.bragagni |
I'd like to change the generation |
# |
Apr 13th 2021, 11:17 |
paolo.bragagni |
I'd like to know where these templates are build |
# |
Apr 13th 2021, 11:17 |
paolo.bragagni |
thanks @kevin.pfeifer but these are the templates of the views |
# |
Apr 13th 2021, 11:12 |
kevin.pfeifer |
well the start of the DOM live in `templates/layout/default.php` and the rest lives in the corresponding `templates/<controller>/<method>.php` I would recommend you to use elements as much as possible since they are an easy way to re-use already defined template-parts |
# |
Apr 13th 2021, 11:08 |
paolo.bragagni |
(done years ago for cake 2) |
# |
Apr 13th 2021, 11:08 |
paolo.bragagni |
:) |
# |
Apr 13th 2021, 11:08 |
paolo.bragagni |
hi. trying to find a way to build my own template for cake4, but I dont know even how to start |
# |
Apr 13th 2021, 11:00 |
admad |
And use saveMany() for each batch |
# |
Apr 13th 2021, 10:55 |
neon1024 |
Thanks for the input :thumbsup: |
# |
Apr 13th 2021, 10:55 |
neon1024 |
Well that makes a lot of sense. So I am updating the database, re-creating indexes, closing the connection, and then repeating 80k times! So probably preparing batches in a transaction sounds like a good approach |
# |
Apr 13th 2021, 09:49 |
hmic |
ah, I am probably wrong. every *commited* save will. but I belive cake will commit every save individually be default. |
# |
Apr 13th 2021, 09:48 |
conehead |
Yes and depending on how time critical it is, you might also want to think about using less cake and more plain php/mysql to update that data. But in general I think it is enough to do batch calculations |
# |
Apr 13th 2021, 09:46 |
hmic |
every mysql save will recreate all indices, so that is slow! if you save x records at once, your speedup can be up to x times, depending on how heavy the index work is... it will be sped up by a lot, *if* not all the time is spend in php anyways, yes. but saving multiple records at once is generally a good strategy speedwise. |
# |
Apr 13th 2021, 09:44 |
conehead |
Of course it depends on your calculation. But usually calculations are fast and saving is slow. I would use limit and offset |
# |
Apr 13th 2021, 09:43 |
neon1024 |
@conehead @saeid Wouldn’t even batches still mean processing each record in the batch? I think the time might be in the PHP processing rather than the db, but it is an assumption. I’ll give it a try though to benchmark it. Would you find all records and use `->chunk()` or use `limit` and `offset` in the query? I don’t want to load 80k records into memory ideally |
# |
Apr 13th 2021, 09:20 |
nayakvradhit |
Ok sure thanks |
# |
Apr 13th 2021, 09:13 |
kevin.pfeifer |
if possible just set the docroot to `/www/html/appname/weboot` |
# |
Apr 13th 2021, 09:12 |
nayakvradhit |
Ok thanks |
# |
Apr 13th 2021, 09:11 |
nayakvradhit |
Yes @kevin.pfeifer I have set the document root to var/www/html/appname And calling ipaddress/appname If I set like this does it miss cakephp styles what I gave? |
# |
Apr 13th 2021, 09:03 |
conehead |
@neon1024 Yes, do it in batches. Get 1k rows, calculate the new field, save those 1k rows with one save and grab the next 1k rows and repeat |
# |
Apr 13th 2021, 08:53 |
kevin.pfeifer |
theoretically if your webroot is in the “root” of the cakephp/app folder (and without any special .htaccess/webserver rules) all your src files, config files including database user and password would be accessible via a URL which isn’t that great, right? ;) |
# |
Apr 13th 2021, 08:50 |
nayakvradhit |
Can anyone please tell me why we need to point the cakephp app into webroot in the document root of apache config? |
# |
Apr 13th 2021, 08:41 |
neon1024 |
Does anyone have any suggestions on how I can update 80k rows in my database, I need to transform the data using PHP and save it into a new field. I have written a command which processes each record but working out the timings, the total run would be 37 minutes! |
# |
Apr 13th 2021, 08:22 |
masa19951009 |
ok I'll check again thanks! |
# |
Apr 13th 2021, 08:21 |
kevin.pfeifer |
The https://github.com/cakephp/authentication plugin in the current version (2.6) is cake4 compatible, yes |
# |
Apr 13th 2021, 08:12 |
masa19951009 |
Thank ! Sorry I'm using CakePHP 4 and this way not work :,(. Does it work in cake4? Maybe another problem. |
# |
Apr 13th 2021, 08:10 |
kevin.pfeifer |
i was going to point that out admad :) ylj |
# |
Apr 13th 2021, 08:09 |
admad |
@masa19951009 helps to read the manual :) https://book.cakephp.org/authentication/2/en/identifiers.html#password |
# |
Apr 13th 2021, 08:07 |
masa19951009 |
Excuse me. I have a question. Does anyone know how to create multi column in authentication plugin? Like both name and email can login. |
# |
Apr 13th 2021, 05:40 |
nayakvradhit |
Thanks |
# |
Apr 12th 2021, 20:58 |
greg138 |
That's right. But there's *something* in the session that gets regenerated every page load now... |
# |
Apr 12th 2021, 20:58 |
kevin.pfeifer |
thats why you get a ID to tell PHP which data you already have |