1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
<?php
namespace Piwik\Db;
trait TransactionalDatabaseStaticTrait
{
private $supportsTransactionLevelForNonLockingReads;
public function setTransactionIsolationLevel(string $level): void
{
static::query("SET SESSION TRANSACTION ISOLATION LEVEL $level");
}
public function getCurrentTransactionIsolationLevelForSession(): string
{
try {
return static::fetchOne('SELECT @@TX_ISOLATION');
} catch (\Exception $e) {
return static::fetchOne('SELECT @@transaction_isolation');
}
}
public function setSupportsTransactionLevelForNonLockingReads(?bool $supports = null): void
{
$this->supportsTransactionLevelForNonLockingReads = $supports;
}
public function getSupportsTransactionLevelForNonLockingReads(): ?bool
{
return $this->supportsTransactionLevelForNonLockingReads;
}
}
|
