RailsPress 2013-01-30 Update

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.