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
|
<?php
/**
* Copyright 2007 Maintainable Software, LLC
* Copyright 2008-2017 Horde LLC (http://www.horde.org/)
*
* See the enclosed file LICENSE for license information (BSD). If you
* did not receive this file, see http://www.horde.org/licenses/bsd.
*
* @author Mike Naberezny <mike@maintainable.com>
* @author Derek DeVries <derek@maintainable.com>
* @author Chuck Hagenbuch <chuck@horde.org>
* @category Horde
* @license http://www.horde.org/licenses/bsd
* @package Db
* @subpackage Adapter
*/
/**
*
*
* @author Mike Naberezny <mike@maintainable.com>
* @author Derek DeVries <derek@maintainable.com>
* @author Chuck Hagenbuch <chuck@horde.org>
* @category Horde
* @copyright 2007 Maintainable Software, LLC
* @copyright 2008-2017 Horde LLC
* @license http://www.horde.org/licenses/bsd
* @package Db
* @subpackage Adapter
*/
class Horde_Db_Adapter_Sqlite_Column extends Horde_Db_Adapter_Base_Column
{
public function extractDefault($default)
{
$default = parent::extractDefault($default);
if ($this->isText()) {
$default = $this->_unquote($default);
}
return $default;
}
/*##########################################################################
# Type Juggling
##########################################################################*/
public function binaryToString($value)
{
return str_replace(array('%00', '%25'), array("\0", '%'), is_null($value) ? "" : $value);
}
/**
* @param mixed $value
* @return boolean
*/
public function valueToBoolean($value)
{
if ($value == '"t"' || $value == "'t'") {
return true;
} elseif ($value == '""' || $value == "''") {
return null;
} else {
return parent::valueToBoolean($value);
}
}
/*##########################################################################
# Protected
##########################################################################*/
/**
* Unquote a string value
*
* @return string
*/
protected function _unquote($string)
{
$first = substr(is_null($string) ? "" : $string, 0, 1);
if ($first == "'" || $first == '"') {
$string = substr($string, 1);
if (substr($string, -1) == $first) {
$string = substr($string, 0, -1);
}
$string = str_replace("$first$first", $first, $string);
}
return $string;
}
}
|
