Re: using callbacks with connect_cached

On Aug 24, 2013, at 9:40 PM, Vincent Veyron <[email protected]> wrote:

> Not quite : I thought connected_cache.new would enable me to set the
> correct datestyle once for a cached connection, and then be cached with
> it, but we've seen that won't work.
> 
> Using the connected callback would do a 'set datestyle to xyz' for each
> connection, even if cached. I realize it's no big deal (.5ms on my lowly
> Atom processor), but every little bit helps, as I'm sure you know. 
> 
> So I now set the datestyle when the user logs in (hence once, with
> $dbh->do('SET datestyle TO xyz'), and the database handle is cached and
> reused as is.

You can also use a private attribute in connect_cached.new to tell the connected callback to do its thing:


my $cb = {
    'connect_cached.new' => sub {
        $_[4]->{private_is_new} = 1;
        return;
    },
    connected => sub {
        my $dbh = shift;
        warn "connected\n" if delete $dbh->{private_is_new};
        return;
    }
};

for (1..3) {
    DBI->connect_cached('dbi:SQLite:', '', '', {
        PrintError => 0,
        RaiseError => 1,
        AutoCommit => 1,
        Callbacks  => $cb,
    });
}

This emits "connected" only once.

Best,

David