summaryrefslogtreecommitdiffstats
path: root/lib/private/DB/Migrator.php
diff options
context:
space:
mode:
authorJulius Härtl <jus@bitgrid.net>2020-11-26 11:10:41 +0100
committerMorris Jobke <hey@morrisjobke.de>2021-03-17 21:08:22 +0100
commita2f3077ee802b4b291ba4f846bfceb69ec0f225f (patch)
tree81cbbd7deaf05dc9ba49f6f0a2c98ca0655e1e5e /lib/private/DB/Migrator.php
parent0d46fafd41a739c74a500d6149af23deb9d70155 (diff)
downloadnextcloud-server-a2f3077ee802b4b291ba4f846bfceb69ec0f225f.tar.gz
nextcloud-server-a2f3077ee802b4b291ba4f846bfceb69ec0f225f.zip
Skip db migration simulation for core schema changes
Signed-off-by: Julius Härtl <jus@bitgrid.net>
Diffstat (limited to 'lib/private/DB/Migrator.php')
-rw-r--r--lib/private/DB/Migrator.php103
1 files changed, 0 insertions, 103 deletions
diff --git a/lib/private/DB/Migrator.php b/lib/private/DB/Migrator.php
index 609ed5d6f70..d7bd9115c6f 100644
--- a/lib/private/DB/Migrator.php
+++ b/lib/private/DB/Migrator.php
@@ -35,14 +35,10 @@ use Doctrine\DBAL\Exception;
use Doctrine\DBAL\Platforms\MySQLPlatform;
use Doctrine\DBAL\Schema\AbstractAsset;
use Doctrine\DBAL\Schema\Comparator;
-use Doctrine\DBAL\Schema\Index;
use Doctrine\DBAL\Schema\Schema;
-use Doctrine\DBAL\Schema\SchemaConfig;
-use Doctrine\DBAL\Schema\Table;
use Doctrine\DBAL\Types\StringType;
use Doctrine\DBAL\Types\Type;
use OCP\IConfig;
-use OCP\Security\ISecureRandom;
use Symfony\Component\EventDispatcher\EventDispatcherInterface;
use Symfony\Component\EventDispatcher\GenericEvent;
use function preg_match;
@@ -52,9 +48,6 @@ class Migrator {
/** @var \Doctrine\DBAL\Connection */
protected $connection;
- /** @var ISecureRandom */
- private $random;
-
/** @var IConfig */
protected $config;
@@ -66,16 +59,13 @@ class Migrator {
/**
* @param \Doctrine\DBAL\Connection $connection
- * @param ISecureRandom $random
* @param IConfig $config
* @param EventDispatcherInterface $dispatcher
*/
public function __construct(\Doctrine\DBAL\Connection $connection,
- ISecureRandom $random,
IConfig $config,
EventDispatcherInterface $dispatcher = null) {
$this->connection = $connection;
- $this->random = $random;
$this->config = $config;
$this->dispatcher = $dispatcher;
}
@@ -107,73 +97,6 @@ class Migrator {
}
/**
- * Create a unique name for the temporary table
- *
- * @param string $name
- * @return string
- */
- protected function generateTemporaryTableName($name) {
- return $this->config->getSystemValue('dbtableprefix', 'oc_') . $name . '_' . $this->random->generate(13, ISecureRandom::CHAR_LOWER . ISecureRandom::CHAR_DIGITS);
- }
-
- /**
- * Check the migration of a table on a copy so we can detect errors before messing with the real table
- *
- * @param \Doctrine\DBAL\Schema\Table $table
- * @throws \OC\DB\MigrationException
- */
- protected function checkTableMigrate(Table $table) {
- $name = $table->getName();
- $tmpName = $this->generateTemporaryTableName($name);
-
- $this->copyTable($name, $tmpName);
-
- //create the migration schema for the temporary table
- $tmpTable = $this->renameTableSchema($table, $tmpName);
- $schemaConfig = new SchemaConfig();
- $schemaConfig->setName($this->connection->getDatabase());
- $schema = new Schema([$tmpTable], [], $schemaConfig);
-
- try {
- $this->applySchema($schema);
- $this->dropTable($tmpName);
- } catch (Exception $e) {
- // pgsql needs to commit it's failed transaction before doing anything else
- if ($this->connection->isTransactionActive()) {
- $this->connection->commit();
- }
- $this->dropTable($tmpName);
- throw new MigrationException($table->getName(), $e->getMessage());
- }
- }
-
- /**
- * @param \Doctrine\DBAL\Schema\Table $table
- * @param string $newName
- * @return \Doctrine\DBAL\Schema\Table
- */
- protected function renameTableSchema(Table $table, $newName) {
- /**
- * @var \Doctrine\DBAL\Schema\Index[] $indexes
- */
- $indexes = $table->getIndexes();
- $newIndexes = [];
- foreach ($indexes as $index) {
- if ($index->isPrimary()) {
- // do not rename primary key
- $indexName = $index->getName();
- } else {
- // avoid conflicts in index names
- $indexName = $this->config->getSystemValue('dbtableprefix', 'oc_') . $this->random->generate(13, ISecureRandom::CHAR_LOWER);
- }
- $newIndexes[] = new Index($indexName, $index->getColumns(), $index->isUnique(), $index->isPrimary());
- }
-
- // foreign keys are not supported so we just set it to an empty array
- return new Table($newName, $table->getColumns(), $newIndexes, [], [], $table->getOptions());
- }
-
- /**
* @throws Exception
*/
public function createSchema() {
@@ -261,25 +184,6 @@ class Migrator {
}
/**
- * @param string $sourceName
- * @param string $targetName
- */
- protected function copyTable($sourceName, $targetName) {
- $quotedSource = $this->connection->quoteIdentifier($sourceName);
- $quotedTarget = $this->connection->quoteIdentifier($targetName);
-
- $this->connection->exec('CREATE TABLE ' . $quotedTarget . ' (LIKE ' . $quotedSource . ')');
- $this->connection->exec('INSERT INTO ' . $quotedTarget . ' SELECT * FROM ' . $quotedSource);
- }
-
- /**
- * @param string $name
- */
- protected function dropTable($name) {
- $this->connection->exec('DROP TABLE ' . $this->connection->quoteIdentifier($name));
- }
-
- /**
* @param $statement
* @return string
*/
@@ -303,11 +207,4 @@ class Migrator {
}
$this->dispatcher->dispatch('\OC\DB\Migrator::executeSql', new GenericEvent($sql, [$step + 1, $max]));
}
-
- private function emitCheckStep($tableName, $step, $max) {
- if (is_null($this->dispatcher)) {
- return;
- }
- $this->dispatcher->dispatch('\OC\DB\Migrator::checkTable', new GenericEvent($tableName, [$step + 1, $max]));
- }
}