Subversion-Projekte lars-tiefland.php_share

<?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']));

        }

    }

}

?>