Re: How to do automated tests of a database centric CPAN module

[salva]

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

Test::postgresql can setup a temporary PostgreSQL database for testing.

Unfortunately it is not very well maintained, I have my own patched version on GitHub and, IIRC, there were other forks.

[jds17]

Now that's interesting, I have not looked for temp PostgreSQL database creation since I would not have expected this to exist.

I would like to include tests using Test::postgresql besides the tests against in-memory SQLite (in case no other database has been specified, see my other posts). I hope the non-patched version works for me since my module would obviously need to reference something on CPAN. Thank you for pointing to your patched version on GitHub.

[erix]

I believe Test::Database serves a similar purpose (create/drop temp databases).

[jds17]

If I understood the documentation correctly, only DBMSs available in the current environment can be instantiated by using Test::Database, so it would not help in the current situation, but please correct me if I am wrong.