I attended OpenHack Austin tonight, working on RailsPress.
I decided to cheat by logging SQL statements.
You can turn the logging on and off in the db and check it like this:
SET GLOBAL general_log = 'ON'; SET GLOBAL general_log = 'OFF'; show global variables where variable_name like 'general_log';
It will write the logs to /var/log/mysql/mysql.log
It is a bit cumbersome. So far I am trying one thing at a time. I will turn on the logging, do my action, and turn the log off. I may give up doing it this way.
I was grepping for SQL statements in the code. I used “cat” to put the results into a file. So I suppose I could go back and forth.