Properties

$predicates

$predicates : array

Predicates array

Type

array

$nested

$nested : array

Nested predicates

Type

array

$operators

$operators : array

Allowed operators

Type

array

Methods

__construct()

__construct(\Pop\Db\Sql  $sql) : \Pop\Db\Sql\Predicate

Constructor

Instantiate the predicate collection object.

Parameters

\Pop\Db\Sql $sql

Returns

\Pop\Db\Sql\Predicate

add()

add(mixed  $predicate) : \Pop\Db\Sql\Predicate

Add a predicate from a string

Parameters

mixed $predicate

Returns

\Pop\Db\Sql\Predicate

hasNest()

hasNest(integer  $i = null) : boolean

Determine if it has a nested predicate branch

Parameters

integer $i

Returns

boolean

getNest()

getNest(integer  $i) : mixed

Get a nested predicate

Parameters

integer $i

Returns

mixed

equalTo()

equalTo(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for =

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

notEqualTo()

notEqualTo(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for !=

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

greaterThan()

greaterThan(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for >

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

greaterThanOrEqualTo()

greaterThanOrEqualTo(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for >=

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

lessThan()

lessThan(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for <

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

lessThanOrEqualTo()

lessThanOrEqualTo(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for <=

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

like()

like(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for LIKE

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

notLike()

notLike(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for NOT LIKE

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

between()

between(string  $column, string  $value1, string  $value2, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for BETWEEN

Parameters

string $column
string $value1
string $value2
string $combine

Returns

\Pop\Db\Sql\Predicate

notBetween()

notBetween(string  $column, string  $value1, string  $value2, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for NOT BETWEEN

Parameters

string $column
string $value1
string $value2
string $combine

Returns

\Pop\Db\Sql\Predicate

in()

in(string  $column, mixed  $values, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for IN

Parameters

string $column
mixed $values
string $combine

Returns

\Pop\Db\Sql\Predicate

notIn()

notIn(string  $column, mixed  $values, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for NOT IN

Parameters

string $column
mixed $values
string $combine

Returns

\Pop\Db\Sql\Predicate

isNull()

isNull(string  $column, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for IS NULL

Parameters

string $column
string $combine

Returns

\Pop\Db\Sql\Predicate

isNotNull()

isNotNull(string  $column, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for IS NOT NULL

Parameters

string $column
string $combine

Returns

\Pop\Db\Sql\Predicate

render()

render(integer  $count = 1) : string

Predicate render method

Parameters

integer $count

Returns

string

__toString()

__toString() : string

Predicate return string

Returns

string

parse()

parse(string  $predicate) : array

Parse a predicate string

Parameters

string $predicate

Returns

array