A

AmbiguousReferenceKeyExceptionClass in namespace Nette\Database\Conventions

Ambiguous reference key exception.

Driver::applyLimit() — Method in class Driver

Injects LIMIT/OFFSET to the SQL query.

MsSqlDriver::applyLimit() — Method in class MsSqlDriver

Injects LIMIT/OFFSET to the SQL query.

MySqlDriver::applyLimit() — Method in class MySqlDriver

Injects LIMIT/OFFSET to the SQL query.

OciDriver::applyLimit() — Method in class OciDriver

Injects LIMIT/OFFSET to the SQL query.

OdbcDriver::applyLimit() — Method in class OdbcDriver

Injects LIMIT/OFFSET to the SQL query.

PgSqlDriver::applyLimit() — Method in class PgSqlDriver

Injects LIMIT/OFFSET to the SQL query.

SqliteDriver::applyLimit() — Method in class SqliteDriver

Injects LIMIT/OFFSET to the SQL query.

SqlsrvDriver::applyLimit() — Method in class SqlsrvDriver

Injects LIMIT/OFFSET to the SQL query.

Structure::analyzePrimaryKey() — Method in class Structure
Structure::analyzeForeignKeys() — Method in class Structure
ActiveRowClass in namespace Nette\Database\Table

Single row representation.

ActiveRow::accessColumn() — Method in class ActiveRow
$ GroupedSelection#activeProperty in class GroupedSelection
GroupedSelection::aggregation() — Method in class GroupedSelection
$ Selection#aggregationProperty in class Selection
$ Selection#accessedColumnsProperty 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#aliasesProperty 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
Connection::beginTransaction() — Method in class Connection
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

ConnectionPanelClass in namespace Nette\Bridges\DatabaseTracy

Debug panel for Nette\Database.

ConnectionClass in namespace Nette\Database

Represents a connection between PHP and a database server.

Connection::connect() — Method in class Connection
Connection::commit() — Method in class Connection
ConnectionExceptionClass in namespace Nette\Database

Server connection related errors.

ConstraintViolationExceptionClass in namespace Nette\Database

Base class for all constraint violation related exceptions.

ContextClass in namespace Nette\Database
ConventionsClass in namespace Nette\Database
Driver::convertException() — Method in class Driver

Converts PDOException to DriverException or its descendant.

MsSqlDriver::convertException() — Method in class MsSqlDriver

Converts PDOException to DriverException or its descendant.

MySqlDriver::convertException() — Method in class MySqlDriver

Converts PDOException to DriverException or its descendant.

OciDriver::convertException() — Method in class OciDriver

Converts PDOException to DriverException or its descendant.

OdbcDriver::convertException() — Method in class OdbcDriver

Converts PDOException to DriverException or its descendant.

PgSqlDriver::convertException() — Method in class PgSqlDriver

Converts PDOException to DriverException or its descendant.

SqliteDriver::convertException() — Method in class SqliteDriver

Converts PDOException to DriverException or its descendant.

SqlsrvDriver::convertException() — Method in class SqlsrvDriver

Converts PDOException to DriverException or its descendant.

Explorer::commit() — Method in class Explorer
Helpers::createDebugPanel() — Method in class Helpers
ResultSet::current() — Method in class ResultSet
$ Structure#connectionProperty in class Structure
$ Structure#cacheProperty in class Structure
$ GroupedSelection#columnProperty in class GroupedSelection
GroupedSelection::count() — Method in class GroupedSelection

Counts number of rows.

$ Selection#contextProperty in class Selection
$ Selection#conventionsProperty in class Selection
$ Selection#cacheProperty 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.

Selection::createRow() — Method in class Selection
Selection::createSelectionInstance() — Method in class Selection
Selection::createGroupedSelectionInstance() — Method in class Selection
Selection::current() — Method in class Selection
$ SqlBuilder#conventionsProperty in class SqlBuilder
$ SqlBuilder#conditionsProperty in class SqlBuilder
$ SqlBuilder#currentAliasProperty in class SqlBuilder
SqlBuilder::checkUniqueTableName() — Method in class SqlBuilder

D

DatabaseExtensionClass in namespace Nette\Bridges\DatabaseDI

Nette Framework Database services.

$ ConnectionPanel#disabledProperty in class ConnectionPanel
Connection::disconnect() — Method in class Connection
DiscoveredConventionsClass in namespace Nette\Database\Conventions

Conventions based on database structure.

DriverClass in namespace Nette\Database

Supplemental PDO database driver.

Driver::delimite() — Method in class Driver

Delimites identifier for use in a SQL statement.

DriverExceptionClass in namespace Nette\Database

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

MsSqlDriver::delimite() — Method in class MsSqlDriver

Delimites identifier for use in a SQL statement.

MySqlDriver::delimite() — Method in class MySqlDriver

Delimites identifier for use in a SQL statement.

OciDriver::delimite() — Method in class OciDriver

Delimites identifier for use in a SQL statement.

OdbcDriver::delimite() — Method in class OdbcDriver

Delimites identifier for use in a SQL statement.

PgSqlDriver::delimite() — Method in class PgSqlDriver

Delimites identifier for use in a SQL statement.

SqliteDriver::delimite() — Method in class SqliteDriver

Delimites identifier for use in a SQL statement.

SqlsrvDriver::delimite() — Method in class SqlsrvDriver

Delimites identifier for use in a SQL statement.

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.

Helpers::detectTypes() — Method in class Helpers

Common column type detection.

Helpers::detectType() — Method in class Helpers

Heuristic column type detection.

ResultSet::dump() — Method in class ResultSet

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#dataProperty in class Selection
$ Selection#dataRefreshedProperty in class Selection
Selection::delete() — Method in class Selection

Deletes all rows in result set.

$ SqlBuilder#delimitedTableProperty in class SqlBuilder

E

$ ConnectionPanel#explainProperty in class ConnectionPanel
ExplorerClass in namespace Nette\Database

Database explorer.

GroupedSelection::execute() — Method in class GroupedSelection
GroupedSelection::emptyResultSet() — Method in class GroupedSelection
$ Selection#explorerProperty in class Selection
Selection::execute() — Method in class Selection
Selection::emptyResultSet() — Method in class Selection

F

Connection::fetch() — Method in class Connection

Shortcut for query()->fetch()

Connection::fetchField() — Method in class Connection

Shortcut for query()->fetchField()

Connection::fetchFields() — Method in class Connection

Shortcut for query()->fetchFields()

Connection::fetchPairs() — Method in class Connection

Shortcut for query()->fetchPairs()

Connection::fetchAll() — Method in class Connection

Shortcut for query()->fetchAll()

$ StaticConventions#foreignProperty in class StaticConventions
Driver::formatDateTime() — Method in class Driver

Formats date-time for use in a SQL statement.

Driver::formatDateInterval() — Method in class Driver

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

Driver::formatLike() — Method in class Driver

Encodes string for use in a LIKE statement.

DriverException::from() — Method in class DriverException
MsSqlDriver::formatDateTime() — Method in class MsSqlDriver

Formats date-time for use in a SQL statement.

MsSqlDriver::formatDateInterval() — Method in class MsSqlDriver

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

MsSqlDriver::formatLike() — Method in class MsSqlDriver

Encodes string for use in a LIKE statement.

MySqlDriver::formatDateTime() — Method in class MySqlDriver

Formats date-time for use in a SQL statement.

MySqlDriver::formatDateInterval() — Method in class MySqlDriver

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

MySqlDriver::formatLike() — Method in class MySqlDriver

Encodes string for use in a LIKE statement.

OciDriver::formatDateTime() — Method in class OciDriver

Formats date-time for use in a SQL statement.

OciDriver::formatDateInterval() — Method in class OciDriver

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

OciDriver::formatLike() — Method in class OciDriver

Encodes string for use in a LIKE statement.

OdbcDriver::formatDateTime() — Method in class OdbcDriver

Formats date-time for use in a SQL statement.

OdbcDriver::formatDateInterval() — Method in class OdbcDriver

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

OdbcDriver::formatLike() — Method in class OdbcDriver

Encodes string for use in a LIKE statement.

PgSqlDriver::formatDateTime() — Method in class PgSqlDriver

Formats date-time for use in a SQL statement.

PgSqlDriver::formatDateInterval() — Method in class PgSqlDriver

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

PgSqlDriver::formatLike() — Method in class PgSqlDriver

Encodes string for use in a LIKE statement.

SqliteDriver::formatDateTime() — Method in class SqliteDriver

Formats date-time for use in a SQL statement.

SqliteDriver::formatDateInterval() — Method in class SqliteDriver

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

SqliteDriver::formatLike() — Method in class SqliteDriver

Encodes string for use in a LIKE statement.

SqlsrvDriver::formatDateTime() — Method in class SqlsrvDriver

Formats date-time for use in a SQL statement.

SqlsrvDriver::formatDateInterval() — Method in class SqlsrvDriver

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

SqlsrvDriver::formatLike() — Method in class SqlsrvDriver

Encodes string for use in a LIKE statement.

Explorer::fetch() — Method in class Explorer

Shortcut for query()->fetch()

Explorer::fetchField() — Method in class Explorer

Shortcut for query()->fetchField()

Explorer::fetchFields() — Method in class Explorer

Shortcut for query()->fetchFields()

Explorer::fetchPairs() — Method in class Explorer

Shortcut for query()->fetchPairs()

Explorer::fetchAll() — Method in class Explorer

Shortcut for query()->fetchAll()

ForeignKeyConstraintViolationExceptionClass in namespace Nette\Database

Exception for a foreign key constraint violation.

Helpers::findDuplicates() — Method in class Helpers

Finds duplicate columns in select statement

ResultSet::fetch() — Method in class ResultSet

Fetches single row object.

ResultSet::fetchField() — Method in class ResultSet

Fetches single field.

ResultSet::fetchFields() — Method in class ResultSet

Fetches array of fields.

ResultSet::fetchPairs() — Method in class ResultSet

Fetches all rows as associative array.

ResultSet::fetchAll() — Method in class ResultSet

Fetches all rows.

ResultSet::fetchAssoc() — Method in class ResultSet

Fetches all rows and returns associative tree.

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
Connection::getDsn() — Method in class Connection
Connection::getPdo() — Method in class Connection
Connection::getDriver() — Method in class Connection
Connection::getSupplementalDriver() — Method in class Connection
Connection::getInsertId() — Method in class Connection
Connection::getLastQueryString() — Method in class Connection
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
Driver::getTables() — Method in class Driver

Returns list of tables as tuples [(string) name, (bool) view, [(string) fullName]]

Driver::getColumns() — Method in class Driver

Returns metadata for all columns in a table.

Driver::getIndexes() — Method in class Driver

Returns metadata for all indexes in a table.

Driver::getForeignKeys() — Method in class Driver

Returns metadata for all foreign keys in a table.

Driver::getColumnTypes() — Method in class Driver

Returns associative array of detected types (IStructure::FIELD_*) in result set.

DriverException::getDriverCode() — Method in class DriverException
DriverException::getSqlState() — Method in class DriverException
DriverException::getQueryString() — Method in class DriverException
DriverException::getParameters() — Method in class DriverException
MsSqlDriver::getTables() — Method in class MsSqlDriver

Returns list of tables as tuples [(string) name, (bool) view, [(string) fullName]]

MsSqlDriver::getColumns() — Method in class MsSqlDriver

Returns metadata for all columns in a table.

MsSqlDriver::getIndexes() — Method in class MsSqlDriver

Returns metadata for all indexes in a table.

MsSqlDriver::getForeignKeys() — Method in class MsSqlDriver

Returns metadata for all foreign keys in a table.

MsSqlDriver::getColumnTypes() — Method in class MsSqlDriver

Returns associative array of detected types (IStructure::FIELD_*) in result set.

MySqlDriver::getTables() — Method in class MySqlDriver

Returns list of tables as tuples [(string) name, (bool) view, [(string) fullName]]

MySqlDriver::getColumns() — Method in class MySqlDriver

Returns metadata for all columns in a table.

MySqlDriver::getIndexes() — Method in class MySqlDriver

Returns metadata for all indexes in a table.

MySqlDriver::getForeignKeys() — Method in class MySqlDriver

Returns metadata for all foreign keys in a table.

MySqlDriver::getColumnTypes() — Method in class MySqlDriver

Returns associative array of detected types (IStructure::FIELD_*) in result set.

OciDriver::getTables() — Method in class OciDriver

Returns list of tables as tuples [(string) name, (bool) view, [(string) fullName]]

OciDriver::getColumns() — Method in class OciDriver

Returns metadata for all columns in a table.

OciDriver::getIndexes() — Method in class OciDriver

Returns metadata for all indexes in a table.

OciDriver::getForeignKeys() — Method in class OciDriver

Returns metadata for all foreign keys in a table.

OciDriver::getColumnTypes() — Method in class OciDriver

Returns associative array of detected types (IStructure::FIELD_*) in result set.

OdbcDriver::getTables() — Method in class OdbcDriver

Returns list of tables as tuples [(string) name, (bool) view, [(string) fullName]]

OdbcDriver::getColumns() — Method in class OdbcDriver

Returns metadata for all columns in a table.

OdbcDriver::getIndexes() — Method in class OdbcDriver

Returns metadata for all indexes in a table.

OdbcDriver::getForeignKeys() — Method in class OdbcDriver

Returns metadata for all foreign keys in a table.

OdbcDriver::getColumnTypes() — Method in class OdbcDriver

Returns associative array of detected types (IStructure::FIELD_*) in result set.

PgSqlDriver::getTables() — Method in class PgSqlDriver

Returns list of tables as tuples [(string) name, (bool) view, [(string) fullName]]

PgSqlDriver::getColumns() — Method in class PgSqlDriver

Returns metadata for all columns in a table.

PgSqlDriver::getIndexes() — Method in class PgSqlDriver

Returns metadata for all indexes in a table.

PgSqlDriver::getForeignKeys() — Method in class PgSqlDriver

Returns metadata for all foreign keys in a table.

PgSqlDriver::getColumnTypes() — Method in class PgSqlDriver

Returns associative array of detected types (IStructure::FIELD_*) in result set.

SqliteDriver::getTables() — Method in class SqliteDriver

Returns list of tables as tuples [(string) name, (bool) view, [(string) fullName]]

SqliteDriver::getColumns() — Method in class SqliteDriver

Returns metadata for all columns in a table.

SqliteDriver::getIndexes() — Method in class SqliteDriver

Returns metadata for all indexes in a table.

SqliteDriver::getForeignKeys() — Method in class SqliteDriver

Returns metadata for all foreign keys in a table.

SqliteDriver::getColumnTypes() — Method in class SqliteDriver

Returns associative array of detected types (IStructure::FIELD_*) in result set.

SqlsrvDriver::getTables() — Method in class SqlsrvDriver

Returns list of tables as tuples [(string) name, (bool) view, [(string) fullName]]

SqlsrvDriver::getColumns() — Method in class SqlsrvDriver

Returns metadata for all columns in a table.

SqlsrvDriver::getIndexes() — Method in class SqlsrvDriver

Returns metadata for all indexes in a table.

SqlsrvDriver::getForeignKeys() — Method in class SqlsrvDriver

Returns metadata for all foreign keys in a table.

SqlsrvDriver::getColumnTypes() — Method in class SqlsrvDriver

Returns associative array of detected types (IStructure::FIELD_*) in result set.

Explorer::getInsertId() — Method in class Explorer
Explorer::getConnection() — Method in class Explorer
Explorer::getStructure() — Method in class Explorer
Explorer::getConventions() — Method in class Explorer
IStructure::getTables() — Method in class IStructure

Returns tables list.

IStructure::getColumns() — Method in class IStructure

Returns table columns list.

IStructure::getPrimaryKey() — Method in class IStructure

Returns table primary key.

IStructure::getPrimaryAutoincrementKey() — Method in class IStructure

Returns autoincrement primary key name.

IStructure::getPrimaryKeySequence() — Method in class IStructure

Returns table primary key sequence.

IStructure::getHasManyReference() — Method in class IStructure

Returns hasMany reference.

IStructure::getBelongsToReference() — Method in class IStructure

Returns belongsTo reference.

ResultSet::getConnection() — Method in class ResultSet
ResultSet::getPdoStatement() — Method in class ResultSet
ResultSet::getQueryString() — Method in class ResultSet
ResultSet::getParameters() — Method in class ResultSet
ResultSet::getColumnCount() — Method in class ResultSet
ResultSet::getRowCount() — Method in class ResultSet
ResultSet::getColumnTypes() — Method in class ResultSet
ResultSet::getTime() — Method in class ResultSet
SqlLiteral::getParameters() — Method in class SqlLiteral
Structure::getTables() — Method in class Structure

Returns tables list.

Structure::getColumns() — Method in class Structure

Returns table columns list.

Structure::getPrimaryKey() — Method in class Structure
Structure::getPrimaryAutoincrementKey() — Method in class Structure

Returns autoincrement primary key name.

Structure::getPrimaryKeySequence() — Method in class Structure

Returns table primary key sequence.

Structure::getHasManyReference() — Method in class Structure

Returns hasMany reference.

Structure::getBelongsToReference() — Method in class Structure

Returns belongsTo reference.

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
GroupedSelectionClass 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#globalRefCacheProperty in class Selection
$ Selection#generalCacheKeyProperty 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.

$ SqlBuilder#groupProperty 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

HelpersClass in namespace Nette\Database

Database helpers.

Selection::having() — Method in class Selection

Sets having clause, more calls rewrite old value.

$ SqlBuilder#havingProperty in class SqlBuilder

I

Driver::initialize() — Method in class Driver

Initializes connection.

Driver::isSupported() — Method in class Driver

Cheks if driver supports specific property

MsSqlDriver::initialize() — Method in class MsSqlDriver

Initializes connection.

MsSqlDriver::isSupported() — Method in class MsSqlDriver

Cheks if driver supports specific property

MySqlDriver::initialize() — Method in class MySqlDriver

Driver options:

MySqlDriver::isSupported() — Method in class MySqlDriver

Cheks if driver supports specific property

OciDriver::initialize() — Method in class OciDriver

Initializes connection.

OciDriver::isSupported() — Method in class OciDriver

Cheks if driver supports specific property

OdbcDriver::initialize() — Method in class OdbcDriver

Initializes connection.

OdbcDriver::isSupported() — Method in class OdbcDriver

Cheks if driver supports specific property

PgSqlDriver::initialize() — Method in class PgSqlDriver

Initializes connection.

PgSqlDriver::isSupported() — Method in class PgSqlDriver

Cheks if driver supports specific property

SqliteDriver::initialize() — Method in class SqliteDriver

Initializes connection.

SqliteDriver::isSupported() — Method in class SqliteDriver

Cheks if driver supports specific property

SqlsrvDriver::initialize() — Method in class SqlsrvDriver

Initializes connection.

SqlsrvDriver::isSupported() — Method in class SqlsrvDriver

Cheks if driver supports specific property

Helpers::initializeTracy() — Method in class Helpers
IConventionsClass in namespace Nette\Database
IRowClass in namespace Nette\Database
IRowContainerClass in namespace Nette\Database
IStructureClass in namespace Nette\Database

Provides cached reflection for database structure.

IStructure::isRebuilt() — Method in class IStructure

Returns true if database cached structure has been rebuilt.

ISupplementalDriverClass in namespace Nette\Database
$ Structure#isRebuiltProperty in class Structure
Structure::isRebuilt() — Method in class Structure

Returns true if database cached structure has been rebuilt.

GroupedSelection::insert() — Method in class GroupedSelection

Inserts row in a table.

IRowClass in namespace Nette\Database\Table
IRowContainerClass in namespace Nette\Database\Table
Selection::insert() — Method in class Selection

Inserts row in a table.

SqlBuilder::importConditions() — Method in class SqlBuilder
SqlBuilder::importGroupConditions() — Method in class SqlBuilder

J

Selection::joinWhere() — Method in class Selection

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

$ SqlBuilder#joinConditionProperty in class SqlBuilder

K

ResultSet::key() — Method in class ResultSet
$ Selection#keysProperty in class Selection
Selection::key() — Method in class Selection

L

DatabaseExtension::loadConfiguration() — Method in class DatabaseExtension
Connection::literal() — Method in class Connection
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#limitProperty in class SqlBuilder

M

$ ConnectionPanel#maxQueriesProperty in class ConnectionPanel
MsSqlDriverClass in namespace Nette\Database\Drivers

Supplemental MS SQL database driver.

MySqlDriverClass in namespace Nette\Database\Drivers

Supplemental MySQL database driver.

$ Helpers#maxLengthProperty in class Helpers
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#nameProperty in class ConnectionPanel
Helpers::normalizeRow() — Method in class Helpers
NotNullConstraintViolationExceptionClass in namespace Nette\Database

Exception for a NOT NULL constraint violation.

ResultSet::normalizeRow() — Method in class ResultSet
ResultSet::next() — Method in class ResultSet
Structure::needStructure() — Method in class Structure
$ Selection#nameProperty in class Selection
Selection::next() — Method in class Selection

O

$ Connection#onConnectProperty in class Connection
$ Connection#onQueryProperty in class Connection
OciDriverClass in namespace Nette\Database\Drivers

Supplemental Oracle database driver.

OdbcDriverClass in namespace Nette\Database\Drivers

Supplemental ODBC database driver.

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
$ Selection#observeCacheProperty in class Selection
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#orderProperty in class SqlBuilder
$ SqlBuilder#offsetProperty in class SqlBuilder

P

$ ConnectionPanel#performanceScaleProperty in class ConnectionPanel
Connection::preprocess() — Method in class Connection
$ StaticConventions#primaryProperty in class StaticConventions
$ DriverException#paramsProperty in class DriverException
PgSqlDriverClass in namespace Nette\Database\Drivers

Supplemental PostgreSQL database driver.

SqlPreprocessor::process() — Method in class SqlPreprocessor
$ Selection#primaryProperty in class Selection
$ Selection#primarySequenceProperty in class Selection
$ Selection#previousAccessedColumnsProperty in class Selection
Selection::page() — Method in class Selection

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

$ SqlBuilder#parametersProperty in class SqlBuilder
SqlBuilder::parseJoinConditions() — Method in class SqlBuilder
SqlBuilder::parseJoins() — Method in class SqlBuilder
SqlBuilder::parseJoinsCb() — Method in class SqlBuilder

Q

Connection::quote() — Method in class Connection
Connection::query() — Method in class Connection

Generates and executes SQL query.

Connection::queryArgs() — Method in class Connection
$ DriverException#queryStringProperty in class DriverException
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
Connection::reconnect() — Method in class Connection
Connection::rollBack() — Method in class Connection
Explorer::rollBack() — Method in class Explorer
IStructure::rebuild() — Method in class IStructure

Rebuilds database structure cache.

ResultSetClass in namespace Nette\Database

Represents a result set.

ResultSet::rewind() — Method in class ResultSet
RowClass in namespace Nette\Database

Represents a single table row.

Structure::rebuild() — Method in class Structure

Rebuilds database structure cache.

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#refTableProperty in class GroupedSelection
$ GroupedSelection#refCacheCurrentProperty in class GroupedSelection
$ Selection#rowsProperty in class Selection
$ Selection#refCacheProperty in class Selection
Selection::removeAccessColumn() — Method in class Selection
Selection::rewind() — Method in class Selection
$ SqlBuilder#reservedTableNamesProperty in class SqlBuilder
SqlBuilder::resetSelect() — Method in class SqlBuilder

S

Connection::setRowNormalizer() — Method in class Connection
$ DiscoveredConventions#structureProperty in class DiscoveredConventions
StaticConventionsClass in namespace Nette\Database\Conventions

Conventions based on static definition.

SqliteDriverClass in namespace Nette\Database\Drivers

Supplemental SQLite3 database driver.

SqlsrvDriverClass in namespace Nette\Database\Drivers

Supplemental SQL Server 2005 and later database driver.

SqlLiteralClass in namespace Nette\Database

SQL literal value.

SqlPreprocessorClass in namespace Nette\Database

SQL preprocessor.

StructureClass in namespace Nette\Database

Cached reflection of database structure.

$ Structure#structureProperty in class Structure
ActiveRow::setTable() — Method in class ActiveRow
GroupedSelection::setActive() — Method in class GroupedSelection

Sets active group.

GroupedSelection::select() — Method in class GroupedSelection
SelectionClass in namespace Nette\Database\Table

Filtered table representation.

$ Selection#sqlBuilderProperty in class Selection
$ Selection#specificCacheKeyProperty 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
SqlBuilderClass in namespace Nette\Database\Table

Builds SQL query.

$ SqlBuilder#selectProperty 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

Connection::transaction() — Method in class Connection
$ StaticConventions#tableProperty in class StaticConventions
Explorer::transaction() — Method in class Explorer
Explorer::table() — Method in class Explorer
$ Helpers#typePatternsProperty in class Helpers
Helpers::toPairs() — Method in class Helpers

Reformat source to key -> value pairs.

ActiveRow::toArray() — Method in class ActiveRow
$ SqlBuilder#tableNameProperty in class SqlBuilder
SqlBuilder::tryDelimite() — Method in class SqlBuilder

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.

UniqueConstraintViolationExceptionClass in namespace Nette\Database

Exception for a unique constraint violation.

V

ResultSet::valid() — Method in class ResultSet
Selection::valid() — Method in class Selection

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#whereProperty in class SqlBuilder

_

DatabaseExtension::__construct() — Method in class DatabaseExtension
ConnectionPanel::__construct() — Method in class ConnectionPanel
Connection::__construct() — Method in class Connection
DiscoveredConventions::__construct() — Method in class DiscoveredConventions
StaticConventions::__construct() — Method in class StaticConventions

Create static conventional structure.

Explorer::__construct() — Method in class Explorer
ResultSet::__construct() — Method in class ResultSet
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