On Thu, May 06, 2004 at 11:53:42PM +0100, Tim Bunce wrote:
On Thu, May 06, 2004 at 01:45:31PM -0700, Jeff Zucker wrote:
Authors of DBI related modules might want to take a look at the discussion at
http://www.perlmonks.org/index.pl?node_id=350861
It is written by one of the CPAN testers and is about the degree of invasiveness of DBD module tests.
Actually it's not.
It's about the invasiveness of *other modules* that happen to use the DBI.
"Testing the database is a job for DBI and the DBD drivers, which they all do very well. So why test it all over again, at the risk of doing damage to your reputation as a good and conscientious CPAN author? There are some distributions that even test several drivers!"
Uh, I forgot to add that it does serve as a reminder to driver authors to take great care in how they create tables for testing and ensure cleanup.
FWIW: DBD::Informix allows the user to configure which database to connect to during testing (actually, it allows you to configure two databases to test concurrent connections to different databases).
It also documents that all the tables and other objects that it creates have names starting with 'dbd_ix_'. Finally, the last 'test', t/t99clean.t, is a moderately effective tool that solely goes through the system catalogs, finding stray entries from any tests that failed to clean up behind themselves.
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) #include <disclaimer.h>
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
