Re: using callbacks with connect_cached

On Aug 23, 2013, at 12:22 PM, Vincent Veyron <[email protected]> wrote:

> As you can see, no caching happens when any callback is present in the
> connect method (connected, connect_cached.new, or
> connect_cached.reused).

Oh, you know what? I think this is why the example in the docs and my blog post puts the callback into a lexical variable, then just passes that lexical. This is because the params passed to connect_cached(), if they vary at all, create different connections. You call connect_cached() three times, and construct the Callbacks hash reference anew each time. So it is different each time.

Try this:

my $cb = {
    'connect_cached.reused' => sub { print "reused!!!"; return; },
};
for my $test (1..3) {
    my $cached_dbh = MyApp::SQLite->connect_cached(
        "dbi:SQLite:dbname=$dbfile", '', '',
        {
            RaiseError  => 1,
            PrintError  => 0,
            Callbacks => $cb,
        }
    );
    ...
}

Best,

David