Commit | Line | Data |
4c248161 |
1 | package DBIx::Class::Storage::Statistics; |
2 | use strict; |
3 | |
4 | use base qw/DBIx::Class::AccessorGroup Class::Data::Accessor/; |
5 | __PACKAGE__->mk_group_accessors(simple => qw/callback debugfh/); |
6 | |
7 | =head1 NAME |
8 | |
9 | DBIx::Class::Storage::Statistics - SQL Statistics |
10 | |
11 | =head1 SYNOPSIS |
12 | |
13 | =head1 DESCRIPTION |
14 | |
15 | This class is called by DBIx::Class::Storage::DBI as a means of collecting |
16 | statistics on it's actions. Using this class alone merely prints the SQL |
17 | executed, the fact that it completes and begin/end notification for |
18 | transactions. |
19 | |
20 | To really use this class you should subclass it and create your own method |
21 | for collecting the statistics as discussed in L<DBIx::Class::Manual::Cookbook>. |
22 | |
23 | =head1 METHODS |
24 | |
25 | =cut |
26 | |
27 | =head2 new |
28 | |
29 | Returns a new L<DBIx::Class::Storage::Statistics> object. |
30 | |
31 | =cut |
32 | sub new { |
33 | my $self = bless({}, ref($_[0]) || $_[0]); |
34 | |
35 | return $self; |
36 | } |
37 | |
38 | =head2 debugfh |
39 | |
40 | Sets or retrieves the filehandle used for trace/debug output. This should |
41 | be an IO::Handle compatible object (only the C<print> method is used). Initially |
42 | should be set to STDERR - although see information on the |
6fe735fa |
43 | L<DBIC_TRACE> environment variable. |
4c248161 |
44 | |
45 | =head2 txn_begin |
46 | |
47 | Called when a transaction begins. |
48 | |
49 | =cut |
50 | sub txn_begin { |
51 | my $self = shift(); |
d2075431 |
52 | |
53 | $self->debugfh->print("BEGIN WORK\n"); |
4c248161 |
54 | } |
55 | |
56 | =head2 txn_rollback |
57 | |
58 | Called when a transaction is rolled back. |
59 | |
60 | =cut |
61 | sub txn_rollback { |
62 | my $self = shift(); |
d2075431 |
63 | |
64 | $self->debugfh->print("ROLLBACK\n"); |
4c248161 |
65 | } |
66 | |
67 | =head2 txn_commit |
68 | |
69 | Called when a transaction is committed. |
70 | |
71 | =cut |
72 | sub txn_commit { |
73 | my $self = shift(); |
d2075431 |
74 | |
75 | $self->debugfh->print("COMMIT\n"); |
4c248161 |
76 | } |
77 | |
78 | =head2 query_start |
79 | |
80 | Called before a query is executed. The first argument is the SQL string being |
81 | executed and subsequent arguments are the parameters used for the query. |
82 | |
83 | =cut |
84 | sub query_start { |
68fcff2f |
85 | my ($self, $string, @bind) = @_; |
86 | |
87 | my $message = "$string: ".join(', ', @bind)."\n"; |
4c248161 |
88 | |
89 | if(defined($self->callback())) { |
90 | $string =~ m/^(\w+)/; |
68fcff2f |
91 | $self->callback()->($1, $message); |
4c248161 |
92 | return; |
93 | } |
94 | |
68fcff2f |
95 | $self->debugfh->print($message); |
4c248161 |
96 | } |
97 | |
98 | =head2 query_end |
99 | |
100 | Called when a query finishes executing. Has the same arguments as query_start. |
101 | |
102 | =cut |
103 | sub query_end { |
104 | my $self = shift(); |
105 | my $string = shift(); |
106 | } |
107 | |
108 | 1; |
109 | |
110 | =head1 AUTHORS |
111 | |
112 | Cory G. Watson <gphat@cpan.org> |
113 | |
114 | =head1 LICENSE |
115 | |
116 | You may distribute this code under the same license as Perl itself. |
117 | |
118 | =cut |