I would like to know for each running model action, how can I retrieve
the SQL running behind? I don’t want to scan log each time for the sql
running behind.
E.g. post.find(:all,:conditions=>{:id=>‘1’}
I wanna debug the sql generated behind, is that other shorthand
function like post.find().show_sql() that enable
us to view what’s SQL generated ?
I would like to know for each running model action, how can I retrieve
the SQL running behind? I don’t want to scan log each time for the sql
running behind.
E.g. post.find(:all,:conditions=>{:id=>‘1’}
I wanna debug the sql generated behind, is that other shorthand
function like post.find().show_sql() that enable
us to view what’s SQL generated ?
That sounds like a good idea. Perhaps a
:log => :instance_variable_name option to find.
One alternative is the query_trace plugin that displays
a backtrace for each query, so that the log shows what
line of code is associated with each query.
That’s sum out my findings. Hope it helps. But, personally speaking,
it will glad to have a shorthand function for developer to dump out
the sql generated on the fly,
as it effectively save time for browsing the log, run the debugger in
console…cheers!
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.