Blame | Letzte Änderung | Log anzeigen | RSS feed
<?php// +----------------------------------------------------------------------+// | PHP Version 4 |// +----------------------------------------------------------------------+// | Copyright (c) 1998-2004 Manuel Lemos, Paul Cooper |// | All rights reserved. |// +----------------------------------------------------------------------+// | MDB is a merge of PEAR DB and Metabases that provides a unified DB |// | API as well as database abstraction for PHP applications. |// | This LICENSE is in the BSD license style. |// | |// | Redistribution and use in source and binary forms, with or without |// | modification, are permitted provided that the following conditions |// | are met: |// | |// | Redistributions of source code must retain the above copyright |// | notice, this list of conditions and the following disclaimer. |// | |// | Redistributions in binary form must reproduce the above copyright |// | notice, this list of conditions and the following disclaimer in the |// | documentation and/or other materials provided with the distribution. |// | |// | Neither the name of Manuel Lemos, Tomas V.V.Cox, Stig. S. Bakken, |// | Lukas Smith nor the names of his contributors may be used to endorse |// | or promote products derived from this software without specific prior|// | written permission. |// | |// | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS |// | "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT |// | LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS |// | FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE |// | REGENTS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, |// | INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, |// | BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS|// | OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED |// | AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT |// | LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY|// | WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE |// | POSSIBILITY OF SUCH DAMAGE. |// +----------------------------------------------------------------------+// | Author: Paul Cooper <pgc@ucecom.com> |// +----------------------------------------------------------------------+//// $Id: MDB_api_testcase.php,v 1.13.4.7 2004/02/23 20:08:02 quipo Exp $class MDB_Api_TestCase extends PHPUnit_TestCase {//contains the dsn of the database we are testingvar $dsn;//contains the options that should be used during testingvar $options;//contains the name of the database we are testingvar $database;//contains the MDB object of the db once we have connectedvar $db;// contains field names from the test tablevar $fields;// contains the types of the fields from the test tablevar $types;function MDB_Api_Test($name) {$this->PHPUnit_TestCase($name);}function setUp() {$this->dsn = $GLOBALS['dsn'];$this->options = $GLOBALS['options'];$this->database = $GLOBALS['database'];$this->db =& MDB::connect($this->dsn, $this->options);if (MDB::isError($this->db)) {$this->assertTrue(false, 'Could not connect to database in setUp - ' .$this->db->getMessage() . ' - ' .$this->db->getUserInfo());exit;}$this->db->setDatabase($this->database);$this->fields = array('user_name','user_password','subscribed','user_id','quota','weight','access_date','access_time','approved');$this->types = array('text','text','boolean','integer','decimal','float','date','time','timestamp');}function tearDown() {unset($this->dsn);if (!MDB::isError($this->db)) {$this->db->disconnect();}unset($this->db);}function methodExists($name) {if (array_key_exists(strtolower($name), array_change_key_case(array_flip(get_class_methods($this->db))))) {return true;}$this->assertTrue(false, 'method '. $name.' not implemented in '.get_class($this->db));return false;}//test stuff in common.phpfunction testConnect() {$db =& MDB::connect($this->dsn, $this->options);if(MDB::isError($db)) {$this->assertTrue(false, 'Connect failed bailing out - ' .$db->getMessage() . ' - ' .$db->getUserInfo());}if (MDB::isError($this->db)) {exit;}}function testGetOption() {if (!$this->methodExists('getOption')) {return;}$option = $this->db->getOption('persistent');$this->assertEquals($option, $this->db->options['persistent']);}function testSetOption() {if (!$this->methodExists('setOption')) {return;}$option = $this->db->getOption('persistent');$this->db->setOption('persistent', !$option);$this->assertEquals(!$option, $this->db->getOption('persistent'));$this->db->setOption('persistent', $option);}/*// incorrectly expects a specific escape characterfunction testGetTextValue() {if (!$this->methodExists('getTextValue')) {return;}$text = "Mr O'Leary";$text = $this->db->getTextValue($text);$this->assertEquals("'Mr O\'Leary'", $text);}*/function testLoadManager() {if (!$this->methodExists('loadManager')) {return;}$this->assertTrue(!MDB::isError($this->db->loadManager('Load Management Class')));}// test of the driver// helper function so that we don't have to write out a query a million timesfunction standardQuery() {$query = 'SELECT * FROM users';// run the query and get a result handlerif (!MDB::isError($this->db)) {return $this->db->query($query);}return false;}function testQuery() {if (!$this->methodExists('query')) {return;}$result = $this->standardQuery();$this->assertTrue(is_resource($result), 'query: $result returned is not a resource');}function testFetchInto() {if (!$this->methodExists('fetch')) {return;}$result = $this->standardQuery();$err = $this->db->fetchInto($result);if(MDB::isError($err)) {$this->assertTrue(false, 'Error testFetch: '.$err->getMessage().' - '.$err->getUserInfo());}$this->assertNull($err);}function testNumCols() {if (!$this->methodExists('numCols')) {return;}$result = $this->standardQuery();$this->assertTrue((!MDB::isError($this->db->numCols($result))) && ($this->db->numCols($result) > 0));}function testSingleton() {$mdb =& MDB::singleton();$this->assertTrue(MDB::isConnection($mdb));// should have a different database name set$mdb =& MDB::singleton($this->dsn, $this->options);$this->assertTrue($mdb->database != $this->db->database);}}?>