On Oct 14, 2009, at 11:39 PM, Darren Duncan wrote:
Also be sure to look at the section http://sqlite.org/foreignkeys.html#fk_enable
, because you have to enable a pragma on each connect to use the
foreign keys feature; it isn't yet on by default for backwards
compatibility purposes.
I suggest you add something to the documentation showing how to always
enable this using a callback. Something like
my $enable_fks = sub { shift->do('PRAGMA foreign_keys = ON') };
my $dbh = DBI->connect($dsn, '', '', {
Callbacks => { connect => $enable_fks, },
});
If the user uses connect_cached, she should use this instead:
Callbacks => { 'connect_cached.reused' => $enable_fks, },
Best,
David
