Log message #4261215

# At Username Text
# Apr 13th 2021, 11:23 paolo.bragagni I'd like to create a template for all my future apps
# Apr 13th 2021, 11:23 kevin.pfeifer i personally hate it when i have like 50 folders in my templates directory
# 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