Database/tests/handler_test.php

<?php
/**
 *
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 * 
 *   http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 *
 * @license http://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
 * @version //autogentag//
 * @filesource
 * @package Database
 * @subpackage Tests
 */

/**
 * Test the handler classes.
 *
 * @package Database
 * @subpackage Tests
 */
class ezcDatabaseHandlerTest extends ezcTestCase
{
    protected function setUp()
    {
        try
        {
            $db = ezcDbInstance::get();
        }
        catch ( Exception $e )
        {
            $this->markTestSkipped();
        }
    }

    public function testConstructorNoDatabaseName()
    {
        try
        {
            // we'll create an instance of the correct type simply by making a similar one to the default.
            $db = ezcDbInstance::get();
            $className = get_class( $db );
            $db = new $className( array() );
            $this->fail( "Instantiating a handler with no database name should not be successful" );
        }
        catch ( ezcDbMissingParameterException $e ) {}
    }

    public function testIdentifierQuotingNoEscape()
    {
        $db = ezcDbInstance::get();
        switch ( get_class( $db ) )
        {
            case 'ezcDbHandlerMysql':
                $quoteChars = array( '`', '`' );
                break;
            case 'ezcDbHandlerOracle':
            case 'ezcDbHandlerPgsql':
            case 'ezcDbHandlerSqlite':
                $quoteChars = array( '"', '"' );
                break;
            case 'ezcDbHandlerMssql':
                $quoteChars = array( '[', ']' );
                break;

            default:
                $this->markTestSkipped( "No quoting test defined for handler class '{" . get_class( $db ) . "}'" );
        }

        $this->assertEquals(
            $quoteChars[0] . 'TestIdentifier' . $quoteChars[1],
            $db->quoteIdentifier( 'TestIdentifier' )
        );
    }

    public function testIdentifierQuotingEscape()
    {
        $db = ezcDbInstance::get();
        switch ( get_class( $db ) )
        {
            case 'ezcDbHandlerMysql':
                $quoteChars = array( '`', '`' );
                break;
            case 'ezcDbHandlerMssql':
                $db->setOptions( new ezcDbMssqlOptions( array('quoteIdentifier' => ezcDbMssqlOptions::QUOTES_COMPLIANT ) ));
            case 'ezcDbHandlerOracle':
            case 'ezcDbHandlerPgsql':
            case 'ezcDbHandlerSqlite':
                $quoteChars = array( '"', '"' );
                break;
            default:
                $this->markTestSkipped( "No quoting test defined for handler class '{" . get_class( $db ) . "}'" );
        }

        $this->assertEquals(
            $quoteChars[0] . "Test" . $quoteChars[1] . $quoteChars[1] . "Identifier" . $quoteChars[1],
            $db->quoteIdentifier( "Test" . $quoteChars[1] . "Identifier" )
        );
    }

    public function testMssqlIdentifierQuotingUntouched()
    {
        $db = ezcDbInstance::get();
        if ( get_class( $db ) != 'ezcDbHandlerMssql' ) 
        {
            $this->markTestSkipped( 'Test defined for MS SQL handler class only.' );
        }
        $db->setOptions( new ezcDbMssqlOptions( array('quoteIdentifier' => ezcDbMssqlOptions::QUOTES_UNTOUCHED ) ));
        $quoteChars = array( '"', '"' );
        $this->assertEquals( $quoteChars[0].'ezctesttable'.$quoteChars[1], $db->quoteIdentifier( 'ezctesttable' ));
    }

    public function testMssqlIdentifierQuotingCompliant()
    {
        $db = ezcDbInstance::get();
        if ( get_class( $db ) != 'ezcDbHandlerMssql' ) 
        {
            $this->markTestSkipped( 'Test defined for MS SQL handler class only.' );
        }
        $db->setOptions( new ezcDbMssqlOptions( array('quoteIdentifier' => ezcDbMssqlOptions::QUOTES_COMPLIANT ) ));        

        $this->assertEquals( '"ezctesttable"', $db->quoteIdentifier( 'ezctesttable' ));
    }

    public function testMssqlIdentifierQuotingLegacy()
    {
        $db = ezcDbInstance::get();
        if ( get_class( $db ) != 'ezcDbHandlerMssql' ) 
        {
            $this->markTestSkipped( 'Test defined for MS SQL handler class only.' );
        }
        $db->setOptions( new ezcDbMssqlOptions( array('quoteIdentifier' => ezcDbMssqlOptions::QUOTES_LEGACY ) ));

        $this->assertEquals( '[ezctesttable]', $db->quoteIdentifier( 'ezctesttable' ));
    }
        
    public function testMssqlIdentifierQuotingImpl()
    {
        $db = ezcDbInstance::get();
        if ( get_class( $db ) != 'ezcDbHandlerMssql' ) 
        {
            $this->markTestSkipped( 'Test defined for MS SQL handler class only.' );
        }
        $db->setOptions( new ezcDbMssqlOptions( array('quoteIdentifier' => ezcDbMssqlOptions::QUOTES_COMPLIANT ) ));
        try {
            $db->query('CREATE TABLE '.$db->quoteIdentifier('group') . ' ( id INT )');
            $db->query('DROP TABLE '.$db->quoteIdentifier('group') );
        } 
        catch ( Exception $ex ) 
        {
            $this->fail( "Incorrect identifiers quoting ".$ex->getMessage() );
        }
    }

    public static function suite()
    {
         return new PHPUnit_Framework_TestSuite( "ezcDatabaseHandlerTest" );
    }
}

?>