Neos\Flow\Persistence\Doctrine\Migrations\Version20150913173832::down PHP Метод

down() публичный Метод

public down ( Doctrine\DBAL\Schema\Schema $schema ) : void
$schema Doctrine\DBAL\Schema\Schema
Результат void
    public function down(Schema $schema)
    {
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql");
        $this->addSql("ALTER TABLE typo3_media_domain_model_thumbnail ADD maximumwidth INT DEFAULT NULL, ADD maximumheight INT DEFAULT NULL, ADD ratiomode VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, ADD allowupscaling TINYINT(1) DEFAULT NULL");
        $thumbnailResult = $this->connection->executeQuery('SELECT * FROM typo3_media_domain_model_thumbnail');
        while ($thumbnailInfo = $thumbnailResult->fetch(\PDO::FETCH_ASSOC)) {
            $configuration = json_decode($thumbnailInfo['configuration'], true);
            $maximumWidth = isset($configuration['maximumWidth']) ? (int) $configuration['maximumWidth'] : null;
            $maximumWidth = $maximumWidth === 0 ? null : $maximumWidth;
            $maximumHeight = isset($configuration['maximumHeight']) ? (int) $configuration['maximumHeight'] : null;
            $maximumHeight = $maximumHeight === 0 ? null : $maximumHeight;
            $ratioMode = isset($configuration['ratioMode']) ? $configuration['ratioMode'] : null;
            $allowUpScaling = isset($configuration['allowUpScaling']) ? $configuration['allowUpScaling'] : null;
            $allowUpScaling = $allowUpScaling ? 1 : 0;
            $types = [\PDO::PARAM_NULL];
            $this->addSql("UPDATE typo3_media_domain_model_thumbnail SET maximumwidth = ?, maximumheight = ?, ratiomode = ?, allowupscaling = ?  WHERE persistence_object_identifier = ?", [$maximumWidth, $maximumHeight, $ratioMode, $allowUpScaling, $thumbnailInfo['persistence_object_identifier']], $types);
        }
        $this->addSql("ALTER TABLE typo3_media_domain_model_thumbnail DROP INDEX originalasset_configurationhash");
        $this->addSql("ALTER TABLE typo3_media_domain_model_thumbnail DROP configuration, DROP configurationhash");
    }
Version20150913173832