[Dbix-class] Logging all SQL calls

2019-03-27 Thread Jesse Sheidlower
I think I asked about this a while ago on IRC, but I lost track of the discussion 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 ca

Re: [Dbix-class] Logging all SQL calls

2019-03-27 Thread Tom Bloor
Hi Jesse, Ive used DBIx::Class::AuditAny successfully for data level auditing, with an added user column for tracking who did what. Ive popped it in a gist here: https://gist.github.com/TBSliver/caaf87d7165c53e2e55cdffb47c2fefc If you want something other than data level auditing then I dont kno

Re: [Dbix-class] Logging all SQL calls

2019-03-27 Thread David Cantrell
On Wed, Mar 27, 2019 at 09:54:59AM -0400, Jesse Sheidlower wrote: > 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 > eve