class Selection implements Iterator, IRowContainer, ArrayAccess, Countable

Filtered table representation.

Selection is based on the great library NotORM http://www.notorm.com written by Jakub Vrana.

Properties

protected $explorer
protected $context

back compatibility

protected $conventions
protected $cache
protected $sqlBuilder
protected $name

table name

protected string|string[]|null $primary
protected $primarySequence

primary column sequence name, false for autodetection

protected ActiveRow[]|null $rows
protected ActiveRow[]|null $data
protected $dataRefreshed
protected $globalRefCache

cache array of Selection and GroupedSelection prototypes

protected $refCache
protected $generalCacheKey
protected $specificCacheKey
protected $aggregation

of [conditions => [key => ActiveRow]]; used by GroupedSelection

protected $accessedColumns
protected $previousAccessedColumns
protected $observeCache

should instance observe accessed columns caching

protected $keys

of primary key values

Methods

__construct(Explorer $explorer, Conventions $conventions, string $tableName, Storage|null $cacheStorage = null)

Creates filtered table representation.

__destruct()

No description

__clone()

No description

string
getName()

No description

string|array|null
getPrimary(bool $throw = true)

No description

string|null
getPrimarySequence()

No description

setPrimarySequence(string $sequence)

No description

string
getSql()

No description

array|bool
getPreviousAccessedColumns()

Loads cache of previous accessed columns and returns it.

getSqlBuilder()

No description

ActiveRow|null
get(mixed $key)

Returns row specified by primary key.

ActiveRow|null
fetch()

Fetches single row object.

mixed
fetchField(string|null $column = null) deprecated

Fetches single field.

array
fetchPairs(string|int|null $key = null, string|int|null $value = null)

Fetches all rows as associative array.

array
fetchAll()

Fetches all rows.

array
fetchAssoc(string $path)

Fetches all rows and returns associative tree.

select(string $columns, ...$params)

Adds select clause, more calls appends to the end.

wherePrimary(mixed $key)

Adds condition for primary key.

where(string|array $condition, ...$params)

Adds where condition, more calls appends with AND.

joinWhere(string $tableChain, string $condition, ...$params)

Adds ON condition when joining specified table, more calls appends with AND.

void
condition(string|array $condition, array $params, string|null $tableChain = null)

Adds condition, more calls appends with AND.

whereOr(array $parameters)

Adds where condition using the OR operator between parameters.

order(string $columns, ...$params)

Adds order clause, more calls appends to the end.

limit(int|null $limit, int|null $offset = null)

Sets limit clause, more calls rewrite old values.

page(int $page, int $itemsPerPage, $numOfPages = null)

Sets offset using page number, more calls rewrite old values.

group(string $columns, ...$params)

Sets group clause, more calls rewrite old value.

having(string $having, ...$params)

Sets having clause, more calls rewrite old value.

alias(string $tableChain, string $alias)

Aliases table. Example ':book:book_tag.tag', 'tg'

mixed
aggregation(string $function, string|null $groupFunction = null)

Executes aggregation function.

int
count(string|null $column = null)

Counts number of rows. If column is not provided returns count of result rows, otherwise runs new sql counting query.

mixed
min(string $column)

Returns minimum value from a column.

mixed
max(string $column)

Returns maximum value from a column.

mixed
sum(string $column)

Returns sum of values in a column.

void
execute()

No description

createRow(array $row)

No description

createSelectionInstance(string|null $table = null)

No description

createGroupedSelectionInstance(string $table, string $column)

No description

query(string $query)

No description

void
emptyResultSet(bool $clearCache = true, bool $deleteReferencedCache = true)

No description

void
saveCacheState()

No description

getRefTable($refPath)

Returns Selection parent for caching.

void
loadRefCache()

Loads refCache references

string
getGeneralCacheKey()

Returns general cache key independent on query parameters or sql limit Used e.g. for previously accessed columns caching

string
getSpecificCacheKey()

Returns object specific cache key dependent on query parameters Used e.g. for reference memory caching

bool
accessColumn(string|null $key, bool $selectColumn = true)

No description

void
removeAccessColumn(string $key)

No description

bool
getDataRefreshed()

Returns if selection requeried for more columns.

ActiveRow|array|int|bool
insert(iterable $data)

Inserts row in a table. Returns ActiveRow or number of affected rows for Selection or table without primary key.

int
update(iterable $data)

Updates all rows in result set.

int
delete()

Deletes all rows in result set.

ActiveRow|false|null
getReferencedTable(ActiveRow $row, string|null $table, string|null $column = null)

Returns referenced row.

GroupedSelection|null
getReferencingTable(string $table, string|null $column = null, int|string|null $active = null)

Returns referencing rows.

void
rewind()

No description

ActiveRow|false
current()

No description

string|int
key()

No description

void
next()

No description

bool
valid()

No description

void
offsetSet(string $key, ActiveRow $value)

Mimic row.

ActiveRow|null
offsetGet(string $key)

Returns specified row.

bool
offsetExists(string $key)

Tests if row exists.

void
offsetUnset(string $key)

Removes row from result set.

Details

at line 70
__construct(Explorer $explorer, Conventions $conventions, string $tableName, Storage|null $cacheStorage = null)

Creates filtered table representation.

Parameters

Explorer $explorer
Conventions $conventions
string $tableName
Storage|null $cacheStorage

at line 89
__destruct()

No description

at line 95
__clone()

No description

at line 101
string getName()

No description

Return Value

string

at line 110
string|array|null getPrimary(bool $throw = true)

No description

Parameters

bool $throw

Return Value

string|array|null

at line 120
string|null getPrimarySequence()

No description

Return Value

string|null

at line 130
Selection setPrimarySequence(string $sequence)

No description

Parameters

string $sequence

Return Value

Selection

at line 137
string getSql()

No description

Return Value

string

at line 147
array|bool getPreviousAccessedColumns()

internal  
 

Loads cache of previous accessed columns and returns it.

Return Value

array|bool

at line 161
SqlBuilder getSqlBuilder()

internal  
 

No description

Return Value

SqlBuilder

at line 173
ActiveRow|null get(mixed $key)

Returns row specified by primary key.

Parameters

mixed $key

Return Value

ActiveRow|null

at line 183
ActiveRow|null fetch()

Fetches single row object.

Return Value

ActiveRow|null

at line 196
mixed fetchField(string|null $column = null) deprecated

deprecated

Fetches single field.

Parameters

string|null $column

Return Value

mixed

at line 214
array fetchPairs(string|int|null $key = null, string|int|null $value = null)

Fetches all rows as associative array.

Parameters

string|int|null $key
string|int|null $value

Return Value

array

at line 224
array fetchAll()

Fetches all rows.

Return Value

array

at line 233
array fetchAssoc(string $path)

Fetches all rows and returns associative tree.

Parameters

string $path

Return Value

array

at line 247
Selection select(string $columns, ...$params)

Adds select clause, more calls appends to the end.

Parameters

string $columns

for example "column, MD5(column) AS column_md5"

...$params

Return Value

Selection

at line 258
Selection wherePrimary(mixed $key)

Adds condition for primary key.

Parameters

mixed $key

Return Value

Selection

at line 282
Selection where(string|array $condition, ...$params)

Adds where condition, more calls appends with AND.

Parameters

string|array $condition

possibly containing ?

...$params

Return Value

Selection

at line 294
Selection joinWhere(string $tableChain, string $condition, ...$params)

Adds ON condition when joining specified table, more calls appends with AND.

Parameters

string $tableChain

table chain or table alias for which you need additional left join condition

string $condition

possibly containing ?

...$params

Return Value

Selection

at line 305
protected void condition(string|array $condition, array $params, string|null $tableChain = null)

Adds condition, more calls appends with AND.

Parameters

string|array $condition

possibly containing ?

array $params
string|null $tableChain

Return Value

void

at line 330
Selection whereOr(array $parameters)

Adds where condition using the OR operator between parameters.

More calls appends with AND.

Parameters

array $parameters

['column1' => 1, 'column2 > ?' => 2, 'full condition']

Return Value

Selection

Exceptions

InvalidArgumentException

at line 364
Selection order(string $columns, ...$params)

Adds order clause, more calls appends to the end.

Parameters

string $columns

for example 'column1, column2 DESC'

...$params

Return Value

Selection

at line 375
Selection limit(int|null $limit, int|null $offset = null)

Sets limit clause, more calls rewrite old values.

Parameters

int|null $limit
int|null $offset

Return Value

Selection

at line 386
Selection page(int $page, int $itemsPerPage, $numOfPages = null)

Sets offset using page number, more calls rewrite old values.

Parameters

int $page
int $itemsPerPage
$numOfPages

Return Value

Selection

at line 403
Selection group(string $columns, ...$params)

Sets group clause, more calls rewrite old value.

Parameters

string $columns
...$params

Return Value

Selection

at line 414
Selection having(string $having, ...$params)

Sets having clause, more calls rewrite old value.

Parameters

string $having
...$params

Return Value

Selection

at line 425
Selection alias(string $tableChain, string $alias)

Aliases table. Example ':book:book_tag.tag', 'tg'

Parameters

string $tableChain
string $alias

Return Value

Selection

at line 439
mixed aggregation(string $function, string|null $groupFunction = null)

Executes aggregation function.

Parameters

string $function

select call in "FUNCTION(column)" format

string|null $groupFunction

Return Value

mixed

at line 460
int count(string|null $column = null)

Counts number of rows. If column is not provided returns count of result rows, otherwise runs new sql counting query.

Parameters

string|null $column

Return Value

int

at line 474
mixed min(string $column)

Returns minimum value from a column.

Parameters

string $column

Return Value

mixed

at line 483
mixed max(string $column)

Returns maximum value from a column.

Parameters

string $column

Return Value

mixed

at line 492
mixed sum(string $column)

Returns sum of values in a column.

Parameters

string $column

Return Value

mixed

at line 501
protected void execute()

No description

Return Value

void

at line 547
protected ActiveRow createRow(array $row)

No description

Parameters

array $row

Return Value

ActiveRow

at line 553
Selection createSelectionInstance(string|null $table = null)

No description

Parameters

string|null $table

Return Value

Selection

at line 559
protected GroupedSelection createGroupedSelectionInstance(string $table, string $column)

No description

Parameters

string $table
string $column

Return Value

GroupedSelection

at line 565
protected ResultSet query(string $query)

No description

Parameters

string $query

Return Value

ResultSet

at line 571
protected void emptyResultSet(bool $clearCache = true, bool $deleteReferencedCache = true)

No description

Parameters

bool $clearCache
bool $deleteReferencedCache

Return Value

void

at line 593
protected void saveCacheState()

No description

Return Value

void

at line 621
protected Selection getRefTable($refPath)

Returns Selection parent for caching.

Parameters

$refPath

Return Value

Selection

at line 630
protected void loadRefCache()

Loads refCache references

Return Value

void

at line 639
protected string getGeneralCacheKey()

Returns general cache key independent on query parameters or sql limit Used e.g. for previously accessed columns caching

Return Value

string

at line 662
protected string getSpecificCacheKey()

Returns object specific cache key dependent on query parameters Used e.g. for reference memory caching

Return Value

string

at line 677
bool accessColumn(string|null $key, bool $selectColumn = true)

internal  
 

No description

Parameters

string|null $key
bool $selectColumn

Return Value

bool

if selection requeried for more columns.

at line 743
void removeAccessColumn(string $key)

internal  
 

No description

Parameters

string $key

Return Value

void

at line 754
bool getDataRefreshed()

Returns if selection requeried for more columns.

Return Value

bool

at line 767
ActiveRow|array|int|bool insert(iterable $data)

Inserts row in a table. Returns ActiveRow or number of affected rows for Selection or table without primary key.

Parameters

iterable $data

[$column => $value]|\Traversable|Selection for INSERT ... SELECT

Return Value

ActiveRow|array|int|bool

at line 848
int update(iterable $data)

Updates all rows in result set.

Joins in UPDATE are supported only in MySQL

Parameters

iterable $data

Return Value

int

number of affected rows

at line 869
int delete()

Deletes all rows in result set.

Return Value

int

number of affected rows

at line 882
ActiveRow|false|null getReferencedTable(ActiveRow $row, string|null $table, string|null $column = null)

Returns referenced row.

Parameters

ActiveRow $row
string|null $table
string|null $column

Return Value

ActiveRow|false|null

null if the row does not exist, false if the relationship does not exist

at line 929
GroupedSelection|null getReferencingTable(string $table, string|null $column = null, int|string|null $active = null)

Returns referencing rows.

Parameters

string $table
string|null $column
int|string|null $active

Return Value

GroupedSelection|null

at line 961
void rewind()

No description

Return Value

void

at line 969
ActiveRow|false current()

No description

Return Value

ActiveRow|false

at line 977
string|int key()

No description

Return Value

string|int

at line 983
void next()

No description

Return Value

void

at line 991
bool valid()

No description

Return Value

bool

at line 1005
void offsetSet(string $key, ActiveRow $value)

Mimic row.

Parameters

string $key
ActiveRow $value

Return Value

void

at line 1016
ActiveRow|null offsetGet(string $key)

Returns specified row.

Parameters

string $key

Return Value

ActiveRow|null

at line 1027
bool offsetExists(string $key)

Tests if row exists.

Parameters

string $key

Return Value

bool

at line 1038
void offsetUnset(string $key)

Removes row from result set.

Parameters

string $key

Return Value

void