قرینه از
https://github.com/matomo-org/matomo.git
synced 2025-08-24 16:07:37 +00:00
f7b863082c
* Add supported read isolation level to schema interface * Fix tests * Rename function and deprecate old one * Rename function and move core usage away from deprecated method * Add deprecation notice to changelog * Add test for deprecated method --------- Co-authored-by: Stefan Giehl <stefan@matomo.org>
66 خطوط
1.8 KiB
PHP
66 خطوط
1.8 KiB
PHP
<?php
|
|
|
|
/**
|
|
* Matomo - free/libre analytics platform
|
|
*
|
|
* @link https://matomo.org
|
|
* @license https://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
|
|
*/
|
|
|
|
namespace Piwik\Tests\Integration\Db;
|
|
|
|
use Piwik\Db;
|
|
use Piwik\Db\Schema;
|
|
use Piwik\Db\TransactionLevel;
|
|
use Piwik\Tests\Framework\TestCase\IntegrationTestCase;
|
|
|
|
/**
|
|
* @group TransactionLevelTest
|
|
* @group TransactionLevel
|
|
* @group Plugins
|
|
*/
|
|
class TransactionLevelTest extends IntegrationTestCase
|
|
{
|
|
/**
|
|
* @var TransactionLevel
|
|
*/
|
|
private $level;
|
|
|
|
/**
|
|
* @var \Piwik\Tracker\Db|\Piwik\Db\AdapterInterface|\Piwik\Db $db
|
|
*/
|
|
private $db;
|
|
|
|
public function setUp(): void
|
|
{
|
|
parent::setUp();
|
|
$this->db = Db::get();
|
|
$this->level = new TransactionLevel($this->db);
|
|
}
|
|
|
|
public function testCanLikelySetTransactionLevel()
|
|
{
|
|
$this->assertTrue($this->level->canLikelySetTransactionLevel());
|
|
}
|
|
|
|
public function testSetTransactionLevelForNonLockingReadsRestorePreviousStatus()
|
|
{
|
|
// mysql 8.0 using transaction_isolation
|
|
$isolation = $this->db->fetchOne("SHOW GLOBAL VARIABLES LIKE 't%_isolation'");
|
|
$isolation = "@@" . $isolation;
|
|
|
|
$value = $this->db->fetchOne('SELECT ' . $isolation);
|
|
$this->assertSame('REPEATABLE-READ', $value);
|
|
|
|
$this->level->setTransactionLevelForNonLockingReads();
|
|
$value = $this->db->fetchOne('SELECT ' . $isolation);
|
|
|
|
$expectedIsolation = str_replace(' ', '-', Schema::getInstance()->getSupportedReadIsolationTransactionLevel());
|
|
$this->assertSame($expectedIsolation, $value);
|
|
$this->level->restorePreviousStatus();
|
|
|
|
$value = $this->db->fetchOne('SELECT ' . $isolation);
|
|
$this->assertSame('REPEATABLE-READ', $value);
|
|
}
|
|
}
|