pear/jenkins-configuration — Issue #7: Set up a number of test DBs for DB_* and MDB2_*
Author: CloCkWeRX
Created: 2011-11-27 02:49:57+00:00
State: open

"Hi Daniel:

On Wed, Nov 16, 2011 at 08:34:04AM +1030, Daniel O'Connor wrote:
> http://test.pear.php.net:8080/job/DB_DataObject/4/console
>
> This and a few others obviously need a database to be tested properly.
> Certainly that machine has mysql on it; or sqlite is probably available -
> what would be needed to load up an appropriate schema/tear it down after
> the tests?

I agree and mentioned this on pear-qa a while ago. Take a look at what
I committed to DB tests yesterday. It takes advantage of the
MYSQL_TEST_* environment variables, which are used for PHP's tests. We
should create a test user and database and set those environment
variables in the cron job, or whatever.

A similar setup should be made for PostgreSQL in PEAR and PHP's unit
tests. Right now, PHP's tests don't use such environment variables.

SQLite3 tests should use ":memory:" as the database.

Thanks,

--Dan"

...we should (1) do this (2) tweak all DB/MDB2 packages to be configurable/testable in the same way (3) Test with multiple DBs.