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::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: - charset => character encoding to set (default is utf8 or utf8mb4 since MySQL 5.5.3) - sqlmode => see http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
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
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

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

$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

$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