1. class
  2. Nette
  3. \
  4. Database
  5. \
  6. Table
  7. \
  8. GroupedSelection

GroupedSelection

class GroupedSelection extends Selection

Representation of filtered table grouped by some column.

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

Properties

protected Selection $refTable
protected mixed $refCacheCurrent
protected string $column
protected int $active

Methods

__construct(Selection $refTable, $table, $column)

Creates filtered and grouped table representation.

GroupedSelection
setActive($active)

Sets active group.

Selection
select($columns)

Adds select clause, more calls appends to the end.

Selection
order($columns)

Adds order clause, more calls appends to the end.

string
aggregation($function)

Executes aggregation function.

int
count($column = NULL)

Counts number of rows.

execute()

No description

Selection
getRefTable($refPath)

Returns Selection parent for caching.

loadRefCache()

Loads refCache references

IRow|int|bool
insert($data)

Inserts row in a table.

int
update($data)

Updates all rows in result set.

int
delete()

Deletes all rows in result set.

Details

at line 41
__construct(Selection $refTable, $table, $column)

Creates filtered and grouped table representation.

Parameters

Selection $refTable
$table
$column

at line 55
GroupedSelection setActive($active)

internal  
 

Sets active group.

Parameters

$active

Return Value

GroupedSelection

at line 62
Selection select($columns)

Adds select clause, more calls appends to the end.

Parameters

$columns

Return Value

Selection

at line 72
Selection order($columns)

Adds order clause, more calls appends to the end.

Parameters

$columns

Return Value

Selection

at line 86
string aggregation($function)

Executes aggregation function.

Parameters

$function

Return Value

string

at line 112
int count($column = NULL)

Counts number of rows.

Parameters

$column

Return Value

int

at line 122
protected execute()

No description

at line 174
protected Selection getRefTable($refPath)

Returns Selection parent for caching.

Parameters

$refPath

Return Value

Selection

at line 187
protected loadRefCache()

Loads refCache references

at line 206
IRow|int|bool insert($data)

Inserts row in a table.

Parameters

$data

Return Value

IRow|int|bool

Returns IRow or number of affected rows for Selection or table without primary key

at line 224
int update($data)

Updates all rows in result set.

Joins in UPDATE are supported only in MySQL

Parameters

$data

Return Value

int

number of affected rows

at line 237
int delete()

Deletes all rows in result set.

Return Value

int

number of affected rows