Class GroupedTableSelection
Representation of filtered table grouped by some column. GroupedSelection is
based on the great library NotORM http://www.notorm.com written by Jakub
Vrana.
-
Object
-
TableSelection
implements
Iterator,
ArrayAccess,
Countable
-
GroupedTableSelection
Methods summary
public
|
#
__construct( string $name, TableSelection $refTable, $column, $active = NULL )
Parameters
- $name
string
- $refTable
- $column
- $active
Overrides
|
public
TableSelection
|
#
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
Overrides
|
public
TableSelection
|
#
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
Overrides
|
public
string
|
#
aggregation( string $function )
Executes aggregation function.
Executes aggregation function.
Parameters
Returns
string
Overrides
|
public
integer
|
#
count( string $column = '' )
Counts number of rows.
Parameters
Returns
integer
Overrides
Implementation of
|
public
TableRow
|
#
insert( mixed $data )
Inserts row in a table.
Parameters
- $data
mixed array($column => $value)|Traversable for single row insert or
Selection|string for INSERT ... SELECT
Returns
TableRow
or FALSE in case of an error or number of affected rows for INSERT ... SELECT
Overrides
|
public
integer
|
#
update( array|Traversable $data )
Updates all rows in result set.
Updates all rows in result set.
Parameters
Returns
integer number of affected rows or FALSE in case of an error
Overrides
|
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
|
protected
null
|
#
execute( )
Executes built query.
Returns
null
Overrides
|
Methods inherited from TableSelection
__destruct(),
createJoins(),
current(),
fetch(),
fetchPairs(),
find(),
get(),
getConnection(),
getName(),
getPrimary(),
getReferencedTable(),
getReferencingTable(),
getSql(),
group(),
key(),
limit(),
max(),
min(),
next(),
offsetExists(),
offsetGet(),
offsetSet(),
offsetUnset(),
page(),
query(),
removeExtraTables(),
rewind(),
sum(),
topString(),
tryDelimite(),
valid(),
where(),
whereString()
|
Properties inherited from TableSelection
$accessed,
$aggregation,
$checkReferenceNewKeys,
$conditions,
$connection,
$data,
$delimitedName,
$delimitedPrimary,
$group,
$having,
$keys,
$limit,
$name,
$offset,
$order,
$parameters,
$prevAccessed,
$primary,
$referenced,
$referencing,
$rows,
$select,
$where
|