Class NGroupedTableSelection

Representation of filtered table grouped by some column. GroupedSelection is based on the great library NotORM http://www.notorm.com written by Jakub Vrana.

NObject

NTableSelection implements Iterator, ArrayAccess, Countable

NGroupedTableSelection

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

Methods summary
`public`	# `__construct( NTableSelection $refTable, string $table, string $column )` Creates filtered and grouped table representation. Creates filtered and grouped table representation. Parameters `$refTable` `NTableSelection` $refTable `$table` `string` database table name `$column` `string` joining column Overrides `NTableSelection::__construct()`
`public`	# `through( $column )` Deprecated
`public NGroupedTableSelection`	# `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 `NGroupedTableSelection` Overrides `NTableSelection::select()`
`public NGroupedTableSelection`	# `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 `NGroupedTableSelection` Overrides `NTableSelection::order()`
`public string`	# `aggregation( string $function )` Executes aggregation function. Executes aggregation function. Parameters `$function` `string` select call in "FUNCTION(column)" format Returns `string` Overrides `NTableSelection::aggregation()`
`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` Overrides `NTableSelection::count()`
`protected`	# `execute( )` Overrides `NTableSelection::execute()`
`protected NTableSelection`	# `getRefTable( & $refPath )` Returns Selection parent for caching. Returns Selection parent for caching. Returns `NTableSelection` Overrides `NTableSelection::getRefTable()`
`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 Overrides `NTableSelection::insert()`
`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 Overrides `NTableSelection::update()`
`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 Overrides `NTableSelection::delete()`

Methods inherited from NTableSelection
__clone(), __destruct(), createGroupedSelectionInstance(), createRow(), createSelectionInstance(), current(), emptyResultSet(), fetch(), fetchPairs(), find(), get(), getCacheKey(), getConnection(), getDataRefreshed(), getName(), getPrimary(), getPrimarySequence(), getReferencedTable(), getReferencingTable(), getSql(), group(), key(), limit(), max(), min(), next(), offsetExists(), offsetGet(), offsetSet(), offsetUnset(), page(), query(), rewind(), saveCacheState(), setPrimarySequence(), sum(), valid(), where(), wherePrimary()

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

Properties summary
`protected NTableSelection`	`$refTable`	# referenced table referenced table
`protected string`	`$column`	# grouping column name grouping column name
`protected integer`	`$active`	# primary key primary key

Properties inherited from NTableSelection
`$accessedColumns, $aggregation, $cache, $checkReferenced, $connection, $data, $dataRefreshed, $keys, $name, $observeCache, $previousAccessedColumns, $primary, $primarySequence, $referenced, $referencing, $referencingPrototype, $rows, $sqlBuilder`

Magic properties inherited from NTableSelection
`$sql`

Magic properties inherited from NObject
`$reflection`

Packages

Classes

Class NGroupedTableSelection

Parameters

Overrides

Deprecated

Parameters

Returns

Overrides

Parameters

Returns

Overrides

Parameters

Returns

Overrides

Parameters

Returns

Overrides

Overrides

Returns

Overrides

Parameters

Returns

Overrides

Parameters

Returns

Overrides

Returns

Overrides