http://www.perlmonks.org?node_id=1000181


in reply to How to do automated tests of a database centric CPAN module

Yes, definitely add SQLite to your list of supported databases, and bundle a SQLite database for testing.

And don't just test SQLite if Oracle/PostgreSQL can't be tested. Test it always. Add a test_requires dependency on DBD::SQLite. If I happen to have Oracle and PostgreSQL up and running, and the appropriate environment variables set, then I'd want the test suite to run on all three databases.

perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'

Replies are listed 'Best First'.
Re^2: How to do automated tests of a database centric CPAN module
by jds17 (Pilgrim) on Oct 21, 2012 at 09:42 UTC

    I will definitely write an extension to support SQLite (as already planned) and bundle SQLite for testing, thank you for the reassurance regarding this question, tobyink.

    The tests are run against all supported databases during development, but I guess a user would target one specific DBMS. So, I think looking for environment variables specifying one database connection is enough.

[reply]

In Section Seekers of Perl Wisdom