I think I asked about this a while ago on IRC, but I lost track of the 

I have a large Catalyst app that uses DBIx::Class. We've had a few issues where 
we need to see an audit log. In some cases we can re-run an action on a staging 
server with DBIC_TRACE enabled, but in other cases we really need to see what 
happened on the production machine.

Is there an easy way to log either all the database-changing statements, or all 
SQL period? Obviously the latter would be huge, but might be worth it.

I've seen DBIx::Class::AuditLog, which requires that relevant statements be 
wrapped in a transaction, and DBIx::Class::QueryLog, which seems to be intended 
for debugging purposes only. I need something that just takes everything and 
logs it to a text file, without having to rewrite the entire codebase. How do I 
accomplish this?

List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Reply via email to