/DevApp/library/ServerLibraries/ZendFramework/1.7/tests/Zend/Db/Adapter/Pdo/MysqlTest.php
PHP | 317 lines | 178 code | 40 blank | 99 comment | 0 complexity | 1644e67023a6b7d22dea5ec58f329a61 MD5 | raw file
Possible License(s): BSD-3-Clause, LGPL-2.0, MIT, Apache-2.0
- <?php
- /**
- * Zend Framework
- *
- * LICENSE
- *
- * This source file is subject to the new BSD license that is bundled
- * with this package in the file LICENSE.txt.
- * It is also available through the world-wide-web at this URL:
- * http://framework.zend.com/license/new-bsd
- * If you did not receive a copy of the license and are unable to
- * obtain it through the world-wide-web, please send an email
- * to license@zend.com so we can send you a copy immediately.
- *
- * @category Zend
- * @package Zend_Db
- * @subpackage UnitTests
- * @copyright Copyright (c) 2005-2008 Zend Technologies USA Inc. (http://www.zend.com)
- * @license http://framework.zend.com/license/new-bsd New BSD License
- * @version $Id: MysqlTest.php 12842 2008-11-25 22:07:48Z mikaelkael $
- */
- /**
- * @see Zend_Db_Adapter_Pdo_TestCommon
- */
- require_once 'Zend/Db/Adapter/Pdo/TestCommon.php';
- /**
- * @see Zend_Db_Adapter_Pdo_Mysql
- */
- require_once 'Zend/Db/Adapter/Pdo/Mysql.php';
- PHPUnit_Util_Filter::addFileToFilter(__FILE__);
- /**
- * @category Zend
- * @package Zend_Db
- * @subpackage UnitTests
- * @copyright Copyright (c) 2005-2008 Zend Technologies USA Inc. (http://www.zend.com)
- * @license http://framework.zend.com/license/new-bsd New BSD License
- */
- class Zend_Db_Adapter_Pdo_MysqlTest extends Zend_Db_Adapter_Pdo_TestCommon
- {
- protected $_numericDataTypes = array(
- Zend_Db::INT_TYPE => Zend_Db::INT_TYPE,
- Zend_Db::BIGINT_TYPE => Zend_Db::BIGINT_TYPE,
- Zend_Db::FLOAT_TYPE => Zend_Db::FLOAT_TYPE,
- 'INT' => Zend_Db::INT_TYPE,
- 'INTEGER' => Zend_Db::INT_TYPE,
- 'MEDIUMINT' => Zend_Db::INT_TYPE,
- 'SMALLINT' => Zend_Db::INT_TYPE,
- 'TINYINT' => Zend_Db::INT_TYPE,
- 'BIGINT' => Zend_Db::BIGINT_TYPE,
- 'SERIAL' => Zend_Db::BIGINT_TYPE,
- 'DEC' => Zend_Db::FLOAT_TYPE,
- 'DECIMAL' => Zend_Db::FLOAT_TYPE,
- 'DOUBLE' => Zend_Db::FLOAT_TYPE,
- 'DOUBLE PRECISION' => Zend_Db::FLOAT_TYPE,
- 'FIXED' => Zend_Db::FLOAT_TYPE,
- 'FLOAT' => Zend_Db::FLOAT_TYPE
- );
- /**
- * Test AUTO_QUOTE_IDENTIFIERS option
- * Case: Zend_Db::AUTO_QUOTE_IDENTIFIERS = true
- *
- * MySQL actually allows delimited identifiers to remain
- * case-insensitive, so this test overrides its parent.
- */
- public function testAdapterAutoQuoteIdentifiersTrue()
- {
- $params = $this->_util->getParams();
- $params['options'] = array(
- Zend_Db::AUTO_QUOTE_IDENTIFIERS => true
- );
- $db = Zend_Db::factory($this->getDriver(), $params);
- $db->getConnection();
- $select = $this->_db->select();
- $select->from('zfproducts');
- $stmt = $this->_db->query($select);
- $result1 = $stmt->fetchAll();
- $this->assertEquals(1, $result1[0]['product_id']);
- $select = $this->_db->select();
- $select->from('zfproducts');
- try {
- $stmt = $this->_db->query($select);
- $result2 = $stmt->fetchAll();
- } catch (Zend_Exception $e) {
- $this->assertType('Zend_Db_Statement_Exception', $e,
- 'Expecting object of type Zend_Db_Statement_Exception, got '.get_class($e));
- $this->fail('Unexpected exception '.get_class($e).' received: '.$e->getMessage());
- }
- $this->assertEquals($result1, $result2);
- }
- /**
- * Ensures that driver_options are properly passed along to PDO
- *
- * @see http://framework.zend.com/issues/browse/ZF-285
- * @return void
- */
- public function testAdapterDriverOptions()
- {
- $params = $this->_util->getParams();
- $params['driver_options'] = array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true);
- $db = Zend_Db::factory($this->getDriver(), $params);
- $this->assertTrue((boolean) $db->getConnection()->getAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY));
- $params['driver_options'] = array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => false);
- $db = Zend_Db::factory($this->getDriver(), $params);
- $this->assertFalse((boolean) $db->getConnection()->getAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY));
- }
- public function testAdapterInsertSequence()
- {
- $this->markTestSkipped($this->getDriver() . ' does not support sequences');
- }
- /**
- * test that quoteColumnAs() accepts a string
- * and an alias, and returns each as delimited
- * identifiers, with 'AS' in between.
- */
- public function testAdapterQuoteColumnAs()
- {
- $string = "foo";
- $alias = "bar";
- $value = $this->_db->quoteColumnAs($string, $alias);
- $this->assertEquals('`foo` AS `bar`', $value);
- }
- /**
- * test that quoteColumnAs() accepts a string
- * and an alias, but ignores the alias if it is
- * the same as the base identifier in the string.
- */
- public function testAdapterQuoteColumnAsSameString()
- {
- $string = 'foo.bar';
- $alias = 'bar';
- $value = $this->_db->quoteColumnAs($string, $alias);
- $this->assertEquals('`foo`.`bar`', $value);
- }
- /**
- * test that quoteIdentifier() accepts a string
- * and returns a delimited identifier.
- */
- public function testAdapterQuoteIdentifier()
- {
- $value = $this->_db->quoteIdentifier('table_name');
- $this->assertEquals('`table_name`', $value);
- }
- /**
- * test that quoteIdentifier() accepts an array
- * and returns a qualified delimited identifier.
- */
- public function testAdapterQuoteIdentifierArray()
- {
- $array = array('foo', 'bar');
- $value = $this->_db->quoteIdentifier($array);
- $this->assertEquals('`foo`.`bar`', $value);
- }
- /**
- * test that quoteIdentifier() accepts an array
- * containing a Zend_Db_Expr, and returns strings
- * as delimited identifiers, and Exprs as unquoted.
- */
- public function testAdapterQuoteIdentifierArrayDbExpr()
- {
- $expr = new Zend_Db_Expr('*');
- $array = array('foo', $expr);
- $value = $this->_db->quoteIdentifier($array);
- $this->assertEquals('`foo`.*', $value);
- }
- /**
- * test that quoteIdentifer() escapes a double-quote
- * character in a string.
- */
- public function testAdapterQuoteIdentifierDoubleQuote()
- {
- $string = 'table_"_name';
- $value = $this->_db->quoteIdentifier($string);
- $this->assertEquals('`table_"_name`', $value);
- }
- /**
- * test that quoteIdentifer() accepts an integer
- * and returns a delimited identifier as with a string.
- */
- public function testAdapterQuoteIdentifierInteger()
- {
- $int = 123;
- $value = $this->_db->quoteIdentifier($int);
- $this->assertEquals('`123`', $value);
- }
- /**
- * test that quoteIdentifier() accepts a string
- * containing a dot (".") character, splits the
- * string, quotes each segment individually as
- * delimited identifers, and returns the imploded
- * string.
- */
- public function testAdapterQuoteIdentifierQualified()
- {
- $string = 'table.column';
- $value = $this->_db->quoteIdentifier($string);
- $this->assertEquals('`table`.`column`', $value);
- }
- /**
- * test that quoteIdentifer() escapes a single-quote
- * character in a string.
- */
- public function testAdapterQuoteIdentifierSingleQuote()
- {
- $string = "table_'_name";
- $value = $this->_db->quoteIdentifier($string);
- $this->assertEquals('`table_\'_name`', $value);
- }
- /**
- * test that describeTable() returns correct types
- * @group ZF-3624
- *
- */
- public function testAdapterDescribeTableAttributeColumnFloat()
- {
- $desc = $this->_db->describeTable('zfprice');
- $this->assertEquals('zfprice', $desc['price']['TABLE_NAME']);
- $this->assertRegExp('/float/i', $desc['price']['DATA_TYPE']);
- }
- /**
- * test that quoteTableAs() accepts a string and an alias,
- * and returns each as delimited identifiers.
- * Most RDBMS want an 'AS' in between.
- */
- public function testAdapterQuoteTableAs()
- {
- $string = "foo";
- $alias = "bar";
- $value = $this->_db->quoteTableAs($string, $alias);
- $this->assertEquals('`foo` AS `bar`', $value);
- }
- /**
- * Ensures that the character sequence ":0'" is handled properly
- *
- * @link http://framework.zend.com/issues/browse/ZF-2059
- * @return void
- */
- public function testZF2059()
- {
- $this->markTestIncomplete('Inconsistent test results');
- }
- /**
- * Ensures that the PDO Buffered Query does not throw the error
- * 2014 General error
- *
- * @link http://framework.zend.com/issues/browse/ZF-2101
- * @return void
- */
- public function testZF2101()
- {
- $params = $this->_util->getParams();
- $params['driver_options'] = array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true);
- $db = Zend_Db::factory($this->getDriver(), $params);
-
- // Set default bound value
- $customerId = 1;
- // Stored procedure returns a single row
- $stmt = $db->prepare('CALL zf_test_procedure(:customerId)');
- $stmt->bindParam('customerId', $customerId, PDO::PARAM_INT);
- $stmt->execute();
- $result = $stmt->fetchAll();
- $this->assertEquals(1, $result[0]['product_id']);
- // Reset statement
- $stmt->closeCursor();
-
- // Stored procedure returns a single row
- $stmt = $db->prepare('CALL zf_test_procedure(:customerId)');
- $stmt->bindParam('customerId', $customerId, PDO::PARAM_INT);
- $stmt->execute();
- $result = $stmt->fetchAll();
- $this->assertEquals(1, $result[0]['product_id']);
- }
- public function getDriver()
- {
- return 'Pdo_Mysql';
- }
- }