master 3.2 3.1 3.0 2.4 2.3 2.2

• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

A

AmbiguousReferenceKeyException — Class in namespace Nette\Database\Conventions

Ambiguous reference key exception.

Engine::applyLimit() — Method in class Engine

Applies LIMIT and OFFSET clauses to an SQL query.

MSSQLEngine::applyLimit() — Method in class MSSQLEngine

Applies LIMIT and OFFSET clauses to an SQL query.

MySQLEngine::applyLimit() — Method in class MySQLEngine

Applies LIMIT and OFFSET clauses to an SQL query.

ODBCEngine::applyLimit() — Method in class ODBCEngine

Applies LIMIT and OFFSET clauses to an SQL query.

OracleEngine::applyLimit() — Method in class OracleEngine

Applies LIMIT and OFFSET clauses to an SQL query.

PostgreSQLEngine::applyLimit() — Method in class PostgreSQLEngine

Applies LIMIT and OFFSET clauses to an SQL query.

SQLServerEngine::applyLimit() — Method in class SQLServerEngine

Applies LIMIT and OFFSET clauses to an SQL query.

SQLiteEngine::applyLimit() — Method in class SQLiteEngine

Applies LIMIT and OFFSET clauses to an SQL query.

Structure::analyzePrimaryKey() — Method in class Structure

Structure::analyzeForeignKeys() — Method in class Structure

ActiveRow — Class in namespace Nette\Database\Table

Single row representation.

ActiveRow::accessColumn() — Method in class ActiveRow

$ GroupedSelection#active — Property in class GroupedSelection

primary key

GroupedSelection::aggregation() — Method in class GroupedSelection

Executes aggregation function.

$ Selection#aggregation — Property in class Selection

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

$ Selection#accessedColumns — Property in class Selection

Selection::alias() — Method in class Selection

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

Selection::aggregation() — Method in class Selection

Executes aggregation function.

Selection::accessColumn() — Method in class Selection

$ SqlBuilder#aliases — Property in class SqlBuilder

SqlBuilder::addSelect() — Method in class SqlBuilder

SqlBuilder::addWhere() — Method in class SqlBuilder

SqlBuilder::addJoinCondition() — Method in class SqlBuilder

SqlBuilder::addCondition() — Method in class SqlBuilder

SqlBuilder::addAlias() — Method in class SqlBuilder

Adds alias.

SqlBuilder::addOrder() — Method in class SqlBuilder

SqlBuilder::addConditionComposition() — Method in class SqlBuilder

B

DatabaseExtension::beforeCompile() — Method in class DatabaseExtension

LazyConnection::beginTransaction() — Method in class LazyConnection

Starts a new database transaction.

Connection::beginTransaction() — Method in class Connection

Starts a new database transaction.

Connection::beginTransaction() — Method in class Connection

Starts a new database transaction.

Explorer::beginTransaction() — Method in class Explorer

SqlBuilder::buildInsertQuery() — Method in class SqlBuilder

SqlBuilder::buildUpdateQuery() — Method in class SqlBuilder

SqlBuilder::buildDeleteQuery() — Method in class SqlBuilder

SqlBuilder::buildSelectQuery() — Method in class SqlBuilder

Returns SQL query.

SqlBuilder::buildSelect() — Method in class SqlBuilder

SqlBuilder::buildQueryJoins() — Method in class SqlBuilder

SqlBuilder::buildJoinConditions() — Method in class SqlBuilder

SqlBuilder::buildConditions() — Method in class SqlBuilder

SqlBuilder::buildQueryEnd() — Method in class SqlBuilder

C

ConnectionPanel — Class in namespace Nette\Bridges\DatabaseTracy

Debug panel for Nette\Database.

Connection — Class in namespace Nette\Database

ConnectionException — Class in namespace Nette\Database

Server connection related errors.

ConstraintViolationException — Class in namespace Nette\Database

Base class for all constraint violation related exceptions.

Context — Class in namespace Nette\Database

Conventions — Class in namespace Nette\Database

LazyConnection::commit() — Method in class LazyConnection

Commits the current database transaction.

Connection — Class in namespace Nette\Database\Drivers

Provides methods for executing queries and managing transactions.

Connection::commit() — Method in class Connection

Commits the current database transaction.

Driver::connect() — Method in class Driver

Establishes a connection to the database.

Driver::createEngine() — Method in class Driver

Creates a engine instance for the specific database platform.

Engine::classifyException() — Method in class Engine

Maps a driver exception to an appropriate exception class.

Engine::convertToPhp() — Method in class Engine

Converts a value from the database to a PHP value.

MSSQLEngine::classifyException() — Method in class MSSQLEngine

Maps a driver exception to an appropriate exception class.

MSSQLEngine::convertToPhp() — Method in class MSSQLEngine

Converts a value from the database to a PHP value.

MySQLEngine::classifyException() — Method in class MySQLEngine

Maps a driver exception to an appropriate exception class.

MySQLEngine::convertToPhp() — Method in class MySQLEngine

Converts a value from the database to a PHP value.

ODBCEngine::classifyException() — Method in class ODBCEngine

Maps a driver exception to an appropriate exception class.

ODBCEngine::convertToPhp() — Method in class ODBCEngine

Converts a value from the database to a PHP value.

OracleEngine::classifyException() — Method in class OracleEngine

Maps a driver exception to an appropriate exception class.

OracleEngine::convertToPhp() — Method in class OracleEngine

Converts a value from the database to a PHP value.

PostgreSQLEngine::classifyException() — Method in class PostgreSQLEngine

Maps a driver exception to an appropriate exception class.

PostgreSQLEngine::convertToPhp() — Method in class PostgreSQLEngine

Converts a value from the database to a PHP value.

SQLServerEngine::classifyException() — Method in class SQLServerEngine

Maps a driver exception to an appropriate exception class.

SQLServerEngine::convertToPhp() — Method in class SQLServerEngine

Converts a value from the database to a PHP value.

SQLiteEngine::classifyException() — Method in class SQLiteEngine

Maps a driver exception to an appropriate exception class.

SQLiteEngine::convertToPhp() — Method in class SQLiteEngine

Converts a value from the database to a PHP value.

Connection — Class in namespace Nette\Database\Drivers\PDO

Connection::commit() — Method in class Connection

Commits the current database transaction.

Driver::connect() — Method in class Driver

Establishes a connection to the database.

Driver::createEngine() — Method in class Driver

Creates a engine instance for the specific database platform.

Driver::connect() — Method in class Driver

Establishes a connection to the database.

Driver::createEngine() — Method in class Driver

Creates a engine instance for the specific database platform.

Driver::createEngine() — Method in class Driver

Creates a engine instance for the specific database platform.

Driver::createEngine() — Method in class Driver

Creates a engine instance for the specific database platform.

Driver::connect() — Method in class Driver

Establishes a connection to the database.

Driver::createEngine() — Method in class Driver

Creates a engine instance for the specific database platform.

Result::collectColumnsInfo() — Method in class Result

Result::collectColumnsInfo() — Method in class Result

Driver::connect() — Method in class Driver

Establishes a connection to the database.

Driver::createEngine() — Method in class Driver

Creates a engine instance for the specific database platform.

Driver::connect() — Method in class Driver

Establishes a connection to the database.

Driver::createEngine() — Method in class Driver

Creates a engine instance for the specific database platform.

Explorer::createFromParameters() — Method in class Explorer

Explorer::createFromDsn() — Method in class Explorer

Explorer::connect() — Method in class Explorer

Explorer::commit() — Method in class Explorer

Helpers::createDebugPanel() — Method in class Helpers

Column — Class in namespace Nette\Database\Reflection

Column reflection.

$ Table#columns — Property in class Table

$ GroupedSelection#column — Property in class GroupedSelection

grouping column name

GroupedSelection::count() — Method in class GroupedSelection

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

$ Selection#cache — Property in class Selection

Selection::condition() — Method in class Selection

Adds condition, more calls appends with AND.

Selection::count() — Method in class Selection

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

Selection::createRow() — Method in class Selection

Selection::createSelectionInstance() — Method in class Selection

Selection::createGroupedSelectionInstance() — Method in class Selection

$ SqlBuilder#conventions — Property in class SqlBuilder

$ SqlBuilder#conditions — Property in class SqlBuilder

$ SqlBuilder#currentAlias — Property in class SqlBuilder

SqlBuilder::checkUniqueTableName() — Method in class SqlBuilder

$ TypeConverter#convertBoolean — Property in class TypeConverter

$ TypeConverter#convertDateTime — Property in class TypeConverter

$ TypeConverter#convertDecimal — Property in class TypeConverter

TypeConverter::convertToPhp() — Method in class TypeConverter

D

DatabaseExtension — Class in namespace Nette\Bridges\DatabaseDI

Nette Framework Database services.

$ ConnectionPanel#disabled — Property in class ConnectionPanel

DiscoveredConventions — Class in namespace Nette\Database\Conventions

Conventions based on database structure.

DateTime — Class in namespace Nette\Database

Date Time.

DriverException — Class in namespace Nette\Database

Base class for all errors in the driver or SQL server.

Driver — Class in namespace Nette\Database\Drivers

Creates connection and database engine instances.

Engine::delimit() — Method in class Engine

Escapes an identifier for use in an SQL statement.

MSSQLEngine::delimit() — Method in class MSSQLEngine

Escapes an identifier for use in an SQL statement.

MySQLEngine::delimit() — Method in class MySQLEngine

Escapes an identifier for use in an SQL statement.

ODBCEngine::delimit() — Method in class ODBCEngine

Escapes an identifier for use in an SQL statement.

OracleEngine::delimit() — Method in class OracleEngine

Escapes an identifier for use in an SQL statement.

PostgreSQLEngine::delimit() — Method in class PostgreSQLEngine

Escapes an identifier for use in an SQL statement.

SQLServerEngine::delimit() — Method in class SQLServerEngine

Escapes an identifier for use in an SQL statement.

SQLiteEngine::delimit() — Method in class SQLiteEngine

Escapes an identifier for use in an SQL statement.

Driver — Class in namespace Nette\Database\Drivers\PDO

Base PDO database driver.

Driver — Class in namespace Nette\Database\Drivers\PDO\MSSQL

PDO MS SQL database driver.

Driver — Class in namespace Nette\Database\Drivers\PDO\MySQL

PDO MySQL database driver.

Driver — Class in namespace Nette\Database\Drivers\PDO\OCI

PDO Oracle database driver.

Driver — Class in namespace Nette\Database\Drivers\PDO\ODBC

PDO ODBC database driver.

Driver — Class in namespace Nette\Database\Drivers\PDO\PgSQL

PDO PostgreSQL database driver.

Driver — Class in namespace Nette\Database\Drivers\PDO\SQLSrv

PDO SQL Server database driver.

Driver — Class in namespace Nette\Database\Drivers\PDO\SQLite

PDO SQLite database driver.

Explorer::disconnect() — Method in class Explorer

Helpers::dumpResult() — Method in class Helpers

Displays complete result set as HTML table for debug purposes.

Helpers::dumpSql() — Method in class Helpers

Returns syntax highlighted SQL command.

Result::dump() — Method in class Result

Displays complete result set as HTML table for debug purposes.

ActiveRow::delete() — Method in class ActiveRow

Deletes row.

GroupedSelection::delete() — Method in class GroupedSelection

Deletes all rows in result set.

$ Selection#data — Property in class Selection

$ Selection#dataRefreshed — Property in class Selection

Selection::delete() — Method in class Selection

Deletes all rows in result set.

$ SqlBuilder#delimitedTable — Property in class SqlBuilder

E

$ ConnectionPanel#explain — Property in class ConnectionPanel

LazyConnection::execute() — Method in class LazyConnection

Executes an SQL command and returns the number of affected rows.

Connection::execute() — Method in class Connection

Executes an SQL command and returns the number of affected rows.

Engine — Class in namespace Nette\Database\Drivers

Database platform specific operations and reflection capabilities.

Connection::execute() — Method in class Connection

Executes an SQL command and returns the number of affected rows.

Driver::exceptionArgs() — Method in class Driver

Explorer — Class in namespace Nette\Database

The central access point to Nette Database functionality.

GroupedSelection::execute() — Method in class GroupedSelection

GroupedSelection::emptyResultSet() — Method in class GroupedSelection

$ Selection#explorer — Property in class Selection

Selection::execute() — Method in class Selection

Selection::emptyResultSet() — Method in class Selection

F

DriverException::from() — Method in class DriverException

Engine::formatDateTime() — Method in class Engine

Formats a date-time value for use in an SQL statement.

Engine::formatDateInterval() — Method in class Engine

Formats a date-time interval for use in an SQL statement.

MSSQLEngine::formatDateTime() — Method in class MSSQLEngine

Formats a date-time value for use in an SQL statement.

MSSQLEngine::formatDateInterval() — Method in class MSSQLEngine

Formats a date-time interval for use in an SQL statement.

MySQLEngine::formatDateTime() — Method in class MySQLEngine

Formats a date-time value for use in an SQL statement.

MySQLEngine::formatDateInterval() — Method in class MySQLEngine

Formats a date-time interval for use in an SQL statement.

ODBCEngine::formatDateTime() — Method in class ODBCEngine

Formats a date-time value for use in an SQL statement.

ODBCEngine::formatDateInterval() — Method in class ODBCEngine

Formats a date-time interval for use in an SQL statement.

$ OracleEngine#formatDateTime — Property in class OracleEngine

OracleEngine::formatDateTime() — Method in class OracleEngine

Formats a date-time value for use in an SQL statement.

OracleEngine::formatDateInterval() — Method in class OracleEngine

Formats a date-time interval for use in an SQL statement.

PostgreSQLEngine::formatDateTime() — Method in class PostgreSQLEngine

Formats a date-time value for use in an SQL statement.

PostgreSQLEngine::formatDateInterval() — Method in class PostgreSQLEngine

Formats a date-time interval for use in an SQL statement.

SQLServerEngine::formatDateTime() — Method in class SQLServerEngine

Formats a date-time value for use in an SQL statement.

SQLServerEngine::formatDateInterval() — Method in class SQLServerEngine

Formats a date-time interval for use in an SQL statement.

$ SQLiteEngine#formatDateTime — Property in class SQLiteEngine

SQLiteEngine::formatDateTime() — Method in class SQLiteEngine

Formats a date-time value for use in an SQL statement.

SQLiteEngine::formatDateInterval() — Method in class SQLiteEngine

Formats a date-time interval for use in an SQL statement.

Result::fetch() — Method in class Result

Fetches the next row from the result set as an associative array.

Result::fetchList() — Method in class Result

Fetches the next row from the result set as an indexed array.

Result::free() — Method in class Result

Frees the result set.

Result::fetch() — Method in class Result

Fetches the next row from the result set as an associative array.

Result::fetchList() — Method in class Result

Fetches the next row from the result set as an indexed array.

Result::free() — Method in class Result

Frees the result set.

Explorer::fetch() — Method in class Explorer

Shortcut for query()->fetch()

Explorer::fetchAssoc() — Method in class Explorer

Shortcut for query()->fetchAssoc()

Explorer::fetchField() — Method in class Explorer

Shortcut for query()->fetchField()

Explorer::fetchList() — Method in class Explorer

Shortcut for query()->fetchList()

Explorer::fetchFields() — Method in class Explorer

Shortcut for query()->fetchList()

Explorer::fetchPairs() — Method in class Explorer

Shortcut for query()->fetchPairs()

Explorer::fetchAll() — Method in class Explorer

Shortcut for query()->fetchAll()

ForeignKeyConstraintViolationException — Class in namespace Nette\Database

Exception for a foreign key constraint violation.

ForeignKey — Class in namespace Nette\Database\Reflection

Foreign key reflection.

$ Table#foreignKeys — Property in class Table

Result::fetchAssoc() — Method in class Result

Returns the next row as an associative array or null if there are no more rows.

Result::fetch() — Method in class Result

Returns the next row as an object Row or null if there are no more rows.

Result::fetchField() — Method in class Result

Returns the first field of the next row or null if there are no more rows.

Result::fetchList() — Method in class Result

Returns the next row as indexes array or null if there are no more rows.

Result::fetchFields() — Method in class Result

Alias for fetchList().

Result::fetchPairs() — Method in class Result

Fetches all rows as associative array.

Result::fetchAll() — Method in class Result

Fetches all rows.

Selection::fetch() — Method in class Selection

Fetches single row object.

Selection::fetchField() — Method in class Selection

Fetches single field.

Selection::fetchPairs() — Method in class Selection

Fetches all rows as associative array.

Selection::fetchAll() — Method in class Selection

Fetches all rows.

Selection::fetchAssoc() — Method in class Selection

Fetches all rows and returns associative tree.

G

DatabaseExtension::getConfigSchema() — Method in class DatabaseExtension

ConnectionPanel::getTab() — Method in class ConnectionPanel

ConnectionPanel::getPanel() — Method in class ConnectionPanel

Conventions::getPrimary() — Method in class Conventions

Returns primary key for table.

Conventions::getHasManyReference() — Method in class Conventions

Returns referenced table & referenced column.

Conventions::getBelongsToReference() — Method in class Conventions

Returns referenced table & referencing column.

DiscoveredConventions::getPrimary() — Method in class DiscoveredConventions

Returns primary key for table.

DiscoveredConventions::getHasManyReference() — Method in class DiscoveredConventions

Returns referenced table & referenced column.

DiscoveredConventions::getBelongsToReference() — Method in class DiscoveredConventions

Returns referenced table & referencing column.

StaticConventions::getPrimary() — Method in class StaticConventions

Returns primary key for table.

StaticConventions::getHasManyReference() — Method in class StaticConventions

Returns referenced table & referenced column.

StaticConventions::getBelongsToReference() — Method in class StaticConventions

Returns referenced table & referencing column.

StaticConventions::getColumnFromTable() — Method in class StaticConventions

DriverException::getDriverCode() — Method in class DriverException

DriverException::getSqlState() — Method in class DriverException

DriverException::getQuery() — Method in class DriverException

DriverException::getQueryString() — Method in class DriverException

DriverException::getParameters() — Method in class DriverException

LazyConnection::getNativeConnection() — Method in class LazyConnection

Returns the underlying database connection object.

LazyConnection::getInsertId() — Method in class LazyConnection

Returns the ID of the last inserted row or sequence value.

LazyConnection::getServerVersion() — Method in class LazyConnection

Returns the version of the database server.

Connection::getNativeConnection() — Method in class Connection

Returns the underlying database connection object.

Connection::getInsertId() — Method in class Connection

Returns the ID of the last inserted row or sequence value.

Connection::getServerVersion() — Method in class Connection

Returns the version of the database server.

Engine::getTables() — Method in class Engine

Returns a list of all tables in the database.

Engine::getColumns() — Method in class Engine

Returns detailed information about columns in a table.

Engine::getIndexes() — Method in class Engine

Returns information about indexes in a table.

Engine::getForeignKeys() — Method in class Engine

Returns information about foreign keys in a table.

MSSQLEngine::getTables() — Method in class MSSQLEngine

Returns a list of all tables in the database.

MSSQLEngine::getColumns() — Method in class MSSQLEngine

Returns detailed information about columns in a table.

MSSQLEngine::getIndexes() — Method in class MSSQLEngine

Returns information about indexes in a table.

MSSQLEngine::getForeignKeys() — Method in class MSSQLEngine

Returns information about foreign keys in a table.

MySQLEngine::getTables() — Method in class MySQLEngine

Returns a list of all tables in the database.

MySQLEngine::getColumns() — Method in class MySQLEngine

Returns detailed information about columns in a table.

MySQLEngine::getIndexes() — Method in class MySQLEngine

Returns information about indexes in a table.

MySQLEngine::getForeignKeys() — Method in class MySQLEngine

Returns information about foreign keys in a table.

ODBCEngine::getTables() — Method in class ODBCEngine

Returns a list of all tables in the database.

ODBCEngine::getColumns() — Method in class ODBCEngine

Returns detailed information about columns in a table.

ODBCEngine::getIndexes() — Method in class ODBCEngine

Returns information about indexes in a table.

ODBCEngine::getForeignKeys() — Method in class ODBCEngine

Returns information about foreign keys in a table.

OracleEngine::getTables() — Method in class OracleEngine

Returns a list of all tables in the database.

OracleEngine::getColumns() — Method in class OracleEngine

Returns detailed information about columns in a table.

OracleEngine::getIndexes() — Method in class OracleEngine

Returns information about indexes in a table.

OracleEngine::getForeignKeys() — Method in class OracleEngine

Returns information about foreign keys in a table.

PostgreSQLEngine::getTables() — Method in class PostgreSQLEngine

Returns a list of all tables in the database.

PostgreSQLEngine::getColumns() — Method in class PostgreSQLEngine

Returns detailed information about columns in a table.

PostgreSQLEngine::getIndexes() — Method in class PostgreSQLEngine

Returns information about indexes in a table.

PostgreSQLEngine::getForeignKeys() — Method in class PostgreSQLEngine

Returns information about foreign keys in a table.

SQLServerEngine::getTables() — Method in class SQLServerEngine

Returns a list of all tables in the database.

SQLServerEngine::getColumns() — Method in class SQLServerEngine

Returns detailed information about columns in a table.

SQLServerEngine::getIndexes() — Method in class SQLServerEngine

Returns information about indexes in a table.

SQLServerEngine::getForeignKeys() — Method in class SQLServerEngine

Returns information about foreign keys in a table.

SQLiteEngine::getTables() — Method in class SQLiteEngine

Returns a list of all tables in the database.

SQLiteEngine::getColumns() — Method in class SQLiteEngine

Returns detailed information about columns in a table.

SQLiteEngine::getIndexes() — Method in class SQLiteEngine

Returns information about indexes in a table.

SQLiteEngine::getForeignKeys() — Method in class SQLiteEngine

Returns information about foreign keys in a table.

Connection::getInsertId() — Method in class Connection

Returns the ID of the last inserted row or sequence value.

Connection::getServerVersion() — Method in class Connection

Returns the version of the database server.

Connection::getNativeConnection() — Method in class Connection

Returns the underlying database connection object.

Result::getColumnCount() — Method in class Result

Returns the number of columns in the result set.

Result::getRowCount() — Method in class Result

Returns the number of rows in the result set or number of affected rows

Result::getColumnsInfo() — Method in class Result

Returns metadata for all columns in a result set.

Result::getColumnCount() — Method in class Result

Returns the number of columns in the result set.

Result::getRowCount() — Method in class Result

Returns the number of rows in the result set or number of affected rows

Result::getColumnsInfo() — Method in class Result

Returns metadata for all columns in a result set.

Explorer::getDsn() — Method in class Explorer

Explorer::getPdo() — Method in class Explorer

Explorer::getConnection() — Method in class Explorer

Explorer::getSupplementalDriver() — Method in class Explorer

Explorer::getDatabaseEngine() — Method in class Explorer

Explorer::getServerVersion() — Method in class Explorer

Explorer::getReflection() — Method in class Explorer

Explorer::getTypeConverter() — Method in class Explorer

Explorer::getInsertId() — Method in class Explorer

Explorer::getLastQuery() — Method in class Explorer

Explorer::getLastQueryString() — Method in class Explorer

Explorer::getCache() — Method in class Explorer

Explorer::getConventions() — Method in class Explorer

Explorer::getStructure() — Method in class Explorer

Reflection::getTables() — Method in class Reflection

Reflection::getTable() — Method in class Reflection

Reflection::getDatabaseEngine() — Method in class Reflection

Table::getColumn() — Method in class Table

Result::getConnection() — Method in class Result

Result::getQuery() — Method in class Result

Result::getQueryString() — Method in class Result

Result::getParameters() — Method in class Result

Result::getColumnCount() — Method in class Result

Result::getRowCount() — Method in class Result

Result::getTime() — Method in class Result

Result::getIterator() — Method in class Result

SqlLiteral::getSql() — Method in class SqlLiteral

SqlLiteral::getParameters() — Method in class SqlLiteral

Structure::getTables() — Method in class Structure

Structure::getColumns() — Method in class Structure

Structure::getPrimaryKey() — Method in class Structure

Structure::getPrimaryAutoincrementKey() — Method in class Structure

Structure::getPrimaryKeySequence() — Method in class Structure

Structure::getHasManyReference() — Method in class Structure

Structure::getBelongsToReference() — Method in class Structure

ActiveRow::getTable() — Method in class ActiveRow

ActiveRow::getPrimary() — Method in class ActiveRow

Returns primary key value.

ActiveRow::getSignature() — Method in class ActiveRow

Returns row signature (composition of primary keys)

ActiveRow::getIterator() — Method in class ActiveRow

GroupedSelection — Class in namespace Nette\Database\Table

Representation of filtered table grouped by some column.

GroupedSelection::getRefTable() — Method in class GroupedSelection

Returns Selection parent for caching.

$ Selection#globalRefCache — Property in class Selection

cache array of Selection and GroupedSelection prototypes

$ Selection#generalCacheKey — Property in class Selection

Selection::getName() — Method in class Selection

Selection::getPrimary() — Method in class Selection

Selection::getPrimarySequence() — Method in class Selection

Selection::getSql() — Method in class Selection

Selection::getPreviousAccessedColumns() — Method in class Selection

Loads cache of previous accessed columns and returns it.

Selection::getSqlBuilder() — Method in class Selection

Selection::get() — Method in class Selection

Returns row specified by primary key.

Selection::group() — Method in class Selection

Sets group clause, more calls rewrite old value.

Selection::getRefTable() — Method in class Selection

Returns Selection parent for caching.

Selection::getGeneralCacheKey() — Method in class Selection

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

Selection::getSpecificCacheKey() — Method in class Selection

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

Selection::getDataRefreshed() — Method in class Selection

Returns if selection requeried for more columns.

Selection::getReferencedTable() — Method in class Selection

Returns referenced row.

Selection::getReferencingTable() — Method in class Selection

Returns referencing rows.

Selection::getIterator() — Method in class Selection

$ SqlBuilder#group — Property in class SqlBuilder

SqlBuilder::getTableName() — Method in class SqlBuilder

SqlBuilder::getSelectQueryHash() — Method in class SqlBuilder

Returns select query hash for caching.

SqlBuilder::getParameters() — Method in class SqlBuilder

SqlBuilder::getSelect() — Method in class SqlBuilder

SqlBuilder::getConditions() — Method in class SqlBuilder

SqlBuilder::getOrder() — Method in class SqlBuilder

SqlBuilder::getLimit() — Method in class SqlBuilder

SqlBuilder::getOffset() — Method in class SqlBuilder

SqlBuilder::getGroup() — Method in class SqlBuilder

SqlBuilder::getHaving() — Method in class SqlBuilder

SqlBuilder::getSortedJoins() — Method in class SqlBuilder

H

Helpers — Class in namespace Nette\Database

Database helpers.

Reflection::hasTable() — Method in class Reflection

Selection::having() — Method in class Selection

Sets having clause, more calls rewrite old value.

$ SqlBuilder#having — Property in class SqlBuilder

I

ConnectionPanel::initialize() — Method in class ConnectionPanel

Engine::isSupported() — Method in class Engine

Checks if the engine supports a specific feature.

MSSQLEngine::isSupported() — Method in class MSSQLEngine

Checks if the engine supports a specific feature.

MySQLEngine::isSupported() — Method in class MySQLEngine

Checks if the engine supports a specific feature.

ODBCEngine::isSupported() — Method in class ODBCEngine

Checks if the engine supports a specific feature.

OracleEngine::isSupported() — Method in class OracleEngine

Checks if the engine supports a specific feature.

PostgreSQLEngine::isSupported() — Method in class PostgreSQLEngine

Checks if the engine supports a specific feature.

SQLServerEngine::isSupported() — Method in class SQLServerEngine

Checks if the engine supports a specific feature.

SQLiteEngine::isSupported() — Method in class SQLiteEngine

Checks if the engine supports a specific feature.

Helpers::initializeTracy() — Method in class Helpers

Index — Class in namespace Nette\Database\Reflection

Index reflection.

$ Table#indexes — Property in class Table

$ Structure#isRebuilt — Property in class Structure

Structure::isRebuilt() — Method in class Structure

GroupedSelection::insert() — Method in class GroupedSelection

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

Selection::insert() — Method in class Selection

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

SqlBuilder::importConditions() — Method in class SqlBuilder

SqlBuilder::importGroupConditions() — Method in class SqlBuilder

J

DateTime::jsonSerialize() — Method in class DateTime

Returns JSON representation in ISO 8601 (used by JavaScript).

Selection::joinWhere() — Method in class Selection

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

$ SqlBuilder#joinCondition — Property in class SqlBuilder

L

DatabaseExtension::loadConfiguration() — Method in class DatabaseExtension

LazyConnection — Class in namespace Nette\Database\Drivers\Accessory

Explorer::literal() — Method in class Explorer

Helpers::loadFromFile() — Method in class Helpers

Import SQL dump from file - extremely fast.

Structure::loadStructure() — Method in class Structure

GroupedSelection::loadRefCache() — Method in class GroupedSelection

Loads refCache references

Selection::limit() — Method in class Selection

Sets limit clause, more calls rewrite old values.

Selection::loadRefCache() — Method in class Selection

Loads refCache references

$ SqlBuilder#limit — Property in class SqlBuilder

M

$ ConnectionPanel#maxQueries — Property in class ConnectionPanel

MSSQLEngine — Class in namespace Nette\Database\Drivers\Engines

MS SQL database platform.

MySQLEngine — Class in namespace Nette\Database\Drivers\Engines

MySQL-like database platform.

$ Connection#metaTypeKey — Property in class Connection

$ Helpers#maxLength — Property in class Helpers

maximum SQL length

Selection::min() — Method in class Selection

Returns minimum value from a column.

Selection::max() — Method in class Selection

Returns maximum value from a column.

N

$ ConnectionPanel#name — Property in class ConnectionPanel

NotNullConstraintViolationException — Class in namespace Nette\Database

Exception for a NOT NULL constraint violation.

Structure::needStructure() — Method in class Structure

$ Selection#name — Property in class Selection

table name

$ TypeConverter#newDateTime — Property in class TypeConverter

O

ODBCEngine — Class in namespace Nette\Database\Drivers\Engines

Microsoft ODBC database platform.

OracleEngine — Class in namespace Nette\Database\Drivers\Engines

Oracle database platform.

$ Explorer#onConnect — Property in class Explorer

$ Explorer#onQuery — Property in class Explorer

Row::offsetGet() — Method in class Row

Returns a item.

Row::offsetExists() — Method in class Row

Checks if $key exists.

ActiveRow::offsetSet() — Method in class ActiveRow

Stores value in column.

ActiveRow::offsetGet() — Method in class ActiveRow

Returns value of column.

ActiveRow::offsetExists() — Method in class ActiveRow

Tests if column exists.

ActiveRow::offsetUnset() — Method in class ActiveRow

Removes column from data.

GroupedSelection::order() — Method in class GroupedSelection

Adds order clause, more calls appends to the end.

$ Selection#observeCache — Property in class Selection

should instance observe accessed columns caching

Selection::order() — Method in class Selection

Adds order clause, more calls appends to the end.

Selection::offsetSet() — Method in class Selection

Mimic row.

Selection::offsetGet() — Method in class Selection

Returns specified row.

Selection::offsetExists() — Method in class Selection

Tests if row exists.

Selection::offsetUnset() — Method in class Selection

Removes row from result set.

$ SqlBuilder#order — Property in class SqlBuilder

$ SqlBuilder#offset — Property in class SqlBuilder

P

$ ConnectionPanel#performanceScale — Property in class ConnectionPanel

PostgreSQLEngine — Class in namespace Nette\Database\Drivers\Engines

PostgreSQL database platform.

Explorer::preprocess() — Method in class Explorer

Helpers::parseColumnType() — Method in class Helpers

$ Table#primaryKey — Property in class Table

SqlPreprocessor::process() — Method in class SqlPreprocessor

$ Selection#primary — Property in class Selection

$ Selection#primarySequence — Property in class Selection

primary column sequence name, false for autodetection

$ Selection#previousAccessedColumns — Property in class Selection

Selection::page() — Method in class Selection

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

$ SqlBuilder#parameters — Property in class SqlBuilder

SqlBuilder::parseJoinConditions() — Method in class SqlBuilder

SqlBuilder::parseJoins() — Method in class SqlBuilder

SqlBuilder::parseJoinsCb() — Method in class SqlBuilder

Q

LazyConnection::query() — Method in class LazyConnection

Executes an SQL query with optional parameters and returns a result set.

LazyConnection::quote() — Method in class LazyConnection

Quotes a string for use in an SQL statement.

Connection::query() — Method in class Connection

Executes an SQL query with optional parameters and returns a result set.

Connection::quote() — Method in class Connection

Quotes a string for use in an SQL statement.

Connection::query() — Method in class Connection

Executes an SQL query with optional parameters and returns a result set.

Connection::quote() — Method in class Connection

Quotes a string for use in an SQL statement.

Explorer::quote() — Method in class Explorer

Explorer::query() — Method in class Explorer

Generates and executes SQL query.

Explorer::queryArgs() — Method in class Explorer

Selection::query() — Method in class Selection

R

ConnectionPanel::renderException() — Method in class ConnectionPanel

LazyConnection::rollBack() — Method in class LazyConnection

Rolls back the current database transaction.

Connection::rollBack() — Method in class Connection

Rolls back the current database transaction.

$ Connection#resultClass — Property in class Connection

Connection::rollBack() — Method in class Connection

Rolls back the current database transaction.

Result — Class in namespace Nette\Database\Drivers\PDO\PgSQL

Result — Class in namespace Nette\Database\Drivers\PDO

Result — Class in namespace Nette\Database\Drivers

Database query result set.

Explorer::reconnect() — Method in class Explorer

Explorer::rollBack() — Method in class Explorer

Reflection — Class in namespace Nette\Database

Result — Class in namespace Nette\Database

Represents a result set.

ResultSet — Class in namespace Nette\Database

Row — Class in namespace Nette\Database

Represents a single table row.

Structure::rebuild() — Method in class Structure

Structure::resolveFQTableName() — Method in class Structure

ActiveRow::ref() — Method in class ActiveRow

Returns referenced row.

ActiveRow::related() — Method in class ActiveRow

Returns referencing rows.

ActiveRow::removeAccessColumn() — Method in class ActiveRow

$ GroupedSelection#refTable — Property in class GroupedSelection

referenced table

$ GroupedSelection#refCacheCurrent — Property in class GroupedSelection

current assigned referencing array

$ Selection#rows — Property in class Selection

$ Selection#refCache — Property in class Selection

Selection::removeAccessColumn() — Method in class Selection

$ SqlBuilder#reservedTableNames — Property in class SqlBuilder

SqlBuilder::resetSelect() — Method in class SqlBuilder

S

StaticConventions — Class in namespace Nette\Database\Conventions

Conventions based on static definition.

SQLServerEngine — Class in namespace Nette\Database\Drivers\Engines

Microsoft SQL Server database platform.

SQLiteEngine — Class in namespace Nette\Database\Drivers\Engines

SQLite database platform.

Explorer::setRowNormalizer() — Method in class Explorer

Explorer::setCache() — Method in class Explorer

Explorer::setConventions() — Method in class Explorer

SqlLiteral — Class in namespace Nette\Database

SQL literal value.

SqlPreprocessor — Class in namespace Nette\Database

SQL preprocessor.

Structure — Class in namespace Nette\Database

Cached reflection of database structure.

$ Structure#structure — Property in class Structure

ActiveRow::setTable() — Method in class ActiveRow

GroupedSelection::setActive() — Method in class GroupedSelection

Sets active group.

GroupedSelection::select() — Method in class GroupedSelection

Adds select clause, more calls appends to the end.

Selection — Class in namespace Nette\Database\Table

Filtered table representation.

$ Selection#sqlBuilder — Property in class Selection

$ Selection#specificCacheKey — Property in class Selection

Selection::setPrimarySequence() — Method in class Selection

Selection::select() — Method in class Selection

Adds select clause, more calls appends to the end.

Selection::sum() — Method in class Selection

Returns sum of values in a column.

Selection::saveCacheState() — Method in class Selection

SqlBuilder — Class in namespace Nette\Database\Table

Builds SQL query.

$ SqlBuilder#select — Property in class SqlBuilder

SqlBuilder::setOrder() — Method in class SqlBuilder

SqlBuilder::setLimit() — Method in class SqlBuilder

SqlBuilder::setGroup() — Method in class SqlBuilder

SqlBuilder::setHaving() — Method in class SqlBuilder

T

Explorer::transaction() — Method in class Explorer

Explorer::table() — Method in class Explorer

Helpers::toPairs() — Method in class Helpers

Reformat source to key -> value pairs.

$ Reflection#tables — Property in class Reflection

Table — Class in namespace Nette\Database\Reflection

Table reflection.

ActiveRow::toArray() — Method in class ActiveRow

$ SqlBuilder#tableName — Property in class SqlBuilder

SqlBuilder::tryDelimit() — Method in class SqlBuilder

TypeConverter — Class in namespace Nette\Database

TypeConverter::toInt() — Method in class TypeConverter

TypeConverter::toFloat() — Method in class TypeConverter

TypeConverter::toBool() — Method in class TypeConverter

TypeConverter::toDateTime() — Method in class TypeConverter

TypeConverter::toTime() — Method in class TypeConverter

TypeConverter::toInterval() — Method in class TypeConverter

U

ActiveRow::update() — Method in class ActiveRow

Updates row.

GroupedSelection::update() — Method in class GroupedSelection

Updates all rows in result set.

Selection::update() — Method in class Selection

Updates all rows in result set.

UniqueConstraintViolationException — Class in namespace Nette\Database

Exception for a unique constraint violation.

W

Selection::wherePrimary() — Method in class Selection

Adds condition for primary key.

Selection::where() — Method in class Selection

Adds where condition, more calls appends with AND.

Selection::whereOr() — Method in class Selection

Adds where condition using the OR operator between parameters.

$ SqlBuilder#where — Property in class SqlBuilder

_

DatabaseExtension::__construct() — Method in class DatabaseExtension

ConnectionPanel::__construct() — Method in class ConnectionPanel

DiscoveredConventions::__construct() — Method in class DiscoveredConventions

StaticConventions::__construct() — Method in class StaticConventions

Create static conventional structure.

DateTime::__toString() — Method in class DateTime

Returns the date and time in the format 'Y-m-d H:i:s.u'.

DriverException::__construct() — Method in class DriverException

LazyConnection::__construct() — Method in class LazyConnection

MSSQLEngine::__construct() — Method in class MSSQLEngine

MySQLEngine::__construct() — Method in class MySQLEngine

OracleEngine::__construct() — Method in class OracleEngine

PostgreSQLEngine::__construct() — Method in class PostgreSQLEngine

SQLServerEngine::__construct() — Method in class SQLServerEngine

SQLiteEngine::__construct() — Method in class SQLiteEngine

Connection::__construct() — Method in class Connection

Driver::__construct() — Method in class Driver

Driver::__construct() — Method in class Driver

Driver::__construct() — Method in class Driver

Result::__construct() — Method in class Result

Driver::__construct() — Method in class Driver

Explorer::__construct() — Method in class Explorer

Reflection::__construct() — Method in class Reflection

Reflection::__get() — Method in class Reflection

Column::__construct() — Method in class Column

Column::__toString() — Method in class Column

ForeignKey::__construct() — Method in class ForeignKey

ForeignKey::__toString() — Method in class ForeignKey

Index::__construct() — Method in class Index

Index::__toString() — Method in class Index

Table::__construct() — Method in class Table

Table::__get() — Method in class Table

Table::__toString() — Method in class Table

Result::__construct() — Method in class Result

Row::__get() — Method in class Row

Row::__isset() — Method in class Row

SqlLiteral::__construct() — Method in class SqlLiteral

SqlLiteral::__toString() — Method in class SqlLiteral

SqlPreprocessor::__construct() — Method in class SqlPreprocessor

Structure::__construct() — Method in class Structure

ActiveRow::__construct() — Method in class ActiveRow

ActiveRow::__toString() — Method in class ActiveRow

ActiveRow::__set() — Method in class ActiveRow

ActiveRow::__get() — Method in class ActiveRow

ActiveRow::__isset() — Method in class ActiveRow

ActiveRow::__unset() — Method in class ActiveRow

GroupedSelection::__construct() — Method in class GroupedSelection

Creates filtered and grouped table representation.

Selection::__construct() — Method in class Selection

Creates filtered table representation.

Selection::__destruct() — Method in class Selection

Selection::__clone() — Method in class Selection

SqlBuilder::__construct() — Method in class SqlBuilder