1 package DBIx::Class::Storage::Statistics;
5 use base qw/DBIx::Class::AccessorGroup Class::Data::Accessor/;
6 __PACKAGE__->mk_group_accessors(simple => qw/callback debugfh/);
10 DBIx::Class::Storage::Statistics - SQL Statistics
16 This class is called by DBIx::Class::Storage::DBI as a means of collecting
17 statistics on it's actions. Using this class alone merely prints the SQL
18 executed, the fact that it completes and begin/end notification for
21 To really use this class you should subclass it and create your own method
22 for collecting the statistics as discussed in L<DBIx::Class::Manual::Cookbook>.
30 Returns a new L<DBIx::Class::Storage::Statistics> object.
35 bless $self, (ref($_[0]) || $_[0]);
42 Sets or retrieves the filehandle used for trace/debug output. This should
43 be an IO::Handle compatible object (only the C<print> method is used). Initially
44 should be set to STDERR - although see information on the
45 L<DBIC_TRACE> environment variable.
49 Called when a transaction begins.
55 $self->debugfh->print("BEGIN WORK\n");
60 Called when a transaction is rolled back.
66 $self->debugfh->print("ROLLBACK\n");
71 Called when a transaction is committed.
77 $self->debugfh->print("COMMIT\n");
82 Called before a query is executed. The first argument is the SQL string being
83 executed and subsequent arguments are the parameters used for the query.
87 my ($self, $string, @bind) = @_;
89 my $message = "$string: ".join(', ', @bind)."\n";
91 if(defined($self->callback())) {
93 $self->callback()->($1, $message);
97 $self->debugfh->print($message);
102 Called when a query finishes executing. Has the same arguments as query_start.
107 my $string = shift();
114 Cory G. Watson <gphat@cpan.org>
118 You may distribute this code under the same license as Perl itself.