Re: [PEAR-CVS] svn: /pear/packages/DB_DataObject/trunk/tests/ simple.phpt

[email protected] (Daniel Convissor) Tue, 15 Nov 2011 20:15:00 -0500
Newsgroups php.pear.cvs,php.pear.qa
Message-ID <[email protected]>
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

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409