blob: 573f946100f6e794d5b52a1ec3833d38eb773188 (
plain)
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
|
<?php
namespace Icinga\Module\Director\Web\Table;
use Zend_Db_Expr as Expr;
trait DbHelper
{
public function dbHexFunc($column)
{
if ($this->isPgsql()) {
return sprintf("LOWER(ENCODE(%s, 'hex'))", $column);
} else {
return sprintf("LOWER(HEX(%s))", $column);
}
}
public function quoteBinary($binary)
{
if ($binary === '') {
return '';
}
if (is_array($binary)) {
return array_map([$this, 'quoteBinary'], $binary);
}
if ($this->isPgsql()) {
return new Expr("'\\x" . bin2hex($binary) . "'");
}
return new Expr('0x' . bin2hex($binary));
}
public function isPgsql()
{
return $this->db() instanceof \Zend_Db_Adapter_Pdo_Pgsql;
}
public function isMysql()
{
return $this->db() instanceof \Zend_Db_Adapter_Pdo_Mysql;
}
public function wantBinaryValue($value)
{
if (is_resource($value)) {
return stream_get_contents($value);
}
return $value;
}
public function getChecksum($checksum)
{
return bin2hex($this->wantBinaryValue($checksum));
}
public function getShortChecksum($checksum)
{
if ($checksum === null) {
return null;
}
return substr($this->getChecksum($checksum), 0, 7);
}
}
|
