Off the top of my head, I would say this would be trivial to do. But you may not write your code the way I write mine ;-).

package My::App;
use base 'CGI::Application';
use DBI;
#...

sub _connect
{
  my $self = shift;
  my $dbh = $self->param('dbh');
  return $dbh if $dbh;

  my $dsn = $self->param('dsn');
  # user, password...
  $dbh = DBI->connect($dsn, ...);
  $self->param('dbh' => $dbh);
  $dbh;
}

sub _prepare
{
  my $self = shift;
  my $dbh  = $self->_connect();
  $dbh->prepare(@_);
}

sub _execute
{
  my $self = shift;
  my $sth  = shift;
  $self->{_execute}++; # here it is...
  $sth->execute(@_);
}

[download]

I route all my DBI calls through functions like these simply to save time and effort later when (not if) I want to do something wierd. For example, passing in specific parameters to the prepare, or, in your case, counting the executions. You can even put some calls to Time::HiRes around that execute and total up the time for the queries that way.

I also like delaying my connections until I really need them. That way, if a given mode doesn't need to touch the database, then I don't waste time, cycles, or whatever, in creating that connection. Not only am I lazy, but so are my programs ;-)

In reply to Re: DBI query count? by Tanktalus
in thread DBI query count? by skx

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.