12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788 |
- <?php
- /**
- * Copyright (c) 2014 Robin Appelman <icewind@owncloud.com>
- * This file is licensed under the Affero General Public License version 3 or
- * later.
- * See the COPYING-README file.
- */
- namespace Test\DB;
- use Doctrine\DBAL\Platforms\SqlitePlatform;
- use OC\DB\MDB2SchemaManager;
- class Connection extends \Test\TestCase {
- /**
- * @var \OCP\IDBConnection
- */
- private $connection;
- public static function setUpBeforeClass()
- {
- self::dropTestTable();
- parent::setUpBeforeClass();
- }
- public static function tearDownAfterClass()
- {
- self::dropTestTable();
- parent::tearDownAfterClass();
- }
- protected static function dropTestTable()
- {
- if (\OC::$server->getConfig()->getSystemValue('dbtype', 'sqlite') !== 'oci') {
- \OC_DB::dropTable('table');
- }
- }
- public function setUp() {
- parent::setUp();
- $this->connection = \OC::$server->getDatabaseConnection();
- }
- /**
- * @param string $table
- */
- public function assertTableExist($table) {
- if ($this->connection->getDatabasePlatform() instanceof SqlitePlatform) {
- // sqlite removes the tables after closing the DB
- $this->assertTrue(true);
- } else {
- $this->assertTrue($this->connection->tableExists($table), 'Table ' . $table . ' exists.');
- }
- }
- /**
- * @param string $table
- */
- public function assertTableNotExist($table) {
- if ($this->connection->getDatabasePlatform() instanceof SqlitePlatform) {
- // sqlite removes the tables after closing the DB
- $this->assertTrue(true);
- } else {
- $this->assertFalse($this->connection->tableExists($table), 'Table ' . $table . ' doesnt exists.');
- }
- }
- private function makeTestTable() {
- $schemaManager = new MDB2SchemaManager($this->connection);
- $schemaManager->createDbFromStructure(__DIR__ . '/testschema.xml');
- }
- public function testTableExists() {
- $this->assertTableNotExist('table');
- $this->makeTestTable();
- $this->assertTableExist('table');
- }
- /**
- * @depends testTableExists
- */
- public function testDropTable() {
- $this->assertTableExist('table');
- $this->connection->dropTable('table');
- $this->assertTableNotExist('table');
- }
- }
|