getPreparedQueryBuilder(); $result = $queryBuilder->select('uid', 'explicit_allowdeny')->from(self::TABLE_NAME)->executeQuery(); while ($row = $result->fetchAssociative()) { // Target is a comma separated list of colon seperated "tableName:fieldName:valueName" // If there are four colon fields, the update should remove the last one. $tuples = GeneralUtility::trimExplode(',', (string)$row['explicit_allowdeny'], true); foreach ($tuples as $tuple) { if (count(GeneralUtility::trimExplode(':', $tuple, true)) > 3) { $needsUpdate = true; $result->free(); break 2; } } } return $needsUpdate; } public function executeUpdate(): bool { $connection = $this->getConnectionPool()->getConnectionForTable(self::TABLE_NAME); $queryBuilder = $this->getPreparedQueryBuilder(); $result = $queryBuilder->select('uid', 'explicit_allowdeny')->from(self::TABLE_NAME)->executeQuery(); $success = true; while ($row = $result->fetchAssociative()) { $tuples = GeneralUtility::trimExplode(',', (string)$row['explicit_allowdeny'], true); $newTuples = []; $updateNeeded = false; foreach ($tuples as $tuple) { $explodedTuples = GeneralUtility::trimExplode(':', $tuple, true); if (count($explodedTuples) > 3) { $updateNeeded = true; $newTupleString = implode(':', array_chunk($explodedTuples, 3, true)[0]); if ($explodedTuples[3] === 'DENY') { // We can't migrate 'explicitDeny' values. Fully remove that tuple and add an output note. $this->output->writeln( 'Access rights setup "Explicitly allow field values" of be_groups row uid "' . $row['uid'] . '"' . ' had explicit DENY set for the table/field/value combination "' . $newTupleString . '".' . ' This is not allowed anymore. This be_groups row needs a manual update to fix access rights.' ); $success = false; continue; } $newTuples[] = $newTupleString; } else { $newTuples[] = $tuple; } } if ($updateNeeded) { $connection->update( self::TABLE_NAME, ['explicit_allowdeny' => implode(',', $newTuples)], ['uid' => (int)$row['uid']], ['explicit_allowdeny' => Connection::PARAM_STR] ); } } return $success; } public function setOutput(OutputInterface $output): void { $this->output = $output; } private function getPreparedQueryBuilder(): QueryBuilder { $queryBuilder = $this->getConnectionPool()->getQueryBuilderForTable(self::TABLE_NAME); $queryBuilder->getRestrictions()->removeAll(); return $queryBuilder->from(self::TABLE_NAME); } private function getConnectionPool(): ConnectionPool { return GeneralUtility::makeInstance(ConnectionPool::class); } }