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
<?php
/**
* Zend Framework (http://framework.zend.com/)
*
* @link http://github.com/zendframework/zf2 for the canonical source repository
* @copyright Copyright (c) 2005-2016 Zend Technologies USA Inc. (http://www.zend.com)
* @license http://framework.zend.com/license/new-bsd New BSD License
*/
namespace Zend\Db\Sql\Predicate;
use Zend\Db\Sql\AbstractExpression;
class IsNull extends AbstractExpression implements PredicateInterface
{
/**
* @var string
*/
protected $specification = '%1$s IS NULL';
/**
* @var
*/
protected $identifier;
/**
* Constructor
*
* @param string $identifier
*/
public function __construct($identifier = null)
{
if ($identifier) {
$this->setIdentifier($identifier);
}
}
/**
* Set identifier for comparison
*
* @param string $identifier
* @return self Provides a fluent interface
*/
public function setIdentifier($identifier)
{
$this->identifier = $identifier;
return $this;
}
/**
* Get identifier of comparison
*
* @return null|string
*/
public function getIdentifier()
{
return $this->identifier;
}
/**
* Set specification string to use in forming SQL predicate
*
* @param string $specification
* @return self Provides a fluent interface
*/
public function setSpecification($specification)
{
$this->specification = $specification;
return $this;
}
/**
* Get specification string to use in forming SQL predicate
*
* @return string
*/
public function getSpecification()
{
return $this->specification;
}
/**
* Get parts for where statement
*
* @return array
*/
public function getExpressionData()
{
$identifier = $this->normalizeArgument($this->identifier, self::TYPE_IDENTIFIER);
return [[
$this->getSpecification(),
[$identifier[0]],
[$identifier[1]],
]];
}
}