5 * Copyright (c) 2002-2009, Sebastian Bergmann <sb@sebastian-bergmann.de>.
8 * Redistribution and use in source and binary forms, with or without
9 * modification, are permitted provided that the following conditions
12 * * Redistributions of source code must retain the above copyright
13 * notice, this list of conditions and the following disclaimer.
15 * * Redistributions in binary form must reproduce the above copyright
16 * notice, this list of conditions and the following disclaimer in
17 * the documentation and/or other materials provided with the
20 * * Neither the name of Sebastian Bergmann nor the names of his
21 * contributors may be used to endorse or promote products derived
22 * from this software without specific prior written permission.
24 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
25 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
26 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
27 * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
28 * COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
29 * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
30 * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
31 * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
32 * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
33 * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
34 * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
35 * POSSIBILITY OF SUCH DAMAGE.
39 * @author Mike Lively <m@digitalsandwich.com>
40 * @copyright 2002-2009 Sebastian Bergmann <sb@sebastian-bergmann.de>
41 * @license http://www.opensource.org/licenses/bsd-license.php BSD License
43 * @link http://www.phpunit.de/
44 * @since File available since Release 3.2.0
47 require_once 'PHPUnit/Extensions/Database/TestCase.php';
48 require_once 'PHPUnit/Extensions/Database/DB/DefaultDatabaseConnection.php';
49 require_once 'PHPUnit/Extensions/Database/DataSet/FlatXmlDataSet.php';
50 require_once 'PHPUnit/Extensions/Database/DataSet/DefaultDataSet.php';
51 require_once 'PHPUnit/Extensions/Database/DataSet/DefaultTable.php';
52 require_once 'PHPUnit/Extensions/Database/DataSet/DefaultTableMetaData.php';
54 require_once 'PHPUnit/Extensions/Database/Operation/Delete.php';
55 require_once 'PHPUnit/Extensions/Database/Operation/DeleteAll.php';
56 require_once 'PHPUnit/Extensions/Database/Operation/Insert.php';
57 require_once 'PHPUnit/Extensions/Database/Operation/Update.php';
58 require_once 'PHPUnit/Extensions/Database/Operation/Truncate.php';
59 require_once 'PHPUnit/Extensions/Database/Operation/Replace.php';
61 require_once dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . '_files' . DIRECTORY_SEPARATOR . 'DatabaseTestUtility.php';
66 * @author Mike Lively <m@digitalsandwich.com>
67 * @copyright 2002-2009 Sebastian Bergmann <sb@sebastian-bergmann.de>
68 * @license http://www.opensource.org/licenses/bsd-license.php BSD License
70 * @link http://www.phpunit.de/
71 * @since File available since Release 3.2.0
73 class Extensions_Database_Operation_OperationsTest extends PHPUnit_Extensions_Database_TestCase
75 protected function setUp()
77 if (!extension_loaded('pdo_sqlite')) {
78 $this->markTestSkipped('PDO/SQLite is required to run this test.');
84 public function getConnection()
86 return new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection(DBUnitTestUtility::getSQLiteMemoryDB(), 'sqlite');
89 public function getDataSet()
91 return new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/OperationsTestFixture.xml');
94 public function testDelete()
96 $deleteOperation = new PHPUnit_Extensions_Database_Operation_Delete();
98 $deleteOperation->execute($this->getConnection(), new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/DeleteOperationTest.xml'));
100 $this->assertDataSetsEqual(new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/DeleteOperationResult.xml'), $this->getConnection()->createDataSet());
103 public function testDeleteAll()
105 $deleteAllOperation = new PHPUnit_Extensions_Database_Operation_DeleteAll();
107 $deleteAllOperation->execute($this->getConnection(), new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/DeleteAllOperationTest.xml'));
109 $expectedDataSet = new PHPUnit_Extensions_Database_DataSet_DefaultDataSet(array(
110 new PHPUnit_Extensions_Database_DataSet_DefaultTable(
111 new PHPUnit_Extensions_Database_DataSet_DefaultTableMetaData('table1',
112 array('table1_id', 'column1', 'column2', 'column3', 'column4'))
114 new PHPUnit_Extensions_Database_DataSet_DefaultTable(
115 new PHPUnit_Extensions_Database_DataSet_DefaultTableMetaData('table2',
116 array('table2_id', 'column5', 'column6', 'column7', 'column8'))
118 new PHPUnit_Extensions_Database_DataSet_DefaultTable(
119 new PHPUnit_Extensions_Database_DataSet_DefaultTableMetaData('table3',
120 array('table3_id', 'column9', 'column10', 'column11', 'column12'))
124 $this->assertDataSetsEqual($expectedDataSet, $this->getConnection()->createDataSet());
127 public function testTruncate()
129 $truncateOperation = new PHPUnit_Extensions_Database_Operation_Truncate();
131 $truncateOperation->execute($this->getConnection(), new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/DeleteAllOperationTest.xml'));
133 $expectedDataSet = new PHPUnit_Extensions_Database_DataSet_DefaultDataSet(array(
134 new PHPUnit_Extensions_Database_DataSet_DefaultTable(
135 new PHPUnit_Extensions_Database_DataSet_DefaultTableMetaData('table1',
136 array('table1_id', 'column1', 'column2', 'column3', 'column4'))
138 new PHPUnit_Extensions_Database_DataSet_DefaultTable(
139 new PHPUnit_Extensions_Database_DataSet_DefaultTableMetaData('table2',
140 array('table2_id', 'column5', 'column6', 'column7', 'column8'))
142 new PHPUnit_Extensions_Database_DataSet_DefaultTable(
143 new PHPUnit_Extensions_Database_DataSet_DefaultTableMetaData('table3',
144 array('table3_id', 'column9', 'column10', 'column11', 'column12'))
148 $this->assertDataSetsEqual($expectedDataSet, $this->getConnection()->createDataSet());
151 public function testInsert()
153 $insertOperation = new PHPUnit_Extensions_Database_Operation_Insert();
155 $insertOperation->execute($this->getConnection(), new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/InsertOperationTest.xml'));
157 $this->assertDataSetsEqual(new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/InsertOperationResult.xml'), $this->getConnection()->createDataSet());
160 public function testUpdate()
162 $updateOperation = new PHPUnit_Extensions_Database_Operation_Update();
164 $updateOperation->execute($this->getConnection(), new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/UpdateOperationTest.xml'));
166 $this->assertDataSetsEqual(new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/UpdateOperationResult.xml'), $this->getConnection()->createDataSet());
169 public function testReplace()
171 $replaceOperation = new PHPUnit_Extensions_Database_Operation_Replace();
173 $replaceOperation->execute($this->getConnection(), new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/ReplaceOperationTest.xml'));
175 $this->assertDataSetsEqual(new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/ReplaceOperationResult.xml'), $this->getConnection()->createDataSet());
178 public function testInsertEmptyTable()
180 $insertOperation = new PHPUnit_Extensions_Database_Operation_Insert();
182 $insertOperation->execute($this->getConnection(), new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/EmptyTableInsertTest.xml'));
184 $this->assertDataSetsEqual(new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/EmptyTableInsertResult.xml'), $this->getConnection()->createDataSet());
186 public function testInsertAllEmptyTables()
188 $insertOperation = new PHPUnit_Extensions_Database_Operation_Insert();
190 $insertOperation->execute($this->getConnection(), new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/AllEmptyTableInsertTest.xml'));
192 $this->assertDataSetsEqual(new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__).'/../_files/XmlDataSets/AllEmptyTableInsertResult.xml'), $this->getConnection()->createDataSet());