A

AmbiguousReferenceKeyExceptionClass in namespace Nette\Database\Conventions

Ambiguous reference key exception.

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.

ISupplementalDriver::applyLimit() — Method in class ISupplementalDriver

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

Executes aggregation function.

$ 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

Connection::beginTransaction() — Method in class Connection
Context::beginTransaction() — Method in class Context
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

Database context.

Context::commit() — Method in class Context
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.

Helpers::createDebugPanel() — Method in class Helpers
ISupplementalDriver::convertException() — Method in class ISupplementalDriver

Converts PDOException to DriverException or its descendant.

ResultSet::current() — Method in class ResultSet
SqlPreprocessor::callback() — Method in class SqlPreprocessor
$ Structure#connectionProperty in class Structure
$ Structure#cacheProperty in class Structure
$ GroupedSelection#columnProperty in class GroupedSelection
GroupedSelection::count() — Method in class GroupedSelection
$ 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.

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

Conventions based on database structure.

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.

ISupplementalDriver::delimite() — Method in class ISupplementalDriver

Delimites identifier for use in a SQL statement.

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
GroupedSelection::execute() — Method in class GroupedSelection
GroupedSelection::emptyResultSet() — Method in class GroupedSelection
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()

Context::fetch() — Method in class Context

Shortcut for query()->fetch()

Context::fetchField() — Method in class Context

Shortcut for query()->fetchField()

Context::fetchFields() — Method in class Context

Shortcut for query()->fetchFields()

Context::fetchPairs() — Method in class Context

Shortcut for query()->fetchPairs()

Context::fetchAll() — Method in class Context

Shortcut for query()->fetchAll()

$ StaticConventions#foreignProperty in class StaticConventions
DriverException::from() — Method in class DriverException
MsSqlDriver::formatBool() — Method in class MsSqlDriver

Formats boolean for use in a SQL statement.

MsSqlDriver::formatDateTime() — Method in class MsSqlDriver

Formats date-time for use in a SQL statement.

MsSqlDriver::formatDateInterval() — Method in class MsSqlDriver
MsSqlDriver::formatLike() — Method in class MsSqlDriver

Encodes string for use in a LIKE statement.

MySqlDriver::formatBool() — Method in class MySqlDriver

Formats boolean for use in a SQL statement.

MySqlDriver::formatDateTime() — Method in class MySqlDriver

Formats date-time for use in a SQL statement.

MySqlDriver::formatDateInterval() — Method in class MySqlDriver
MySqlDriver::formatLike() — Method in class MySqlDriver

Encodes string for use in a LIKE statement.

OciDriver::formatBool() — Method in class OciDriver

Formats boolean for use in a SQL statement.

OciDriver::formatDateTime() — Method in class OciDriver

Formats date-time for use in a SQL statement.

OciDriver::formatDateInterval() — Method in class OciDriver
OciDriver::formatLike() — Method in class OciDriver

Encodes string for use in a LIKE statement.

OdbcDriver::formatBool() — Method in class OdbcDriver

Formats boolean for use in a SQL statement.

OdbcDriver::formatDateTime() — Method in class OdbcDriver

Formats date-time for use in a SQL statement.

OdbcDriver::formatDateInterval() — Method in class OdbcDriver
OdbcDriver::formatLike() — Method in class OdbcDriver

Encodes string for use in a LIKE statement.

PgSqlDriver::formatBool() — Method in class PgSqlDriver

Formats boolean for use in a SQL statement.

PgSqlDriver::formatDateTime() — Method in class PgSqlDriver

Formats date-time for use in a SQL statement.

PgSqlDriver::formatDateInterval() — Method in class PgSqlDriver
PgSqlDriver::formatLike() — Method in class PgSqlDriver

Encodes string for use in a LIKE statement.

Sqlite2Driver::formatLike() — Method in class Sqlite2Driver

Encodes string for use in a LIKE statement.

SqliteDriver::formatBool() — Method in class SqliteDriver

Formats boolean for use in a SQL statement.

SqliteDriver::formatDateTime() — Method in class SqliteDriver

Formats date-time for use in a SQL statement.

SqliteDriver::formatDateInterval() — Method in class SqliteDriver
SqliteDriver::formatLike() — Method in class SqliteDriver

Encodes string for use in a LIKE statement.

SqlsrvDriver::formatBool() — Method in class SqlsrvDriver

Formats boolean for use in a SQL statement.

SqlsrvDriver::formatDateTime() — Method in class SqlsrvDriver

Formats date-time for use in a SQL statement.

SqlsrvDriver::formatDateInterval() — Method in class SqlsrvDriver
SqlsrvDriver::formatLike() — Method in class SqlsrvDriver

Encodes string for use in a LIKE statement.

ForeignKeyConstraintViolationExceptionClass in namespace Nette\Database

Exception for a foreign key constraint violation.

Helpers::findDuplicates() — Method in class Helpers

Finds duplicate columns in select statement

IRowContainer::fetch() — Method in class IRowContainer

Fetches single row object.

IRowContainer::fetchPairs() — Method in class IRowContainer

Fetches all rows as associative array.

IRowContainer::fetchAll() — Method in class IRowContainer

Fetches all rows.

IRowContainer::fetchAssoc() — Method in class IRowContainer

Fetches all rows and returns associative tree.

ISupplementalDriver::formatBool() — Method in class ISupplementalDriver

Formats boolean for use in a SQL statement.

ISupplementalDriver::formatDateTime() — Method in class ISupplementalDriver

Formats date-time for use in a SQL statement.

ISupplementalDriver::formatLike() — Method in class ISupplementalDriver

Encodes string for use in a LIKE 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.

IRowContainer::fetch() — Method in class IRowContainer

Fetches single row object.

IRowContainer::fetchAll() — Method in class IRowContainer

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

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::getSupplementalDriver() — Method in class Connection
Connection::getInsertId() — Method in class Connection
Connection::getLastQueryString() — Method in class Connection
Context::getInsertId() — Method in class Context
Context::getConnection() — Method in class Context
Context::getStructure() — Method in class Context
Context::getConventions() — Method in class Context
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::getQueryString() — Method in class DriverException
MsSqlDriver::getTables() — Method in class MsSqlDriver

Returns list of tables.

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.

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.

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.

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.

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.

Sqlite2Driver::getForeignKeys() — Method in class Sqlite2Driver

Returns metadata for all foreign keys in a table.

Sqlite2Driver::getColumnTypes() — Method in class Sqlite2Driver

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

SqliteDriver::getTables() — Method in class SqliteDriver

Returns list of tables.

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.

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.

IConventions::getPrimary() — Method in class IConventions

Returns primary key for table.

IConventions::getHasManyReference() — Method in class IConventions

Returns referenced table & referenced column.

IConventions::getBelongsToReference() — Method in class IConventions

Returns referenced table & referencing column.

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::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.

ISupplementalDriver::getTables() — Method in class ISupplementalDriver

Returns list of tables.

ISupplementalDriver::getColumns() — Method in class ISupplementalDriver

Returns metadata for all columns in a table.

ISupplementalDriver::getIndexes() — Method in class ISupplementalDriver

Returns metadata for all indexes in a table.

ISupplementalDriver::getForeignKeys() — Method in class ISupplementalDriver

Returns metadata for all foreign keys in a table.

ISupplementalDriver::getColumnTypes() — Method in class ISupplementalDriver

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

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::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

Returns table primary key.

Structure::getPrimaryAutoincrementKey() — Method in class Structure
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
IRow::getTable() — Method in class IRow
IRow::getPrimary() — Method in class IRow

Returns primary key value.

IRow::getSignature() — Method in class IRow

Returns row signature (composition of primary keys)

$ 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

MsSqlDriver::isSupported() — Method in class MsSqlDriver

Cheks if driver supports specific property

MySqlDriver::isSupported() — Method in class MySqlDriver

Cheks if driver supports specific property

OciDriver::isSupported() — Method in class OciDriver

Cheks if driver supports specific property

OdbcDriver::isSupported() — Method in class OdbcDriver

Cheks if driver supports specific property

PgSqlDriver::isSupported() — Method in class PgSqlDriver

Cheks if driver supports specific property

SqliteDriver::isSupported() — Method in class SqliteDriver

Cheks if driver supports specific property

SqlsrvDriver::isSupported() — Method in class SqlsrvDriver

Cheks if driver supports specific property

IConventionsClass in namespace Nette\Database
IRowClass in namespace Nette\Database

Row interface.

IRowContainerClass in namespace Nette\Database

Container of database result fetched into IRow.

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

Supplemental PDO database driver.

ISupplementalDriver::isSupported() — Method in class ISupplementalDriver

Cheks if driver supports specific property

$ 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

Row interface.

IRowContainerClass in namespace Nette\Database\Table

Container of database result fetched into IRow objects.

Selection::insert() — Method in class Selection

Inserts row in a table.

SqlBuilder::importConditions() — 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
ConnectionPanel::logQuery() — Method in class ConnectionPanel
Connection::literal() — Method in class Connection
Context::literal() — Method in class Context
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
MsSqlDriver::normalizeRow() — Method in class MsSqlDriver

Normalizes result row.

MySqlDriver::normalizeRow() — Method in class MySqlDriver

Normalizes result row.

OciDriver::normalizeRow() — Method in class OciDriver

Normalizes result row.

OdbcDriver::normalizeRow() — Method in class OdbcDriver

Normalizes result row.

PgSqlDriver::normalizeRow() — Method in class PgSqlDriver

Normalizes result row.

SqliteDriver::normalizeRow() — Method in class SqliteDriver

Normalizes result row.

SqlsrvDriver::normalizeRow() — Method in class SqlsrvDriver

Normalizes result row.

ISupplementalDriver::normalizeRow() — Method in class ISupplementalDriver

Normalizes result row.

NotNullConstraintViolationExceptionClass in namespace Nette\Database

Exception for a NOT NULL constraint violation.

ResultSet::normalizeRow() — Method in class ResultSet

Normalizes result row.

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

Connection::preprocess() — Method in class Connection
$ StaticConventions#primaryProperty in class StaticConventions
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
Context::query() — Method in class Context

Generates and executes SQL query.

Context::queryArgs() — Method in class Context
$ DriverException#queryStringProperty in class DriverException
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
Context::rollBack() — Method in class Context
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
IRow::related() — Method in class IRow

Returns referencing rows.

IRow::ref() — Method in class IRow

Returns referenced row.

$ 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

$ DiscoveredConventions#structureProperty in class DiscoveredConventions
StaticConventionsClass in namespace Nette\Database\Conventions

Conventions based on static definition.

Sqlite2DriverClass in namespace Nette\Database\Drivers

Supplemental SQLite2 database driver.

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
IRow::setTable() — Method in class IRow
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

Context::table() — Method in class Context
$ StaticConventions#tableProperty in class StaticConventions
$ 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
Context::__construct() — Method in class Context
DiscoveredConventions::__construct() — Method in class DiscoveredConventions
StaticConventions::__construct() — Method in class StaticConventions

Create static conventional structure.

MySqlDriver::__construct() — Method in class MySqlDriver

Driver options:

OciDriver::__construct() — Method in class OciDriver
PgSqlDriver::__construct() — Method in class PgSqlDriver
SqliteDriver::__construct() — Method in class SqliteDriver
SqlsrvDriver::__construct() — Method in class SqlsrvDriver
ResultSet::__construct() — Method in class ResultSet
Row::__get() — 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