Viewing file:  MDB2_bugs_testcase.php (12.38 KB) -rw-rw-rw-
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
// +----------------------------------------------------------------------+
// | PHP versions 4 and 5 |
// +----------------------------------------------------------------------+
// | Copyright (c) 1998-2006 Manuel Lemos, Paul Cooper |
// | All rights reserved. |
// +----------------------------------------------------------------------+
// | MDB2 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: MDB2_bugs_testcase.php,v 1.31 2006/12/09 16:58:16 quipo Exp $
require_once 'MDB2_testcase.php';
class MDB2_Bugs_TestCase extends MDB2_TestCase {
/**
*
*/
function testFetchModeBug() {
$data = array();
$stmt = $this->db->prepare('INSERT INTO users (' . implode(', ', array_keys($this->fields)) . ') VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array_values($this->fields), MDB2_PREPARE_MANIP);
$data['user_name'] = 'user_=';
$data['user_password'] = 'somepass';
$data['subscribed'] = true;
$data['user_id'] = 0;
$data['quota'] = sprintf("%.2f", strval(2/100));
$data['weight'] = sqrt(0);
$data['access_date'] = MDB2_Date::mdbToday();
$data['access_time'] = MDB2_Date::mdbTime();
$data['approved'] = MDB2_Date::mdbNow();
$result = $stmt->execute(array_values($data));
if (PEAR::isError($result)) {
$this->assertTrue(false, 'Error executing prepared query '.$result->getMessage());
}
$stmt->free();
$query = 'SELECT ' . implode(', ', array_keys($this->fields)) . ' FROM users ORDER BY user_name';
$result =& $this->db->query($query);
if (PEAR::isError($result)) {
$this->assertTrue(false, 'Error selecting from users: '.$result->getMessage());
}
$this->db->setFetchMode(MDB2_FETCHMODE_ASSOC);
$firstRow = $result->fetchRow();
$this->assertEquals($firstRow['user_name'], $data['user_name'], 'The data returned does not match that expected');
$result =& $this->db->query('SELECT user_name, user_id, quota FROM users ORDER BY user_name');
if (PEAR::isError($result)) {
$this->assertTrue(false, 'Error selecting from users: '.$result->getMessage());
}
$this->db->setFetchMode(MDB2_FETCHMODE_ORDERED);
$value = $result->fetchOne();
$this->assertEquals($data['user_name'], $value, 'The data returned does not match that expected');
$result->free();
}
/**
* @see http://bugs.php.net/bug.php?id=22328
*/
function testBug22328() {
$result =& $this->db->query('SELECT * FROM users');
$this->db->pushErrorHandling(PEAR_ERROR_RETURN);
$result2 = $this->db->query('SELECT * FROM foo');
$data = $result->fetchRow();
$this->db->popErrorHandling();
$this->assertFalse(PEAR::isError($data), 'Error messages for a query affect result reading of other queries');
}
/**
* @see http://pear.php.net/bugs/bug.php?id=670
*/
function testBug670() {
$data['user_name'] = null;
$data['user_password'] = 'somepass';
$data['subscribed'] = true;
$data['user_id'] = 1;
$data['quota'] = sprintf("%.2f",strval(3/100));
$data['weight'] = sqrt(1);
$data['access_date'] = MDB2_Date::mdbToday();
$data['access_time'] = MDB2_Date::mdbTime();
$data['approved'] = MDB2_Date::mdbNow();
$stmt = $this->db->prepare('INSERT INTO users (' . implode(', ', array_keys($this->fields)) . ') VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array_values($this->fields), MDB2_PREPARE_MANIP);
$result = $stmt->execute(array_values($data));
$result =& $this->db->query('SELECT user_name FROM users');
$col = $result->fetchCol('user_name');
if (PEAR::isError($col)) {
$this->assertTrue(false, 'Error when fetching column first first row as NULL: '.$col->getMessage());
}
$data['user_name'] = "user_1";
$data['user_id'] = 2;
$result = $stmt->execute(array_values($data));
$result =& $this->db->query('SELECT user_name FROM users');
$col = $result->fetchCol('user_name');
if (PEAR::isError($col)) {
$this->assertTrue(false, 'Error when fetching column: '.$col->getMessage());
}
$data['user_name'] = null;
$stmt->free();
}
/**
* @see http://pear.php.net/bugs/bug.php?id=681
*/
function testBug681() {
$result =& $this->db->query('SELECT * FROM users WHERE 1=0');
$numrows = $result->numRows();
$this->assertEquals(0, $numrows, 'Numrows is not returning 0 for empty result sets');
$data = $this->getSampleData(1);
$stmt = $this->db->prepare('INSERT INTO users (' . implode(', ', array_keys($this->fields)) . ') VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array_values($this->fields), MDB2_PREPARE_MANIP);
$result = $stmt->execute(array_values($data));
$result =& $this->db->query('SELECT * FROM users');
$numrows = $result->numRows();
$this->assertEquals(1, $numrows, 'Numrows is not returning proper value');
$stmt->free();
}
/**
* @see http://pear.php.net/bugs/bug.php?id=718
*/
function testBug718() {
$data = $this->getSampleData(1);
$stmt = $this->db->prepare('INSERT INTO users (' . implode(', ', array_keys($this->fields)) . ') VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array_values($this->fields), MDB2_PREPARE_MANIP);
$result = $stmt->execute(array_values($data));
$row = $this->db->queryRow('SELECT a.user_id, b.user_id FROM users a, users b where a.user_id = b.user_id', array('integer', 'integer'), MDB2_FETCHMODE_ORDERED);
$this->assertEquals(2, count($row), "Columns with the same name get overwritten in ordered mode");
$stmt->free();
}
/**
* @see http://pear.php.net/bugs/bug.php?id=946
*/
function testBug946() {
$data = array();
$total_rows = 5;
$stmt = $this->db->prepare('INSERT INTO users (' . implode(', ', array_keys($this->fields)) . ') VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array_values($this->fields), MDB2_PREPARE_MANIP);
for ($row = 0; $row < $total_rows; $row++) {
$data[$row] = $this->getSampleData($row);
$result = $stmt->execute(array_values($data[$row]));
if (PEAR::isError($result)) {
$this->assertTrue(false, 'Error executing prepared query: '.$result->getMessage());
}
}
$stmt->free();
$query = 'SELECT ' . implode(', ', array_keys($this->fields)) . ' FROM users';
$this->db->setLimit(3, 1);
$result =& $this->db->query($query);
$numrows = $result->numRows();
while ($row = $result->fetchRow()) {
if (PEAR::isError($row)) {
$this->assertTrue(false, 'Error fetching a row: '.$row->getMessage());
}
}
$result->free();
$result =& $this->db->query($query);
$numrows = $result->numRows();
while ($row = $result->fetchRow()) {
if (PEAR::isError($row)) {
$this->assertTrue(false, 'Error fetching a row: '.$row->getMessage());
}
}
$result->free();
}
/**
* @see http://pear.php.net/bugs/bug.php?id=3146
*/
function testBug3146() {
$data = array();
$total_rows = 5;
$query = 'INSERT INTO users (' . implode(', ', array_keys($this->fields)) . ') VALUES ('.implode(', ', array_fill(0, count($this->fields), '?')).')';
$stmt = $this->db->prepare($query, array_values($this->fields), MDB2_PREPARE_MANIP);
for ($row = 0; $row < $total_rows; $row++) {
$data[$row] = $this->getSampleData($row);
$result = $stmt->execute(array_values($data[$row]));
if (PEAR::isError($result)) {
$this->assertTrue(false, 'Error executing prepared query: '.$result->getMessage());
}
}
$stmt->free();
$query = 'SELECT ' . implode(', ', array_keys($this->fields)) . ' FROM users ORDER BY user_id';
$result =& $this->db->query($query, $this->fields);
$numrows = $result->numRows($result);
$this->verifyFetchedValues($result, 0, $data[0]);
$this->verifyFetchedValues($result, 2, $data[2]);
$this->verifyFetchedValues($result, null, $data[3]);
$this->verifyFetchedValues($result, 1, $data[1]);
$result->free();
}
/**
* Strong typing query result misbehaves when $n_columns > $n_types
* @see http://pear.php.net/bugs/bug.php?id=9502
*/
function testBug9502() {
$row = 5;
$data = $this->getSampleData($row);
$stmt = $this->db->prepare('INSERT INTO users (' . implode(', ', array_keys($this->fields)) . ') VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array_values($this->fields), MDB2_PREPARE_MANIP);
$result = $stmt->execute(array_values($data));
$stmt->free();
//provide an incomplete and scrambled types array
$types = array();
$types['subscribed'] = $this->fields['subscribed'];
$types['user_name'] = $this->fields['user_name'];
$types['weight'] = $this->fields['weight'];
$query = 'SELECT weight, user_name, user_id, quota, subscribed FROM users WHERE user_id = '.$row;
$result =& $this->db->queryRow($query, $types, MDB2_FETCHMODE_ASSOC);
if (PEAR::isError($result)) {
$this->assertTrue(false, 'Error executing query: '.$result->getMessage() .' - '. $result->getUserInfo());
} else {
$this->assertTrue(is_bool($result['subscribed']));
$this->assertTrue(is_numeric($result['user_id']));
$this->assertTrue(is_float($result['weight']));
$this->assertFalse(is_bool($result['user_name']));
}
}
}
?>
|