cvs: pear /MDB2/tests MDB2_extended_testcase.php test_setup.php.dist

lsmith Sat May 20 10:33:30 2006 UTC Added files: /pear/MDB2/tests MDB2_extended_testcase.php Modified files: /pear/MDB2/tests test_setup.php.dist Log: - added test class for the Extended module http://cvs.php.net/viewcvs.cgi/pear/MDB2/tests/test_setup.php.dist?r1=1.14&r2=1.15&diff_format=u Index: pear/MDB2/tests/test_setup.php.dist diff -u pear/MDB2/tests/test_setup.php.dist:1.14 pear/MDB2/tests/test_setup.php.dist:1.15 --- pear/MDB2/tests/test_setup.php.dist:1.14 Thu Mar 23 07:35:53 2006 +++ pear/MDB2/tests/test_setup.php.dist Sat May 20 10:33:30 2006 @@ -7,6 +7,7 @@ 'MDB2_api_testcase', 'MDB2_usage_testcase', 'MDB2_bugs_testcase', + 'MDB2_extended_testcase', 'MDB2_datatype_testcase', 'MDB2_manager_testcase', 'MDB2_reverse_testcase', http://cvs.php.net/viewcvs.cgi/pear/MDB2/tests/MDB2_extended_testcase.php?view=markup&rev=1.1 Index: pear/MDB2/tests/MDB2_extended_testcase.php +++ pear/MDB2/tests/MDB2_extended_testcase.php <?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_extended_testcase.php,v 1.1 2006/05/20 10:33:30 lsmith Exp $ require_once 'MDB2_testcase.php'; class MDB2_Extended_TestCase extends MDB2_TestCase { /** * */ function testAutoExecute() { $data = $this->getSampleData(); $result = $this->db->loadModule('Extended'); if (PEAR::isError($result)) { $this->assertTrue(false, 'Error loading "Extended" module: '.$result->getMessage()); } $result = $this->db->extended->autoExecute('users', $data, MDB2_AUTOQUERY_INSERT, null, $this->fields); if (PEAR::isError($result)) { $this->assertTrue(false, 'Error auto executing insert: '.$result->getMessage()); } $this->db->setFetchMode(MDB2_FETCHMODE_ASSOC); $result = $this->db->query('SELECT * FROM users', $this->fields); if (PEAR::isError($result)) { $this->assertTrue(false, 'Error selecting from users: '.$result->getMessage()); } $this->verifyFetchedValues($result, null, $data); $result->free(); $update_data = array(); $data['user_name'] = $update_data['user_name'] = 'foo'; $where = 'user_id = '.$this->db->quote($data['user_id'], 'integer'); $result = $this->db->extended->autoExecute('users', $update_data, MDB2_AUTOQUERY_UPDATE, $where, $this->fields); if (PEAR::isError($result)) { $this->assertTrue(false, 'Error auto executing insert: '.$result->getMessage()); } $this->db->setFetchMode(MDB2_FETCHMODE_ASSOC); $result = $this->db->query('SELECT * FROM users', $this->fields); if (PEAR::isError($result)) { $this->assertTrue(false, 'Error selecting from users: '.$result->getMessage()); } $this->verifyFetchedValues($result, null, $data); $result->free(); } } ?>