Log message #4198943

# At Username Text
# Aug 20th 2019, 12:43 neon1024 I think you set it in app.php using the locale
# Aug 20th 2019, 12:42 martin default timezone of product is Europe/Amsterdam
# Aug 20th 2019, 12:42 martin now I need to do `->i18nFormat('YYYY-MM-dd HH:mm:ss', 'Europe/Amsterdam')`
# Aug 20th 2019, 12:42 martin is it possible to give i18nFormat a default timezone? or do I always need to set the timezone?
# Aug 20th 2019, 12:41 martin old database, not my choice :(
# Aug 20th 2019, 12:38 spriz Why would one not keep things in UTC until it hits the frontend? :(
# Aug 20th 2019, 12:34 martin also fixed in cake 4? :P
# Aug 20th 2019, 12:34 martin When I save an UTC time object to a Europe/Amsterdam database, it saves the utc time instead of adding 2 hours :(
# Aug 20th 2019, 12:25 ndm @khalid Yes, queries (instances of `\Cake\Database\Query` or `\Cake\ORM\Query`) are query builder objects. You can create the former via connection objects (`Connection::newQuery()`), and the latter via table objects `Table::query()`.
# Aug 20th 2019, 12:24 spriz @eax that sounds funky. Is it downright an event listener that listens to events fired in another PHP process?
# Aug 20th 2019, 12:22 khalid I am sorry I just kind of new to cake still..
# Aug 20th 2019, 12:22 khalid @ndm thanks, Query::insert() is Querybuilder right?
# Aug 20th 2019, 12:20 ndm @khalid `Table::saveMany()` is the slowest of them all (there are no `callbacks` and `validate` options btw, that's 2.x options), `Query::insert()` is faster, and then there's one additional way, that is to write plain SQL (make sure that you're using prepared statements if you chose that way!), which would be the fastest way on CakePHP level.
# Aug 20th 2019, 12:04 khalid I am already using savemany with array('callbacks' => false, 'validate' => false)
# Aug 20th 2019, 12:03 khalid there is no faster way
# Aug 20th 2019, 12:03 khalid @ndm thanks for your reply, so if I want to insert like 1million records, then I have no option except save or save many? or I go through QueryBuilder and write insert queries right?
# Aug 20th 2019, 11:12 ndm There is none, the 3.x connection manager stores the instantiated connection objects in a registry object that lives in a protected property for which there is no public accessor available.
# Aug 20th 2019, 11:05 val We have `ConnectionManager::sourceList()` in 2.x. What's its alternative in 3.x?
# Aug 20th 2019, 10:58 ndm No, it's not, there's not even a `DboSource` class in 3.x, that's 2.x stuff. In 3.x you can use the query builder to create insert statements without using the ORM.
# Aug 20th 2019, 10:49 khalid is insertMulti part of cake3.x?
# Aug 20th 2019, 10:46 khalid Thank you for the help.
# Aug 20th 2019, 10:46 khalid I am struggling with initialisation of DBO source.
# Aug 20th 2019, 10:45 khalid hi everyone, how to use DboSource insert multi in a model?
# Aug 20th 2019, 10:41 slackebot Thanks
# Aug 20th 2019, 10:41 haresh Hello Guys I have used Cakephp 3.6 I have one security concern for below point, Please let us know your thought on this. The value of the URL path filename is copied into the response within the query string of a URL. The payload ?jukandgcs=1 was submitted in the URL path filename. This input was echoed as ?jukandgcs=1 within the "action" attribute of a "form" tag. So is it any security risk while submitting this form? You can see screenshot
# Aug 20th 2019, 10:36 slackebot Thanks
# Aug 20th 2019, 10:36 haresh Hello Guys I have used Cakephp 3.6 I have one security concern for below point, Please let us know your thought on this. The value of the URL path filename is copied into the response within the query string of a URL. The payload ?jukandgcs=1 was submitted in the URL path filename. This input was echoed as ?jukandgcs=1 within the "action" attribute of a "form" tag. So is it any security risk while submitting this form? You can see screenshot
# Aug 20th 2019, 10:32 jiri.sejhar cake 3.7 version
# Aug 20th 2019, 10:28 dereuromark you should always mention the cake version
# Aug 20th 2019, 10:25 jiri.sejhar guys nobody answerd me is necesery do this array_merge($this->request->getData(), ['id'=>$item->id]) if i would get form data with id after insert save ?
# Aug 20th 2019, 09:41 eax Hey folks! Cake3 question: I am setting up some Integration Tests, and I need to test a system that has a Shell/Command running in the background as a listener. Is there a way to start that Listener, and then run the rest of my tests? Thanks!
# Aug 20th 2019, 09:37 dereuromark https://github.com/burzum/cakephp-service-layer
# Aug 20th 2019, 09:37 dereuromark service layer :slightly_smiling_face:
# Aug 20th 2019, 09:27 turkles I want to access some user data across controllers and some custom classes, possibly some Commands - where best to put it?
# Aug 20th 2019, 09:26 neon1024 Or does compact take a variable name, I forget
# Aug 20th 2019, 09:26 bernardine.ragas awww yeah, ill try
# Aug 20th 2019, 09:25 neon1024 So you’ll have `compact($subject)` somewhere in the code
# Aug 20th 2019, 09:25 neon1024 Undefined variable is self explanatory
# Aug 20th 2019, 09:25 neon1024 Well compact is a php method used in cake to set variables to the view
# Aug 20th 2019, 09:24 bernardine.ragas how do i fix this :slightly_smiling_face: please help
# Aug 20th 2019, 09:24 neon1024 Audit stash! I might need that one later too. Good reminder