Class NTableSelection

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

NObject

NTableSelection implements Iterator, ArrayAccess, Countable

Direct known subclasses

NGroupedTableSelection

Package: Nette\Database\Table
Author: Jakub Vrana
Author: Jan Skrasek
Located at Database/Table/Selection.php

Methods summary
`public`	# `__construct( string $table, NConnection $connection )` Creates filtered table representation. Creates filtered table representation. Parameters `$table` `string` database table name `$connection` `NConnection`
`public`	# `__destruct( )`
`public`	# `__clone( )`
`public NConnection`	# `getConnection( )` Returns `NConnection`
`public string`	# `getName( )` Returns `string`
`public string\|array`	# `getPrimary( boolean $need = TRUE )` Parameters `$need` `boolean` Returns `string\|array`
`public string`	# `getPrimarySequence( )` Returns `string`
`public NTableSelection`	# `setPrimarySequence( string $sequence )` Parameters `$sequence` `string` Returns `NTableSelection`
`public string`	# `getSql( )` Returns `string`
`public NTableRow`	# `get( mixed $key )` Returns row specified by primary key. Returns row specified by primary key. Parameters `$key` `mixed` primary key Returns `NTableRow` or FALSE if there is no such row
`public NTableRow`	# `fetch( )` Returns next row of result. Returns next row of result. Returns `NTableRow` or FALSE if there is no row
`public array`	# `fetchPairs( string $key, string $value = NULL )` Returns all rows as associative array. Returns all rows as associative array. Parameters `$key` `string` `$value` `string` column name used for an array value or NULL for the whole row Returns `array`
`public NTableSelection`	# `select( string $columns )` Adds select clause, more calls appends to the end. Adds select clause, more calls appends to the end. Parameters `$columns` `string` for example "column, MD5(column) AS column_md5" Returns `NTableSelection`
`public NTableSelection`	# `find( $key )` Method is deprecated, use wherePrimary() instead. Method is deprecated, use wherePrimary() instead. Returns `NTableSelection`
`public NTableSelection`	# `wherePrimary( mixed $key )` Adds condition for primary key. Adds condition for primary key. Parameters `$key` `mixed` Returns `NTableSelection`
`public NTableSelection`	# `where( string $condition, mixed $parameters = array() )` Adds where condition, more calls appends with AND. Adds where condition, more calls appends with AND. Parameters `$condition` `string` condition possibly containing ? `$parameters` `mixed` Returns `NTableSelection`
`public NTableSelection`	# `order( string $columns )` Adds order clause, more calls appends to the end. Adds order clause, more calls appends to the end. Parameters `$columns` `string` for example 'column1, column2 DESC' Returns `NTableSelection`
`public NTableSelection`	# `limit( integer $limit, integer $offset = NULL )` Sets limit clause, more calls rewrite old values. Sets limit clause, more calls rewrite old values. Parameters `$limit` `integer` `$offset` `integer` Returns `NTableSelection`
`public NTableSelection`	# `page( integer $page, integer $itemsPerPage )` Sets offset using page number, more calls rewrite old values. Sets offset using page number, more calls rewrite old values. Parameters `$page` `integer` `$itemsPerPage` `integer` Returns `NTableSelection`
`public NTableSelection`	# `group( string $columns, string $having = NULL )` Sets group clause, more calls rewrite old values. Sets group clause, more calls rewrite old values. Parameters `$columns` `string` `$having` `string` Returns `NTableSelection`
`public string`	# `aggregation( string $function )` Executes aggregation function. Executes aggregation function. Parameters `$function` `string` select call in "FUNCTION(column)" format Returns `string`
`public integer`	# `count( string $column = NULL )` Counts number of rows. Counts number of rows. Parameters `$column` `string` if it is not provided returns count of result rows, otherwise runs new sql counting query Returns `integer` Implementation of `Countable::count()`
`public integer`	# `min( string $column )` Returns minimum value from a column. Returns minimum value from a column. Parameters `$column` `string` Returns `integer`
`public integer`	# `max( string $column )` Returns maximum value from a column. Returns maximum value from a column. Parameters `$column` `string` Returns `integer`
`public integer`	# `sum( string $column )` Returns sum of values in a column. Returns sum of values in a column. Parameters `$column` `string` Returns `integer`
`protected`	# `execute( )`
`protected`	# `createRow( array $row )`
`protected`	# `createSelectionInstance( $table = NULL )`
`protected`	# `createGroupedSelectionInstance( $table, $column )`
`protected`	# `query( $query )`
`protected`	# `emptyResultSet( )`
`protected`	# `saveCacheState( )`
`protected NTableSelection`	# `getRefTable( & $refPath )` Returns Selection parent for caching. Returns Selection parent for caching. Returns `NTableSelection`
`protected string`	# `getCacheKey( )` Returns cache key for selected columns caching Returns cache key for selected columns caching Returns `string`
`public boolean`	# `getDataRefreshed( )` Returns if selection requeried for more columns. Returns if selection requeried for more columns. Returns `boolean`
`public NTableRow`	# `insert( mixed $data )` Inserts row in a table. Inserts row in a table. Parameters `$data` `mixed` array($column => $value)\|Traversable for single row insert or Selection\|string for INSERT ... SELECT Returns `NTableRow` or FALSE in case of an error or number of affected rows for INSERT ... SELECT
`public integer`	# `update( array\|Traversable $data )` Updates all rows in result set. Joins in UPDATE are supported only in MySQL Updates all rows in result set. Joins in UPDATE are supported only in MySQL Parameters `$data` `array\|Traversable` ($column => $value) Returns `integer` number of affected rows or FALSE in case of an error
`public integer`	# `delete( )` Deletes all rows in result set. Deletes all rows in result set. Returns `integer` number of affected rows or FALSE in case of an error
`public NTableSelection`	# `getReferencedTable( string $table, string $column, boolean $checkReferenced = FALSE )` Returns referenced row. Returns referenced row. Parameters `$table` `string` `$column` `string` `$checkReferenced` `boolean` checks if rows contains the same primary value relations Returns `NTableSelection` or array() if the row does not exist
`public NGroupedTableSelection`	# `getReferencingTable( string $table, string $column, integer $active = NULL )` Returns referencing rows. Returns referencing rows. Parameters `$table` `string` `$column` `string` `$active` `integer` primary key Returns `NGroupedTableSelection`
`public`	# `rewind( )` Implementation of `Iterator::rewind()`
`public NTableRow`	# `current( )` Returns `NTableRow` Implementation of `Iterator::current()`
`public string`	# `key( )` Returns `string` row ID Implementation of `Iterator::key()`
`public`	# `next( )` Implementation of `Iterator::next()`
`public`	# `valid( )` Implementation of `Iterator::valid()`
`public null`	# `offsetSet( string $key, NTableRow $value )` Mimic row. Mimic row. Parameters `$key` `string` row ID `$value` `NTableRow` Returns `null` Implementation of `ArrayAccess::offsetSet()`
`public NTableRow`	# `offsetGet( string $key )` Returns specified row. Returns specified row. Parameters `$key` `string` row ID Returns `NTableRow` or NULL if there is no such row Implementation of `ArrayAccess::offsetGet()`
`public boolean`	# `offsetExists( string $key )` Tests if row exists. Tests if row exists. Parameters `$key` `string` row ID Returns `boolean` Implementation of `ArrayAccess::offsetExists()`
`public null`	# `offsetUnset( string $key )` Removes row from result set. Removes row from result set. Parameters `$key` `string` row ID Returns `null` Implementation of `ArrayAccess::offsetUnset()`

Methods inherited from NObject
`__call(), __callStatic(), __get(), __isset(), __set(), __unset(), extensionMethod(), getReflection()`

Properties summary
`protected NConnection`	`$connection`		#
`protected NCache`	`$cache`		#
`protected NSqlBuilder`	`$sqlBuilder`		#
`protected string`	`$name`		# table name table name
`protected string`	`$primary`		# primary key field name primary key field name
`protected string\|boolean`	`$primarySequence`	`FALSE`	# primary column sequence name, FALSE for autodetection primary column sequence name, FALSE for autodetection
`protected NTableRow[]`	`$rows`		# data read from database in [primary key => ActiveRow] format data read from database in [primary key => ActiveRow] format
`protected NTableRow[]`	`$data`		# modifiable data in [primary key => ActiveRow] format modifiable data in [primary key => ActiveRow] format
`protected boolean`	`$dataRefreshed`	`FALSE`	#
`protected NTableSelection[]`	`$referenced`	`array()`	#
`protected array`	`$referencing`	`array()`	# of [sqlQuery-hash => grouped data]; used by GroupedSelection of [sqlQuery-hash => grouped data]; used by GroupedSelection
`protected NGroupedTableSelection[]`	`$referencingPrototype`	`array()`	# cached array of GroupedSelection prototypes cached array of GroupedSelection prototypes
`protected array`	`$aggregation`	`array()`	# of [conditions => [key => ActiveRow]]; used by GroupedSelection of [conditions => [key => ActiveRow]]; used by GroupedSelection
`protected array`	`$accessedColumns`		# of touched columns of touched columns
`protected array`	`$previousAccessedColumns`		# of earlier touched columns of earlier touched columns
`protected boolean`	`$observeCache`	`FALSE`	# should instance observe accessed columns caching should instance observe accessed columns caching
`protected boolean`	`$checkReferenced`	`FALSE`	# recheck referencing keys recheck referencing keys
`protected array`	`$keys`	`array()`	# of primary key values of primary key values

Magic properties summary
`public read-only string`	`$sql`	#

Magic properties inherited from NObject
`$reflection`

Packages

Classes

Class NTableSelection

Direct known subclasses

Parameters

Returns

Returns

Parameters

Returns

Returns

Parameters

Returns

Returns

Parameters

Returns

Returns

Parameters

Returns

Parameters

Returns

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Implementation of

Parameters

Returns

Parameters

Returns

Parameters

Returns

Returns

Returns

Returns

Parameters

Returns

Parameters

Returns

Returns

Parameters

Returns

Parameters

Returns

Implementation of

Returns

Implementation of

Returns

Implementation of

Implementation of

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of