Neos\Flow\Persistence\Doctrine\Migrations\Version20151117125552::up PHP Метод

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

public up ( Doctrine\DBAL\Schema\Schema $schema ) : void
$schema Doctrine\DBAL\Schema\Schema
Результат void
    public function up(Schema $schema)
    {
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != "postgresql");
        $workspacesQuery = $this->connection->executeQuery('SELECT name FROM typo3_typo3cr_domain_model_workspace t0 WHERE t0.name LIKE \'user-%\' AND t0.owner IS NULL');
        while ($workspaceRecord = $workspacesQuery->fetch(\PDO::FETCH_ASSOC)) {
            $username = substr($workspaceRecord['name'], 5);
            $accountQuery = $this->connection->executeQuery('SELECT persistence_object_identifier FROM typo3_flow_security_account t0 WHERE t0.accountidentifier = \'' . $username . '\' AND t0.authenticationprovidername = \'Typo3BackendProvider\'');
            $accountRecord = $accountQuery->fetch(\PDO::FETCH_ASSOC);
            $partyQuery = $this->connection->executeQuery('SELECT party_abstractparty FROM typo3_party_domain_model_abstractparty_accounts_join t0 WHERE t0.flow_security_account = \'' . $accountRecord['persistence_object_identifier'] . '\'');
            $partyRecord = $partyQuery->fetch(\PDO::FETCH_ASSOC);
            $this->addSql('UPDATE typo3_typo3cr_domain_model_workspace SET owner = \'' . $partyRecord['party_abstractparty'] . '\' WHERE name = \'user-' . $username . '\'');
        }
    }
Version20151117125552