PHP Class Pop\Db\Sql\Predicate

Author: Nick Sagona, III ([email protected])
Afficher le fichier Open project: nicksagona/PopPHP Class Usage Examples

Protected Properties

Свойство Type Description
$nested array Nested predicates
$predicates array Predicates array
$sql Pop\Db\Sql SQL object

Méthodes publiques

Méthode Description
__construct ( Sql $sql ) : Predicate Constructor
__toString ( ) : string Predicate return string
between ( string $column, string $value1, string $value2, string $combine = 'AND' ) : Predicate Predicate for BETWEEN
equalTo ( string $column, string $value, string $combine = 'AND' ) : Predicate Predicate for =
getNest ( integer $i ) : mixed Get a nested predicate
greaterThan ( string $column, string $value, string $combine = 'AND' ) : Predicate Predicate for >
greaterThanOrEqualTo ( string $column, string $value, string $combine = 'AND' ) : Predicate Predicate for >=
hasNest ( integer $i = null ) : boolean Determine if it has a nested predicate branch
in ( string $column, mixed $values, string $combine = 'AND' ) : Predicate Predicate for IN
isNotNull ( string $column, string $combine = 'AND' ) : Predicate Predicate for IS NOT NULL
isNull ( string $column, string $combine = 'AND' ) : Predicate Predicate for IS NULL
lessThan ( string $column, string $value, string $combine = 'AND' ) : Predicate Predicate for <
lessThanOrEqualTo ( string $column, string $value, string $combine = 'AND' ) : Predicate Predicate for <=
like ( string $column, string $value, string $combine = 'AND' ) : Predicate Predicate for LIKE
nest ( ) : Predicate Add a nested predicate
notBetween ( string $column, string $value1, string $value2, string $combine = 'AND' ) : Predicate Predicate for NOT BETWEEN
notEqualTo ( string $column, string $value, string $combine = 'AND' ) : Predicate Predicate for !=
notIn ( string $column, mixed $values, string $combine = 'AND' ) : Predicate Predicate for NOT IN
notLike ( string $column, string $value, string $combine = 'AND' ) : Predicate Predicate for NOT LIKE
render ( integer $count = 1 ) : string Predicate render method

Method Details

__construct() public méthode

Instantiate the predicate collection object.
public __construct ( Sql $sql ) : Predicate
$sql Pop\Db\Sql
Résultat Predicate

__toString() public méthode

Predicate return string
public __toString ( ) : string
Résultat string

between() public méthode

Predicate for BETWEEN
public between ( string $column, string $value1, string $value2, string $combine = 'AND' ) : Predicate
$column string
$value1 string
$value2 string
$combine string
Résultat Predicate

equalTo() public méthode

Predicate for =
public equalTo ( string $column, string $value, string $combine = 'AND' ) : Predicate
$column string
$value string
$combine string
Résultat Predicate

getNest() public méthode

Get a nested predicate
public getNest ( integer $i ) : mixed
$i integer
Résultat mixed

greaterThan() public méthode

Predicate for >
public greaterThan ( string $column, string $value, string $combine = 'AND' ) : Predicate
$column string
$value string
$combine string
Résultat Predicate

greaterThanOrEqualTo() public méthode

Predicate for >=
public greaterThanOrEqualTo ( string $column, string $value, string $combine = 'AND' ) : Predicate
$column string
$value string
$combine string
Résultat Predicate

hasNest() public méthode

Determine if it has a nested predicate branch
public hasNest ( integer $i = null ) : boolean
$i integer
Résultat boolean

in() public méthode

Predicate for IN
public in ( string $column, mixed $values, string $combine = 'AND' ) : Predicate
$column string
$values mixed
$combine string
Résultat Predicate

isNotNull() public méthode

Predicate for IS NOT NULL
public isNotNull ( string $column, string $combine = 'AND' ) : Predicate
$column string
$combine string
Résultat Predicate

isNull() public méthode

Predicate for IS NULL
public isNull ( string $column, string $combine = 'AND' ) : Predicate
$column string
$combine string
Résultat Predicate

lessThan() public méthode

Predicate for <
public lessThan ( string $column, string $value, string $combine = 'AND' ) : Predicate
$column string
$value string
$combine string
Résultat Predicate

lessThanOrEqualTo() public méthode

Predicate for <=
public lessThanOrEqualTo ( string $column, string $value, string $combine = 'AND' ) : Predicate
$column string
$value string
$combine string
Résultat Predicate

like() public méthode

Predicate for LIKE
public like ( string $column, string $value, string $combine = 'AND' ) : Predicate
$column string
$value string
$combine string
Résultat Predicate

nest() public méthode

Add a nested predicate
public nest ( ) : Predicate
Résultat Predicate

notBetween() public méthode

Predicate for NOT BETWEEN
public notBetween ( string $column, string $value1, string $value2, string $combine = 'AND' ) : Predicate
$column string
$value1 string
$value2 string
$combine string
Résultat Predicate

notEqualTo() public méthode

Predicate for !=
public notEqualTo ( string $column, string $value, string $combine = 'AND' ) : Predicate
$column string
$value string
$combine string
Résultat Predicate

notIn() public méthode

Predicate for NOT IN
public notIn ( string $column, mixed $values, string $combine = 'AND' ) : Predicate
$column string
$values mixed
$combine string
Résultat Predicate

notLike() public méthode

Predicate for NOT LIKE
public notLike ( string $column, string $value, string $combine = 'AND' ) : Predicate
$column string
$value string
$combine string
Résultat Predicate

render() public méthode

Predicate render method
public render ( integer $count = 1 ) : string
$count integer
Résultat string

Property Details

$nested protected_oe property

Nested predicates
protected array $nested
Résultat array

$predicates protected_oe property

Predicates array
protected array $predicates
Résultat array

$sql protected_oe property

SQL object
protected Sql,Pop\Db $sql
Résultat Pop\Db\Sql