PredicateSet
in package
Predicate set class
Tags
Table of Contents
- $conjunction : string
- Conjunction
- $nextConjunction : string
- Next conjunction
- $predicates : array<string|int, mixed>
- Predicates
- $predicateSets : array<string|int, mixed>
- Nested predicate sets
- $sql : AbstractSql
- SQL object
- __construct() : mixed
- Constructor
- __toString() : string
- Return predicate set string
- add() : PredicateSet
- Add a predicate from a string expression
- addExpressions() : PredicateSet
- Add a predicates from string expressions
- addPredicate() : PredicateSet
- Add predicate
- addPredicates() : PredicateSet
- Add predicates
- addPredicateSet() : PredicateSet
- Add predicate set
- addPredicateSets() : PredicateSet
- Add predicate sets
- and() : PredicateSet
- Add an AND predicate from a string expression
- andNest() : PredicateSet
- Add a nested predicate set with the AND conjunction
- andPredicate() : PredicateSet
- Add AND predicate
- between() : PredicateSet
- Predicate for BETWEEN
- equalTo() : PredicateSet
- Predicate for =
- getConjunction() : string
- Get the conjunction
- getNextConjunction() : string
- Get the next conjunction
- getPredicates() : array<string|int, mixed>
- Get predicates
- getPredicateSets() : array<string|int, mixed>
- Get predicates
- greaterThan() : PredicateSet
- Predicate for >
- greaterThanOrEqualTo() : PredicateSet
- Predicate for >=
- hasPredicates() : bool
- Has predicates
- hasPredicateSets() : bool
- Has predicates
- in() : PredicateSet
- Predicate for IN
- isNotNull() : PredicateSet
- Predicate for IS NOT NULL
- isNull() : PredicateSet
- Predicate for IS NULL
- lessThan() : PredicateSet
- Predicate for <
- lessThanOrEqualTo() : PredicateSet
- Predicate for <=
- like() : PredicateSet
- Predicate for LIKE
- nest() : PredicateSet
- Add a nested predicate set
- notBetween() : PredicateSet
- Predicate for NOT BETWEEN
- notEqualTo() : PredicateSet
- Predicate for !=
- notIn() : PredicateSet
- Predicate for NOT IN
- notLike() : PredicateSet
- Predicate for NOT LIKE
- or() : PredicateSet
- Add an OR predicate from a string expression
- orNest() : PredicateSet
- Add a nested predicate set with the OR conjunction
- orPredicate() : PredicateSet
- Add OR predicate
- render() : string
- Predicate set render method
- setConjunction() : PredicateSet
- Get the conjunction
- setNextConjunction() : PredicateSet
- Get the next conjunction
Properties
$conjunction
Conjunction
protected
string
$conjunction
= null
$nextConjunction
Next conjunction
protected
string
$nextConjunction
= 'AND'
$predicates
Predicates
protected
array<string|int, mixed>
$predicates
= []
$predicateSets
Nested predicate sets
protected
array<string|int, mixed>
$predicateSets
= []
$sql
SQL object
protected
AbstractSql
$sql
= null
Methods
__construct()
Constructor
public
__construct(AbstractSql $sql[, mixed $predicates = null ][, string $conjunction = null ]) : mixed
Instantiate the predicate set object
Parameters
- $sql : AbstractSql
- $predicates : mixed = null
- $conjunction : string = null
Return values
mixed —__toString()
Return predicate set string
public
__toString() : string
Return values
string —add()
Add a predicate from a string expression
public
add(string $expression) : PredicateSet
Parameters
- $expression : string
Return values
PredicateSet —addExpressions()
Add a predicates from string expressions
public
addExpressions(array<string|int, mixed> $expressions) : PredicateSet
Parameters
- $expressions : array<string|int, mixed>
Return values
PredicateSet —addPredicate()
Add predicate
public
addPredicate(AbstractPredicate $predicate) : PredicateSet
Parameters
- $predicate : AbstractPredicate
Return values
PredicateSet —addPredicates()
Add predicates
public
addPredicates(array<string|int, mixed> $predicates) : PredicateSet
Parameters
- $predicates : array<string|int, mixed>
Return values
PredicateSet —addPredicateSet()
Add predicate set
public
addPredicateSet(PredicateSet $predicateSet) : PredicateSet
Parameters
- $predicateSet : PredicateSet
Return values
PredicateSet —addPredicateSets()
Add predicate sets
public
addPredicateSets(array<string|int, mixed> $predicateSets) : PredicateSet
Parameters
- $predicateSets : array<string|int, mixed>
Return values
PredicateSet —and()
Add an AND predicate from a string expression
public
and([string $expression = null ]) : PredicateSet
Parameters
- $expression : string = null
Return values
PredicateSet —andNest()
Add a nested predicate set with the AND conjunction
public
andNest() : PredicateSet
Return values
PredicateSet —andPredicate()
Add AND predicate
public
andPredicate(AbstractPredicate $predicate) : PredicateSet
Parameters
- $predicate : AbstractPredicate
Return values
PredicateSet —between()
Predicate for BETWEEN
public
between(string $column, string $value1, string $value2) : PredicateSet
Parameters
- $column : string
- $value1 : string
- $value2 : string
Return values
PredicateSet —equalTo()
Predicate for =
public
equalTo(string $column, string $value) : PredicateSet
Parameters
- $column : string
- $value : string
Return values
PredicateSet —getConjunction()
Get the conjunction
public
getConjunction() : string
Return values
string —getNextConjunction()
Get the next conjunction
public
getNextConjunction() : string
Return values
string —getPredicates()
Get predicates
public
getPredicates() : array<string|int, mixed>
Return values
array<string|int, mixed> —getPredicateSets()
Get predicates
public
getPredicateSets() : array<string|int, mixed>
Return values
array<string|int, mixed> —greaterThan()
Predicate for >
public
greaterThan(string $column, string $value) : PredicateSet
Parameters
- $column : string
- $value : string
Return values
PredicateSet —greaterThanOrEqualTo()
Predicate for >=
public
greaterThanOrEqualTo(string $column, string $value) : PredicateSet
Parameters
- $column : string
- $value : string
Return values
PredicateSet —hasPredicates()
Has predicates
public
hasPredicates() : bool
Return values
bool —hasPredicateSets()
Has predicates
public
hasPredicateSets() : bool
Return values
bool —in()
Predicate for IN
public
in(string $column, mixed $values) : PredicateSet
Parameters
- $column : string
- $values : mixed
Return values
PredicateSet —isNotNull()
Predicate for IS NOT NULL
public
isNotNull(string $column) : PredicateSet
Parameters
- $column : string
Return values
PredicateSet —isNull()
Predicate for IS NULL
public
isNull(string $column) : PredicateSet
Parameters
- $column : string
Return values
PredicateSet —lessThan()
Predicate for <
public
lessThan(string $column, string $value) : PredicateSet
Parameters
- $column : string
- $value : string
Return values
PredicateSet —lessThanOrEqualTo()
Predicate for <=
public
lessThanOrEqualTo(string $column, string $value) : PredicateSet
Parameters
- $column : string
- $value : string
Return values
PredicateSet —like()
Predicate for LIKE
public
like(string $column, string $value) : PredicateSet
Parameters
- $column : string
- $value : string
Return values
PredicateSet —nest()
Add a nested predicate set
public
nest([string $conjunction = 'AND' ]) : PredicateSet
Parameters
- $conjunction : string = 'AND'
Return values
PredicateSet —notBetween()
Predicate for NOT BETWEEN
public
notBetween(string $column, string $value1, string $value2) : PredicateSet
Parameters
- $column : string
- $value1 : string
- $value2 : string
Return values
PredicateSet —notEqualTo()
Predicate for !=
public
notEqualTo(string $column, string $value) : PredicateSet
Parameters
- $column : string
- $value : string
Return values
PredicateSet —notIn()
Predicate for NOT IN
public
notIn(string $column, mixed $values) : PredicateSet
Parameters
- $column : string
- $values : mixed
Return values
PredicateSet —notLike()
Predicate for NOT LIKE
public
notLike(string $column, string $value) : PredicateSet
Parameters
- $column : string
- $value : string
Return values
PredicateSet —or()
Add an OR predicate from a string expression
public
or([string $expression = null ]) : PredicateSet
Parameters
- $expression : string = null
Return values
PredicateSet —orNest()
Add a nested predicate set with the OR conjunction
public
orNest() : PredicateSet
Return values
PredicateSet —orPredicate()
Add OR predicate
public
orPredicate(AbstractPredicate $predicate) : PredicateSet
Parameters
- $predicate : AbstractPredicate
Return values
PredicateSet —render()
Predicate set render method
public
render() : string
Return values
string —setConjunction()
Get the conjunction
public
setConjunction(string $conjunction) : PredicateSet
Parameters
- $conjunction : string
Return values
PredicateSet —setNextConjunction()
Get the next conjunction
public
setNextConjunction(string $conjunction) : PredicateSet
Parameters
- $conjunction : string