Log message #4116503

# At Username Text
# Feb 12th 2018, 08:45 M41DZ3N Hello!
# Feb 12th 2018, 08:32 saeideng or if not works pass `1=1` condition to deleteAll()
# Feb 12th 2018, 08:31 saeideng try `$this->TableNames->deleteAll()`
# Feb 12th 2018, 08:30 saeideng $this->deleteAll()?
# Feb 12th 2018, 08:29 javier_rodri1989 do not working
# Feb 12th 2018, 08:26 neon1024 Morning
# Feb 12th 2018, 08:16 saeideng `$this->deleteAll()` is returns `DELETE FROM table_name`
# Feb 12th 2018, 08:12 saeideng there is not function to generate `TRUNCATE TABLE tableName` directly to use like `$this->truncate()` ....
# Feb 12th 2018, 08:10 javier_rodri1989 I said $this->deleteAll()
# Feb 12th 2018, 08:09 javier_rodri1989 but I want insert in the controller
# Feb 12th 2018, 08:08 saeideng there is not direct function
# Feb 12th 2018, 08:07 saeideng ``` public function truncate(ConnectionInterface $db) { $sql = $this->_schema->truncateSql($db); foreach ($sql as $stmt) { $db->execute($stmt)->closeCursor(); } return true; } ```
# Feb 12th 2018, 07:54 javier_rodri1989 Good morning, how to do a truncate of a table in cakephp3?
# Feb 12th 2018, 07:42 savant night all.
# Feb 12th 2018, 07:41 savant AWS is a little futzy if you’re not super familiar with it
# Feb 12th 2018, 07:41 savant no problem
# Feb 12th 2018, 07:24 chris802 @savant Nope. But I just did and that worked. Thanks a million! This is my first time using Amazon.
# Feb 12th 2018, 07:14 savant @chris802 did you open the security groups on your RDS instance to allow access from wherever you are connecting?
# Feb 12th 2018, 06:20 Junior yello ;)
# Feb 12th 2018, 04:28 chris802 Could someone give me any tips on connecting to an Amazon RDS MySQL database in CakePHP 3? I've added all of my Amazon credentials and nothing happens, it just times out when I reload the page. Any help / tips would be appreciated!
# Feb 12th 2018, 03:11 ricksaccous @yogimishra96 yeah you would have to deal with a third party library
# Feb 12th 2018, 02:48 john From a quick search, Mongo doesn't appear to be officially supported. There's an library at https://github.com/tiaguinho/mongodb-cakephp3 that looks to be actively maintained.
# Feb 12th 2018, 02:40 yogimishra96 The official or standard way to integrate the mongo with cakephp
# Feb 12th 2018, 02:40 yogimishra96 How to use mongo php library in cakephp 3.
# Feb 12th 2018, 02:38 loginews File uploaded https://cakesf.slack.com/files/U435V89H8/F97B5SECT/-.txt / https://slack-files.com/T053DPNCM-F97B5SECT-5f71d5507f - It seems to work
# Feb 12th 2018, 02:35 loginews thanks
# Feb 12th 2018, 02:35 loginews I found it
# Feb 12th 2018, 02:35 john https://stackoverflow.com/questions/30876688/cakephp-3-change-order-in-datewidget#30877084
# Feb 12th 2018, 02:18 loginews I feel like I will have to write the docs myself!
# Feb 12th 2018, 02:16 loginews what should I type?
# Feb 12th 2018, 02:16 loginews so instead of typing $this->Form->input('thisdate',['type'=>'date','dateFormat'=>'DMY'])
# Feb 12th 2018, 02:15 john ``` * To control the order of inputs, and any elements/content between the inputs you * can override the `dateWidget` template. By default the `dateWidget` template is: * `{{month}}{{day}}{{year}}{{hour}}{{minute}}{{second}}{{meridian}}` ```
# Feb 12th 2018, 02:15 loginews thanks
# Feb 12th 2018, 02:13 john Oh, nevermind, Timeformat isn't what you're looking for.
# Feb 12th 2018, 02:12 john or format?
# Feb 12th 2018, 02:12 john Looking at the source ( https://github.com/cakephp/cakephp/blob/master/src/View/Helper/FormHelper.php ), have you tried using timeFormat instead of dateFormat?
# Feb 12th 2018, 02:09 john Admittedly, I've used primary CakePHP 2.x
# Feb 12th 2018, 02:03 loginews @john Have you used date input in cakephp3
# Feb 12th 2018, 01:31 loginews thanks. Still searching for the replacement syntax.
# Feb 12th 2018, 01:06 dereuromark loginews: https://book.cakephp.org/3.0/en/appendices/3-0-migration-guide.html#formhelper
# Feb 12th 2018, 01:05 loginews $this->Form->input('thisdate',['type'=>'date','dateFormat'=>'DMY']) The above input still displays the field in YMD format. What did I miss ?