protected function migrateAccountRolesUp()
    {
        if (!$this->sm->tablesExist(['typo3_flow_security_account_roles_join', 'typo3_flow_security_policy_role'])) {
            return;
        }
        $accountsWithRoles = array();

        $accountRolesResult = $this->connection->executeQuery('SELECT j.flow_security_account, r.identifier FROM typo3_flow_security_account_roles_join as j LEFT JOIN typo3_flow_security_policy_role AS r ON j.flow_policy_role = r.identifier');
        while ($accountIdentifierAndRole = $accountRolesResult->fetch(\PDO::FETCH_ASSOC)) {
            $accountIdentifier = $accountIdentifierAndRole['flow_security_account'];
            $accountsWithRoles[$accountIdentifier][] = $accountIdentifierAndRole['identifier'];
        }

        foreach ($accountsWithRoles as $accountIdentifier => $roles) {
            $this->addSql("UPDATE typo3_flow_security_account SET roleidentifiers = " . $this->connection->quote(implode(',', $roles)) . " WHERE persistence_object_identifier = " . $this->connection->quote($accountIdentifier));
        }
    }
protected function migrateAccountRolesUp()
    {
        if (!$this->sm->tablesExist(['typo3_flow_security_account_roles_join', 'typo3_flow_security_policy_role'])) {
            return;
        }
        $accountsWithRoles = array();

        $accountRolesResult = $this->connection->executeQuery('SELECT j.flow_security_account, r.identifier FROM typo3_flow_security_account_roles_join as j LEFT JOIN typo3_flow_security_policy_role AS r ON j.flow_policy_role = r.identifier');
        while ($accountIdentifierAndRole = $accountRolesResult->fetch(\PDO::FETCH_ASSOC)) {
            $accountIdentifier = $accountIdentifierAndRole['flow_security_account'];
            $accountsWithRoles[$accountIdentifier][] = $accountIdentifierAndRole['identifier'];
        }

        foreach ($accountsWithRoles as $accountIdentifier => $roles) {
            $this->addSql("UPDATE typo3_flow_security_account SET roleidentifiers = " . $this->connection->quote(implode(',', $roles)) . " WHERE persistence_object_identifier = " . $this->connection->quote($accountIdentifier));
        }
    }
protected function migrateAccountRolesUp ( ) { if ( ! $ this -> sm -> tablesExist ( [ 'typo3_flow_security_account_roles_join' , 'typo3_flow_security_policy_role' ] ) ) { return ; } $ accountsWithRoles = array ( ) ; $ accountRolesResult = $ this -> connection -> executeQuery ( 'SELECT j.flow_security_account, r.identifier FROM typo3_flow_security_account_roles_join as j LEFT JOIN typo3_flow_security_policy_role AS r ON j.flow_policy_role = r.identifier' ) ; while ( $ accountIdentifierAndRole = $ accountRolesResult -> fetch ( \ PDO :: FETCH_ASSOC ) ) { $ accountIdentifier = $ accountIdentifierAndRole [ 'flow_security_account' ] ; $ accountsWithRoles [ $ accountIdentifier ] [ ] = $ accountIdentifierAndRole [ 'identifier' ] ; } foreach ( $ accountsWithRoles as $ accountIdentifier => $ roles ) { $ this -> addSql ( "UPDATE typo3_flow_security_account SET roleidentifiers = " . $ this -> connection -> quote ( implode ( ',' , $ roles ) ) . " WHERE persistence_object_identifier = " . $ this -> connection -> quote ( $ accountIdentifier ) ) ; } }
Generate SQL statements to migrate accounts up to embedded roles.

@return void
Generate SQL statements to migrate accounts up to embedded roles .