Index | Nette Database API

A

AmbiguousReferenceKeyException — Class 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
ActiveRow — Class in namespace Nette\Database\Table: Single row representation.
ActiveRow::accessColumn() — Method in class ActiveRow
$ GroupedSelection#active — Property in class GroupedSelection
GroupedSelection::aggregation() — Method in class GroupedSelection
$ Selection#aggregation — Property in class Selection
$ Selection#accessedColumns — Property in class Selection
Selection::alias() — Method in class Selection: Aliases table. Example ':book:book_tag.tag', 'tg'
Selection::aggregation() — Method in class Selection: Executes aggregation function.
Selection::accessColumn() — Method in class Selection
$ SqlBuilder#aliases — Property in class SqlBuilder
SqlBuilder::addSelect() — Method in class SqlBuilder
SqlBuilder::addWhere() — Method in class SqlBuilder
SqlBuilder::addJoinCondition() — Method in class SqlBuilder
SqlBuilder::addCondition() — Method in class SqlBuilder
SqlBuilder::addAlias() — Method in class SqlBuilder: Adds alias.
SqlBuilder::addOrder() — Method in class SqlBuilder
SqlBuilder::addConditionComposition() — Method in class SqlBuilder

B

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

ConnectionPanel — Class in namespace Nette\Bridges\DatabaseTracy: Debug panel for Nette\Database.
Connection — Class 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
ConnectionException — Class in namespace Nette\Database: Server connection related errors.
ConstraintViolationException — Class in namespace Nette\Database: Base class for all constraint violation related exceptions.
Context — Class in namespace Nette\Database: 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#connection — Property in class Structure
$ Structure#cache — Property in class Structure
$ GroupedSelection#column — Property in class GroupedSelection
GroupedSelection::count() — Method in class GroupedSelection
$ Selection#context — Property in class Selection
$ Selection#conventions — Property in class Selection
$ Selection#cache — Property in class Selection
Selection::condition() — Method in class Selection: Adds condition, more calls appends with AND.
Selection::count() — Method in class Selection: Counts number of rows.
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#conventions — Property in class SqlBuilder
$ SqlBuilder#conditions — Property in class SqlBuilder
$ SqlBuilder#currentAlias — Property in class SqlBuilder
SqlBuilder::checkUniqueTableName() — Method in class SqlBuilder

D

DatabaseExtension — Class in namespace Nette\Bridges\DatabaseDI: Nette Framework Database services.
$ DatabaseExtension#databaseDefaults — Property in class DatabaseExtension
$ ConnectionPanel#disabled — Property in class ConnectionPanel
Connection::disconnect() — Method in class Connection
DiscoveredConventions — Class in namespace Nette\Database\Conventions: Conventions based on database structure.
DriverException — Class 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#data — Property in class Selection
$ Selection#dataRefreshed — Property in class Selection
Selection::delete() — Method in class Selection: Deletes all rows in result set.
$ SqlBuilder#delimitedTable — Property in class SqlBuilder

E

$ ConnectionPanel#explain — Property in class ConnectionPanel
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#foreign — Property 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.
ForeignKeyConstraintViolationException — Class 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
GroupedSelection — Class 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#globalRefCache — Property in class Selection
$ Selection#generalCacheKey — Property in class Selection
Selection::getName() — Method in class Selection
Selection::getPrimary() — Method in class Selection
Selection::getPrimarySequence() — Method in class Selection
Selection::getSql() — Method in class Selection
Selection::getPreviousAccessedColumns() — Method in class Selection: Loads cache of previous accessed columns and returns it.
Selection::getSqlBuilder() — Method in class Selection
Selection::get() — Method in class Selection: Returns row specified by primary key.
Selection::group() — Method in class Selection: Sets group clause, more calls rewrite old value.
Selection::getRefTable() — Method in class Selection: Returns Selection parent for caching.
Selection::getGeneralCacheKey() — Method in class Selection: Returns general cache key independent on query parameters or sql limit Used e.g. for previously accessed columns caching
Selection::getSpecificCacheKey() — Method in class Selection: Returns object specific cache key dependent on query parameters Used e.g. for reference memory caching
Selection::getDataRefreshed() — Method in class Selection: Returns if selection requeried for more columns.
Selection::getReferencedTable() — Method in class Selection: Returns referenced row.
Selection::getReferencingTable() — Method in class Selection: Returns referencing rows.
$ SqlBuilder#group — Property in class SqlBuilder
SqlBuilder::getTableName() — Method in class SqlBuilder
SqlBuilder::getSelectQueryHash() — Method in class SqlBuilder: Returns select query hash for caching.
SqlBuilder::getParameters() — Method in class SqlBuilder
SqlBuilder::getSelect() — Method in class SqlBuilder
SqlBuilder::getConditions() — Method in class SqlBuilder
SqlBuilder::getOrder() — Method in class SqlBuilder
SqlBuilder::getLimit() — Method in class SqlBuilder
SqlBuilder::getOffset() — Method in class SqlBuilder
SqlBuilder::getGroup() — Method in class SqlBuilder
SqlBuilder::getHaving() — Method in class SqlBuilder
SqlBuilder::getSortedJoins() — Method in class SqlBuilder

H

Helpers — Class in namespace Nette\Database: Database helpers.
Selection::having() — Method in class Selection: Sets having clause, more calls rewrite old value.
$ SqlBuilder#having — Property 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
IConventions — Class in namespace Nette\Database
IRow — Class in namespace Nette\Database: Row interface.
IRowContainer — Class in namespace Nette\Database: Container of database result fetched into IRow.
IStructure — Class 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.
ISupplementalDriver — Class in namespace Nette\Database: Supplemental PDO database driver.
ISupplementalDriver::isSupported() — Method in class ISupplementalDriver: Cheks if driver supports specific property
$ Structure#isRebuilt — Property 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.
IRow — Class in namespace Nette\Database\Table: Row interface.
IRowContainer — Class 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
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#joinCondition — Property in class SqlBuilder

K

ResultSet::key() — Method in class ResultSet
$ Selection#keys — Property 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#limit — Property in class SqlBuilder

M

$ ConnectionPanel#maxQueries — Property in class ConnectionPanel
MsSqlDriver — Class in namespace Nette\Database\Drivers: Supplemental MS SQL database driver.
MySqlDriver — Class in namespace Nette\Database\Drivers: Supplemental MySQL database driver.
$ Helpers#maxLength — Property 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#name — Property 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.
NotNullConstraintViolationException — Class 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#name — Property in class Selection
Selection::next() — Method in class Selection

O

$ Connection#onConnect — Property in class Connection
$ Connection#onQuery — Property in class Connection
OciDriver — Class in namespace Nette\Database\Drivers: Supplemental Oracle database driver.
OdbcDriver — Class 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#observeCache — Property 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#order — Property in class SqlBuilder
$ SqlBuilder#offset — Property in class SqlBuilder

P

Connection::preprocess() — Method in class Connection
$ StaticConventions#primary — Property in class StaticConventions
PgSqlDriver — Class in namespace Nette\Database\Drivers: Supplemental PostgreSQL database driver.
SqlPreprocessor::process() — Method in class SqlPreprocessor
$ Selection#primary — Property in class Selection
$ Selection#primarySequence — Property in class Selection
$ Selection#previousAccessedColumns — Property in class Selection
Selection::page() — Method in class Selection: Sets offset using page number, more calls rewrite old values.
$ SqlBuilder#parameters — Property in class SqlBuilder
SqlBuilder::parseJoinConditions() — Method in class SqlBuilder
SqlBuilder::parseJoins() — Method in class SqlBuilder
SqlBuilder::parseJoinsCb() — Method in class SqlBuilder

Q

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#queryString — Property 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.
ResultSet — Class in namespace Nette\Database: Represents a result set.
ResultSet::rewind() — Method in class ResultSet
Row — Class 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#refTable — Property in class GroupedSelection
$ GroupedSelection#refCacheCurrent — Property in class GroupedSelection
IRow::related() — Method in class IRow: Returns referencing rows.
IRow::ref() — Method in class IRow: Returns referenced row.
$ Selection#rows — Property in class Selection
$ Selection#refCache — Property in class Selection
Selection::removeAccessColumn() — Method in class Selection
Selection::rewind() — Method in class Selection
$ SqlBuilder#reservedTableNames — Property in class SqlBuilder
SqlBuilder::resetSelect() — Method in class SqlBuilder

S

$ DiscoveredConventions#structure — Property in class DiscoveredConventions
StaticConventions — Class in namespace Nette\Database\Conventions: Conventions based on static definition.
Sqlite2Driver — Class in namespace Nette\Database\Drivers: Supplemental SQLite2 database driver.
SqliteDriver — Class in namespace Nette\Database\Drivers: Supplemental SQLite3 database driver.
SqlsrvDriver — Class in namespace Nette\Database\Drivers: Supplemental SQL Server 2005 and later database driver.
SqlLiteral — Class in namespace Nette\Database: SQL literal value.
SqlPreprocessor — Class in namespace Nette\Database: SQL preprocessor.
Structure — Class in namespace Nette\Database: Cached reflection of database structure.
$ Structure#structure — Property in class Structure
ActiveRow::setTable() — Method in class ActiveRow
GroupedSelection::setActive() — Method in class GroupedSelection: Sets active group.
GroupedSelection::select() — Method in class GroupedSelection
IRow::setTable() — Method in class IRow
Selection — Class in namespace Nette\Database\Table: Filtered table representation.
$ Selection#sqlBuilder — Property in class Selection
$ Selection#specificCacheKey — Property in class Selection
Selection::setPrimarySequence() — Method in class Selection
Selection::select() — Method in class Selection: Adds select clause, more calls appends to the end.
Selection::sum() — Method in class Selection: Returns sum of values in a column.
Selection::saveCacheState() — Method in class Selection
SqlBuilder — Class in namespace Nette\Database\Table: Builds SQL query.
$ SqlBuilder#select — Property in class SqlBuilder
SqlBuilder::setOrder() — Method in class SqlBuilder
SqlBuilder::setLimit() — Method in class SqlBuilder
SqlBuilder::setGroup() — Method in class SqlBuilder
SqlBuilder::setHaving() — Method in class SqlBuilder

T

Context::table() — Method in class Context
$ StaticConventions#table — Property in class StaticConventions
$ Helpers#typePatterns — Property in class Helpers
Helpers::toPairs() — Method in class Helpers: Reformat source to key -> value pairs.
ActiveRow::toArray() — Method in class ActiveRow
$ SqlBuilder#tableName — Property 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.
UniqueConstraintViolationException — Class 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#where — Property 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:

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

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