blob: d4039472a6bbdf81223ad3e171c619ab316e9acf (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
<?php
/**
* Copyright (c) 2014 Thomas Müller <deepdiver@owncloud.com>
* This file is licensed under the Affero General Public License version 3 or
* later.
* See the COPYING-README file.
*/
/**
* Tests for the converting of MySQL tables to InnoDB engine
*
* @see \OC\Repair\RepairMimeTypes
*/
class TestRepairInnoDB extends \Test\TestCase {
/** @var \OC\RepairStep */
private $repair;
/** @var \Doctrine\DBAL\Connection */
private $connection;
/** @var string */
private $tableName;
protected function setUp() {
parent::setUp();
$this->connection = \OC_DB::getConnection();
if (!$this->connection->getDatabasePlatform() instanceof \Doctrine\DBAL\Platforms\MySqlPlatform) {
$this->markTestSkipped("Test only relevant on MySql");
}
$dbPrefix = \OC::$server->getConfig()->getSystemValue("dbtableprefix");
$this->tableName = $this->getUniqueID($dbPrefix . "_innodb_test");
$this->connection->exec("CREATE TABLE $this->tableName(id INT) ENGINE MyISAM");
$this->repair = new \OC\Repair\InnoDB();
}
protected function tearDown() {
$this->connection->getSchemaManager()->dropTable($this->tableName);
parent::tearDown();
}
public function testInnoDBConvert() {
$result = $this->countMyIsamTables();
$this->assertEquals(1, $result);
$this->repair->run();
$result = $this->countMyIsamTables();
$this->assertEquals(0, $result);
}
/**
* @param $dbName
* @return mixed
*/
private function countMyIsamTables() {
$dbName = \OC::$server->getConfig()->getSystemValue("dbname");
$result = $this->connection->fetchColumn(
"SELECT count(*) FROM information_schema.tables WHERE table_schema = ? and table_name = ? AND engine = 'MyISAM'",
array($dbName, $this->tableName)
);
return $result;
}
}
|
