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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
|
<?php
/**
* Piwik - free/libre analytics platform
*
* @link https://matomo.org
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*
*/
namespace Piwik\DataAccess;
use Piwik\ArchiveProcessor\ArchivingStatus;
use Piwik\Concurrency\Lock;
use Piwik\Db\AdapterInterface;
use Psr\Log\LoggerInterface;
class ArchivingDbAdapter
{
/**
* @var AdapterInterface|\Zend_Db_Adapter_Abstract
*/
private $wrapped;
/**
* @var Lock
*/
private $archivingLock;
/**
* @var LoggerInterface
*/
private $logger;
/**
* @var int
*/
private $lastReexpireTime = null;
public function __construct($wrapped, Lock $archivingLock = null, LoggerInterface $logger = null)
{
$this->wrapped = $wrapped;
$this->archivingLock = $archivingLock;
$this->logger = $logger;
}
public function __call($name, $arguments)
{
return call_user_func_array([$this->wrapped, $name], $arguments);
}
public function exec($sql)
{
$this->reexpireLock();
$this->logSql($sql);
return call_user_func_array([$this->wrapped, __FUNCTION__], func_get_args());
}
public function query($sql)
{
$this->reexpireLock();
$this->logSql($sql);
return call_user_func_array([$this->wrapped, __FUNCTION__], func_get_args());
}
public function fetchAll($sql)
{
$this->reexpireLock();
$this->logSql($sql);
return call_user_func_array([$this->wrapped, __FUNCTION__], func_get_args());
}
public function fetchRow($sql)
{
$this->reexpireLock();
$this->logSql($sql);
return call_user_func_array([$this->wrapped, __FUNCTION__], func_get_args());
}
public function fetchOne($sql)
{
$this->reexpireLock();
$this->logSql($sql);
return call_user_func_array([$this->wrapped, __FUNCTION__], func_get_args());
}
public function fetchAssoc($sql)
{
$this->reexpireLock();
$this->logSql($sql);
return call_user_func_array([$this->wrapped, __FUNCTION__], func_get_args());
}
private function logSql($sql)
{
// Log on DEBUG level all SQL archiving queries
if ($this->logger) {
$this->logger->debug($sql);
}
}
private function reexpireLock()
{
if ($this->archivingLock) {
$timeBetweenReexpires = ArchivingStatus::DEFAULT_ARCHIVING_TTL / 4;
if ($this->lastReexpireTime + $timeBetweenReexpires < time()) {
$this->archivingLock->reexpireLock();
$this->lastReexpireTime = time();
}
}
}
}
|
