Index
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.
- AmbiguousReferenceKeyException — Class in namespace Nette\Database\Reflection
- 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
Executes aggregation function.
- $ Selection#aggregation — Property in class Selection
- $ Selection#accessedColumns — Property in class Selection
- Selection::aggregation() — Method in class Selection
Executes aggregation function.
- Selection::accessColumn() — Method in class Selection
- SqlBuilder::addSelect() — Method in class SqlBuilder
- SqlBuilder::addWhere() — Method in class SqlBuilder
- SqlBuilder::addOrder() — Method in class SqlBuilder
- SqlBuilder::addWhereComposition() — 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::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
- MySqlDriver::convertException() — Method in class MySqlDriver
- OciDriver::convertException() — Method in class OciDriver
- OdbcDriver::convertException() — Method in class OdbcDriver
- PgSqlDriver::convertException() — Method in class PgSqlDriver
- SqliteDriver::convertException() — Method in class SqliteDriver
- SqlsrvDriver::convertException() — Method in class SqlsrvDriver
- Helpers::createDebugPanel() — Method in class Helpers
- ISupplementalDriver::convertException() — Method in class ISupplementalDriver
- ConventionalReflection — Class in namespace Nette\Database\Reflection
- $ DiscoveredReflection#connection — Property in class DiscoveredReflection
- $ DiscoveredReflection#cache — Property in class DiscoveredReflection
- $ ResultSet#connection — Property in class ResultSet
- 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
Counts number of rows.
- $ Selection#context — Property in class Selection
- $ Selection#conventions — Property in class Selection
- $ Selection#cache — Property in class Selection
- 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
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#dsn — Property in class Connection
- 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.
- DiscoveredReflection — Class in namespace Nette\Database\Reflection
- 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::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::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
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::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
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::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
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::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
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::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
Formats date-time interval for use in a SQL statement.
- 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
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::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
Formats date-time interval for use in a SQL statement.
- 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.
- 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::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
- Context::getInsertId() — Method in class Context
- Context::getConnection() — Method in class Context
- Context::getStructure() — Method in class Context
- Context::getConventions() — Method in class Context
- Context::getDatabaseReflection() — 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
Not supported.
- 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.
- DiscoveredReflection::getPrimary() — Method in class DiscoveredReflection
Returns primary key for table.
- DiscoveredReflection::getHasManyReference() — Method in class DiscoveredReflection
Returns referenced table & referenced column.
- DiscoveredReflection::getBelongsToReference() — Method in class DiscoveredReflection
Returns referenced table & referencing column.
- 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::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
- ActiveRow::getSignature() — Method in class ActiveRow
- ActiveRow::getIterator() — Method in class ActiveRow
- GroupedSelection — Class in namespace Nette\Database\Table
Representation of filtered table grouped by some column.
- GroupedSelection::getRefTable() — Method in class GroupedSelection
Returns Selection parent for caching.
- IRow::getTable() — Method in class IRow
- IRow::getPrimary() — Method in class IRow
- IRow::getSignature() — Method in class IRow
- $ Selection#globalRefCache — Property in class Selection
- $ Selection#generalCacheKey — Property in class Selection
- $ Selection#generalCacheTraceKey — Property in class Selection
- Selection::getConnection() — Method in class Selection
- Selection::getDatabaseReflection() — Method 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::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
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
- IReflection — 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
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.
- $ DiscoveredReflection#loadedStructure — Property in class DiscoveredReflection
- 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
- MissingReferenceException — Class in namespace Nette\Database\Reflection
- 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
Adds order clause, more calls appends to the end.
- $ 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#pdo — Property in class Connection
- 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::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.
- DiscoveredReflection::reloadAllForeignKeys() — Method in class DiscoveredReflection
- DiscoveredReflection::reloadForeignKeys() — Method in class DiscoveredReflection
- 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
- ActiveRow::related() — Method in class ActiveRow
- ActiveRow::removeAccessColumn() — Method in class ActiveRow
- $ GroupedSelection#refTable — Property in class GroupedSelection
- $ GroupedSelection#refCacheCurrent — Property in class GroupedSelection
- IRow::related() — Method in class IRow
- IRow::ref() — Method in class IRow
- $ Selection#rows — Property in class Selection
- $ Selection#refCache — Property in class Selection
- Selection::removeAccessColumn() — Method in class Selection
- Selection::rewind() — Method in class Selection
S
- $ Connection#supplementalDriver — Property in class Connection
- $ 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.
- $ DiscoveredReflection#structure — Property in class DiscoveredReflection
- SqlLiteral — Class in namespace Nette\Database
SQL literal value.
- SqlPreprocessor — Class in namespace Nette\Database
SQL preprocessor.
- Structure — Class in namespace Nette\Database
Cached reflection of database structure.
- $ Structure#structure — Property in class Structure
- ActiveRow::setTable() — Method in class ActiveRow
- GroupedSelection::setActive() — Method in class GroupedSelection
Sets active group.
- GroupedSelection::select() — Method in class GroupedSelection
Adds select clause, more calls appends to the end.
- 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#sql — 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.
- $ 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
- ConventionalReflection::__construct() — Method in class ConventionalReflection
Create static conventional structure.
- DiscoveredReflection::__construct() — Method in class DiscoveredReflection
Create autodiscovery structure.
- DiscoveredReflection::__destruct() — Method in class DiscoveredReflection
- 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