Subversion-Projekte lars-tiefland.php_share

<?php

// +----------------------------------------------------------------------+

// | PHP versions 4 and 5                                                 |

// +----------------------------------------------------------------------+

// | Copyright (c) 1998-2006 Lukas Smith, Lorenzo Alberton                |

// | 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: Lorenzo Alberton <l dot alberton at quipo dot it>            |

// +----------------------------------------------------------------------+

//

// $Id: MDB2_function_testcase.php,v 1.20 2006/08/07 20:15:57 lsmith Exp $

class MDB2_Function_TestCase extends MDB2_TestCase

{

    function setUp() {

        parent::setUp();

        $this->db->loadModule('Function', null, true);

    }

    /**

     * Test functionTable()

     */

    function testFunctionTable()

    {

        if (!$this->methodExists($this->db->function, 'functionTable')) {

            return;

        }

        $functionTable_clause = $this->db->function->functionTable();

        $query = 'SELECT 1 '.$functionTable_clause;

        $result = $this->db->queryOne($query);

        if (PEAR::isError($result)) {

            $this->assertFalse(true, 'Error fetching from function table');

        } else {

            $this->assertEquals('1', $result, 'Error fetching value from function table');

        }

    }

    /**

     * Test now()

     */

    function testNow()

    {

        if (!$this->methodExists($this->db->function, 'now')) {

            return;

        }

        $tests = array(

            'timestamp' => '/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/',

            'date' => '/^\d{4}-\d{2}-\d{2}$/',

            'time' => '/^\d{2}:\d{2}:\d{2}$/',

        );

        foreach ($tests as $type => $regexp) {

            $functionTable_clause = $this->db->function->functionTable();

            $now_clause = $this->db->function->now($type);

            $query = 'SELECT '.$now_clause . $functionTable_clause;

            $result = $this->db->queryOne($query, $type);

            if (PEAR::isError($result)) {

                $this->assertFalse(true, 'Error getting '.$type);

            } else {

                $this->assertRegExp($regexp, $result, 'Error: not a proper '.$type);

            }

        }

    }

    /**

     * Test substring()

     */

    function testSubstring()

    {

        if (!$this->methodExists($this->db->function, 'substring')) {

            return;

        }

        $data = $this->getSampleData(1234);

        $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);

        $result = $stmt->execute(array_values($data));

        $stmt->free();

        if (PEAR::isError($result)) {

            $this->assertTrue(false, 'Error executing prepared query'.$result->getMessage());

        }

        $substring_clause = $this->db->function->substring('user_name', 1, 4);

        $query = 'SELECT '.$substring_clause .' FROM users';

        $result = $this->db->queryOne($query);

        if (PEAR::isError($result)) {

            $this->assertFalse(true, 'Error getting substring');

        } else {

            $this->assertEquals('user', $result, 'Error: substrings not equals');

        }

        $substring_clause = $this->db->function->substring('user_name', 5, 1);

        $query = 'SELECT '.$substring_clause .' FROM users';

        $result = $this->db->queryOne($query);

        if (PEAR::isError($result)) {

            $this->assertFalse(true, 'Error getting substring');

        } else {

            $this->assertEquals('_', $result, 'Error: substrings not equals');

        }

        //test NULL 2nd parameter

        $substring_clause = $this->db->function->substring('user_name', 6);

        $query = 'SELECT '.$substring_clause .' FROM users';

        $result = $this->db->queryOne($query);

        if (PEAR::isError($result)) {

            $this->assertFalse(true, 'Error getting substring');

        } else {

            $this->assertEquals('1234', $result, 'Error: substrings not equals');

        }

    }

    /**

     * Test concat()

     */

    function testConcat()

    {

        if (!$this->methodExists($this->db->function, 'concat')) {

            return;

        }

        $functionTable_clause = $this->db->function->functionTable();

        $concat_clause = $this->db->function->concat($this->db->quote('time', 'text'), $this->db->quote('stamp', 'text'));

        $query = 'SELECT '.$concat_clause . $functionTable_clause;

        $result = $this->db->queryOne($query);

        if (PEAR::isError($result)) {

            $this->assertFalse(true, 'Error getting concat');

        } else {

            $this->assertEquals('timestamp', $result, 'Error: could not concatenate "time+stamp"');

        }

    }

    /**

     * Test random()

     */

    function testRandom()

    {

        if (!$this->methodExists($this->db->function, 'random')) {

            return;

        }

        $rand_clause = $this->db->function->random();

        $functionTable_clause = $this->db->function->functionTable();

        $query = 'SELECT '.$rand_clause . $functionTable_clause;

        $result = $this->db->queryOne($query, 'float');

        if (PEAR::isError($result)) {

            $this->assertFalse(true, 'Error getting random value:'. $result->getMessage());

        } else {

            $this->assertTrue(($result >= 0 && $result <= 1), 'Error: could not get random value between 0 and 1: '.$result);

        }

    }

    /**

     * Test lower()

     */

    function testLower()

    {

        if (!$this->methodExists($this->db->function, 'lower')) {

            return;

        }

        $string = $this->db->quote('FoO');

        $lower_clause = $this->db->function->lower($string);

        $functionTable_clause = $this->db->function->functionTable();

        $query = 'SELECT '.$lower_clause . $functionTable_clause;

        $result = $this->db->queryOne($query, 'text');

        if (PEAR::isError($result)) {

            $this->assertFalse(true, 'Error getting lower case value:'. $result->getMessage());

        } else {

            $this->assertTrue(($result === 'foo'), 'Error: could not lower case "FoO": '.$result);

        }

    }

    /**

     * Test upper()

     */

    function testUpper()

    {

        if (!$this->methodExists($this->db->function, 'upper')) {

            return;

        }

        $string = $this->db->quote('FoO');

        $upper_clause = $this->db->function->upper($string);

        $functionTable_clause = $this->db->function->functionTable();

        $query = 'SELECT '.$upper_clause . $functionTable_clause;

        $result = $this->db->queryOne($query, 'text');

        if (PEAR::isError($result)) {

            $this->assertFalse(true, 'Error getting upper case value:'. $result->getMessage());

        } else {

            $this->assertTrue(($result === 'FOO'), 'Error: could not upper case "FoO": '.$result);

        }

    }

}

?>