* * @author Côme Chilliet * * @license GNU AGPL version 3 or any later version * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as * published by the Free Software Foundation, either version 3 of the * License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see . * */ namespace OCA\Settings\SetupChecks; use Doctrine\DBAL\Exception; use Doctrine\DBAL\TransactionIsolationLevel; use OC\DB\Connection; use OCP\IDBConnection; use OCP\IL10N; use OCP\IURLGenerator; use OCP\SetupCheck\ISetupCheck; use OCP\SetupCheck\SetupResult; class TransactionIsolation implements ISetupCheck { public function __construct( private IL10N $l10n, private IURLGenerator $urlGenerator, private IDBConnection $connection, private Connection $db, ) { } public function getName(): string { return $this->l10n->t('Database transaction isolation level'); } public function getCategory(): string { return 'database'; } public function run(): SetupResult { try { if ($this->connection->getDatabaseProvider() === IDBConnection::PLATFORM_SQLITE) { return SetupResult::success(); } if ($this->db->getTransactionIsolation() === TransactionIsolationLevel::READ_COMMITTED) { return SetupResult::success('Read committed'); } else { return SetupResult::error( $this->l10n->t('Your database does not run with "READ COMMITTED" transaction isolation level. This can cause problems when multiple actions are executed in parallel.'), $this->urlGenerator->linkToDocs('admin-db-transaction') ); } } catch (Exception $e) { return SetupResult::warning( $this->l10n->t('Was not able to get transaction isolation level: %s', $e->getMessage()) ); } } }