How can I see CakePHP s SQL dump in the controller

Question

Is there a way that one can cause CakePHP to dump its SQL log on demand   I d like to execute code up until a point in my controller and see what SQL has been run

User · Answer

In CakePHP 1 2      db   amp  ConnectionManager  getDataSource  default     db- gt showLog

User · Answer

There are four ways to show queries    This will show the last query executed of user model   debug  this- gt User- gt lastQuery        This will show all executed query of user model    log    this- gt User- gt getDataSource  - gt getLog false  false          debug  log    This will show a log of all queries     db   amp  ConnectionManager  getDataSource  default     db- gt showLog     If you want to show all queries log all over the application you can use in view element filename ctp    lt  php echo  this- gt element  sql dump      gt

User · Answer

for cakephp 2 0 Write this function in AppModel php  function getLastQuery          dbo    this- gt getDatasource         logs    dbo- gt getLog         lastLog   end  logs  log         return  lastLog  query        To use this in Controller Write   echo  this- YourModelName- getLastQuery

User · Answer

It is greatly frustrating that CakePHP does not have a  this- Model- lastQuery     Here are two solutions including a modified version of Handsofaten s   1  Create a Last Query Function  To print the last query run  in your  app model php file add   function lastQuery         dbo    this- gt getDatasource         logs    dbo- gt  queriesLog         return the first element of the last array  i e  the last query      return current end  logs        Then to print output you can run   debug  this- gt lastQuery        in model   OR  debug  this- gt Model- gt lastQuery        in controller   2  Render the SQL View  Not avail within model   To print out all queries run in a given page request  in your controller  or component  etc  run    this- gt render  sql      It will likely throw a missing view error  but this is better than no access to recent queries    As Handsofaten said  there is the  elements sql dump ctp in cake libs view elements   but I was able to do the above without creating the sql ctp view  Can anyone explain that

User · Answer

Try this    log    this- gt Model- gt getDataSource  - gt getLog false  false   debug  log     http   api cakephp org 2 3 class-Model html  getDataSource  You will have to do this for each datasource if you have more than one though

User · Answer

If you re using CakePHP 1 3  you can put this in your views to output the SQL    lt  php echo  this- gt element  sql dump      gt    So you could create a view called  sql   containing only the line above  and then call this in your controller whenever you want to see it    this- gt render  sql       Also remember to set your debug level to at least 2 in app config core php   Source

User · Answer

Plugin DebugKit for cake will do the job as well  https   github com cakephp debug kit

User · Answer

What worked finally for me and also compatible with 2 0 is to add in my layout  or in model    lt  php echo  this- gt element  sql dump     gt    It is also depending on debug variable setted into Config core php

[sql] How can I see CakePHP's SQL dump in the controller?

Examples related to sql

Examples related to cakephp