InsertTest.php 3.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
  1. <?php
  2. /**
  3. * Zend Framework
  4. *
  5. * LICENSE
  6. *
  7. * This source file is subject to the new BSD license that is bundled
  8. * with this package in the file LICENSE.txt.
  9. * It is also available through the world-wide-web at this URL:
  10. * http://framework.zend.com/license/new-bsd
  11. * If you did not receive a copy of the license and are unable to
  12. * obtain it through the world-wide-web, please send an email
  13. * to license@zend.com so we can send you a copy immediately.
  14. *
  15. * @category Zend
  16. * @package Zend_Test
  17. * @subpackage UnitTests
  18. * @copyright Copyright (c) 2005-2014 Zend Technologies USA Inc. (http://www.zend.com)
  19. * @license http://framework.zend.com/license/new-bsd New BSD License
  20. * @version $Id$
  21. */
  22. require_once "Zend/Test/DbAdapter.php";
  23. require_once "Zend/Test/PHPUnit/Db/Operation/Insert.php";
  24. require_once "PHPUnit/Extensions/Database/DataSet/FlatXmlDataSet.php";
  25. require_once 'PHPUnit/Extensions/Database/DataSet/IDataSet.php';
  26. require_once 'PHPUnit/Extensions/Database/DB/IDatabaseConnection.php';
  27. /**
  28. * @category Zend
  29. * @package Zend_Test
  30. * @subpackage UnitTests
  31. * @copyright Copyright (c) 2005-2014 Zend Technologies USA Inc. (http://www.zend.com)
  32. * @license http://framework.zend.com/license/new-bsd New BSD License
  33. * @group Zend_Test
  34. */
  35. class Zend_Test_PHPUnit_Db_Operation_InsertTest extends PHPUnit_Framework_TestCase
  36. {
  37. private $operation = null;
  38. public function setUp()
  39. {
  40. $this->operation = new Zend_Test_PHPUnit_Db_Operation_Insert();
  41. }
  42. public function testInsertDataSetUsingAdapterInsert()
  43. {
  44. $dataSet = new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__)."/_files/insertFixture.xml");
  45. $testAdapter = $this->getMock('Zend_Test_DbAdapter');
  46. $testAdapter->expects($this->at(0))
  47. ->method('insert')
  48. ->with('foo', array('foo' => 'foo', 'bar' => 'bar', 'baz' => 'baz'));
  49. $testAdapter->expects($this->at(1))
  50. ->method('insert')
  51. ->with('foo', array('foo' => 'bar', 'bar' => 'bar', 'baz' => 'bar'));
  52. $testAdapter->expects($this->at(2))
  53. ->method('insert')
  54. ->with('foo', array('foo' => 'baz', 'bar' => 'baz', 'baz' => 'baz'));
  55. $connection = new Zend_Test_PHPUnit_Db_Connection($testAdapter, "schema");
  56. $this->operation->execute($connection, $dataSet);
  57. }
  58. public function testInsertExceptionIsTransformed()
  59. {
  60. $this->setExpectedException('PHPUnit_Extensions_Database_Operation_Exception');
  61. $dataSet = new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__)."/_files/insertFixture.xml");
  62. $testAdapter = $this->getMock('Zend_Test_DbAdapter');
  63. $testAdapter->expects($this->any())->method('insert')->will($this->throwException(new Exception()));
  64. $connection = new Zend_Test_PHPUnit_Db_Connection($testAdapter, "schema");
  65. $this->operation->execute($connection, $dataSet);
  66. }
  67. public function testInvalidConnectionGivenThrowsException()
  68. {
  69. $this->setExpectedException("Zend_Test_PHPUnit_Db_Exception");
  70. $dataSet = $this->getMock('PHPUnit_Extensions_Database_DataSet_IDataSet');
  71. $connection = $this->getMock('PHPUnit_Extensions_Database_DB_IDatabaseConnection');
  72. $this->operation->execute($connection, $dataSet);
  73. }
  74. }