Index
A
- AmbiguousReferenceKeyException — Class 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
- ActiveRow — Class in namespace Nette\Database\Table
Single row representation.
- ActiveRow::accessColumn() — Method in class ActiveRow
- $ GroupedSelection#active — Property in class GroupedSelection
primary key
- GroupedSelection::aggregation() — Method in class GroupedSelection
Executes aggregation function.
- $ Selection#aggregation — Property in class Selection
of [conditions => [key => ActiveRow]]; used by GroupedSelection
- $ 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
- 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
- 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
- Conventions — Class 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
- Column — Class in namespace Nette\Database\Reflection
Column reflection.
- $ Table#columns — Property in class Table
- ResultSet::current() — Method in class ResultSet
- $ Structure#connection — Property in class Structure
- $ Structure#cache — Property in class Structure
- $ GroupedSelection#column — Property in class GroupedSelection
grouping column name
- GroupedSelection::count() — Method in class GroupedSelection
Counts number of rows. If column is not provided returns count of result rows, otherwise runs new sql counting query.
- $ Selection#context — Property in class Selection
back compatibility
- $ 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. If column is not provided returns count of result rows, otherwise runs new sql counting query.
- 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.
- $ ConnectionPanel#disabled — Property in class ConnectionPanel
- Connection::disconnect() — Method in class Connection
- DiscoveredConventions — Class in namespace Nette\Database\Conventions
Conventions based on database structure.
- DateTime — Class in namespace Nette\Database
Date Time.
- Driver — Class in namespace Nette\Database
Supplemental PDO database driver.
- Driver::delimite() — Method in class Driver
Delimites identifier for use in a SQL statement.
- 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.
- 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
- Explorer — Class in namespace Nette\Database
Database explorer.
- GroupedSelection::execute() — Method in class GroupedSelection
- GroupedSelection::emptyResultSet() — Method in class GroupedSelection
- $ Selection#explorer — Property 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()
- 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()
- 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
- ForeignKey — Class in namespace Nette\Database\Reflection
Foreign key reflection.
- $ Table#foreignKeys — Property in class Table
- 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::getReflection() — 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
- Driver::getColumns() — Method in class Driver
- Driver::getIndexes() — Method in class Driver
- Driver::getForeignKeys() — Method in class Driver
- 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
- MsSqlDriver::getColumns() — Method in class MsSqlDriver
- MsSqlDriver::getIndexes() — Method in class MsSqlDriver
- MsSqlDriver::getForeignKeys() — Method in class MsSqlDriver
- MsSqlDriver::getColumnTypes() — Method in class MsSqlDriver
Returns associative array of detected types (IStructure::FIELD_*) in result set.
- MySqlDriver::getTables() — Method in class MySqlDriver
- MySqlDriver::getColumns() — Method in class MySqlDriver
- MySqlDriver::getIndexes() — Method in class MySqlDriver
- MySqlDriver::getForeignKeys() — Method in class MySqlDriver
- MySqlDriver::getColumnTypes() — Method in class MySqlDriver
Returns associative array of detected types (IStructure::FIELD_*) in result set.
- OciDriver::getTables() — Method in class OciDriver
- OciDriver::getColumns() — Method in class OciDriver
- OciDriver::getIndexes() — Method in class OciDriver
- OciDriver::getForeignKeys() — Method in class OciDriver
- OciDriver::getColumnTypes() — Method in class OciDriver
Returns associative array of detected types (IStructure::FIELD_*) in result set.
- OdbcDriver::getTables() — Method in class OdbcDriver
- OdbcDriver::getColumns() — Method in class OdbcDriver
- OdbcDriver::getIndexes() — Method in class OdbcDriver
- OdbcDriver::getForeignKeys() — Method in class OdbcDriver
- OdbcDriver::getColumnTypes() — Method in class OdbcDriver
Returns associative array of detected types (IStructure::FIELD_*) in result set.
- PgSqlDriver::getTables() — Method in class PgSqlDriver
- PgSqlDriver::getColumns() — Method in class PgSqlDriver
- PgSqlDriver::getIndexes() — Method in class PgSqlDriver
- PgSqlDriver::getForeignKeys() — Method in class PgSqlDriver
- PgSqlDriver::getColumnTypes() — Method in class PgSqlDriver
Returns associative array of detected types (IStructure::FIELD_*) in result set.
- SqliteDriver::getTables() — Method in class SqliteDriver
- SqliteDriver::getColumns() — Method in class SqliteDriver
- SqliteDriver::getIndexes() — Method in class SqliteDriver
- SqliteDriver::getForeignKeys() — Method in class SqliteDriver
- SqliteDriver::getColumnTypes() — Method in class SqliteDriver
Returns associative array of detected types (IStructure::FIELD_*) in result set.
- SqlsrvDriver::getTables() — Method in class SqlsrvDriver
- SqlsrvDriver::getColumns() — Method in class SqlsrvDriver
- SqlsrvDriver::getIndexes() — Method in class SqlsrvDriver
- SqlsrvDriver::getForeignKeys() — Method in class SqlsrvDriver
- 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.
- Reflection::getTables() — Method in class Reflection
- Reflection::getTable() — Method in class Reflection
- Reflection::getDriver() — Method in class Reflection
- Table::getColumn() — Method in class Table
- ResultSet::getConnection() — Method in class ResultSet
- ResultSet::getPdoStatement() — Method in class ResultSet
- ResultSet::getQueryString() — Method in class ResultSet
- ResultSet::getParameters() — Method in class ResultSet
- ResultSet::getColumnCount() — Method in class ResultSet
- ResultSet::getRowCount() — Method in class ResultSet
- ResultSet::getColumnTypes() — Method in class ResultSet
- ResultSet::getTime() — Method in class ResultSet
- SqlLiteral::getSql() — Method in class SqlLiteral
- 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
- 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.
- $ Selection#globalRefCache — Property in class Selection
cache array of Selection and GroupedSelection prototypes
- $ 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.
- Reflection::hasTable() — Method in class Reflection
- Selection::having() — Method in class Selection
Sets having clause, more calls rewrite old value.
- $ SqlBuilder#having — Property in class SqlBuilder
I
- ConnectionPanel::initialize() — Method in class ConnectionPanel
- 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 utf8mb4)
- sqlmode => see http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
- convertBoolean => converts INT(1) to boolean
- MySqlDriver::isSupported() — Method in class MySqlDriver
Cheks if driver supports specific property
- OciDriver::initialize() — Method in class OciDriver
Initializes connection.
- OciDriver::isSupported() — Method in class OciDriver
Cheks if driver supports specific property
- OdbcDriver::initialize() — Method in class OdbcDriver
Initializes connection.
- OdbcDriver::isSupported() — Method in class OdbcDriver
Cheks if driver supports specific property
- PgSqlDriver::initialize() — Method in class PgSqlDriver
Initializes connection.
- PgSqlDriver::isSupported() — Method in class PgSqlDriver
Cheks if driver supports specific property
- SqliteDriver::initialize() — Method in class SqliteDriver
Initializes connection.
- SqliteDriver::isSupported() — Method in class SqliteDriver
Cheks if driver supports specific property
- SqlsrvDriver::initialize() — Method in class SqlsrvDriver
Initializes connection.
- SqlsrvDriver::isSupported() — Method in class SqlsrvDriver
Cheks if driver supports specific property
- Helpers::initializeTracy() — Method in class Helpers
- IConventions — Class in namespace Nette\Database
- IRow — Class in namespace Nette\Database
- IRowContainer — Class in namespace Nette\Database
- 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
- Index — Class in namespace Nette\Database\Reflection
Index reflection.
- $ Table#indexes — Property in class Table
- $ 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. Returns ActiveRow or number of affected rows for Selection or table without primary key.
- IRow — Class in namespace Nette\Database\Table
- IRowContainer — Class in namespace Nette\Database\Table
- Selection::insert() — Method in class Selection
Inserts row in a table. Returns ActiveRow or number of affected rows for Selection or table without primary key.
- SqlBuilder::importConditions() — Method in class SqlBuilder
- SqlBuilder::importGroupConditions() — Method in class SqlBuilder
J
- DateTime::jsonSerialize() — Method in class DateTime
Returns JSON representation in ISO 8601 (used by JavaScript).
- 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
of primary key values
- 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#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
maximum SQL length
- 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
- Helpers::normalizeRow() — Method in class Helpers
- NotNullConstraintViolationException — Class in namespace Nette\Database
Exception for a NOT NULL constraint violation.
- ResultSet::normalizeRow() — Method in class ResultSet
- ResultSet::next() — Method in class ResultSet
- Structure::needStructure() — Method in class Structure
- $ Selection#name — Property in class Selection
table name
- 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
should instance observe accessed columns caching
- 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
- $ ConnectionPanel#performanceScale — Property in class ConnectionPanel
- Connection::preprocess() — Method in class Connection
- $ DriverException#params — Property in class DriverException
- PgSqlDriver — Class in namespace Nette\Database\Drivers
Supplemental PostgreSQL database driver.
- Helpers::parseColumnType() — Method in class Helpers
- $ Table#primaryKey — Property in class Table
- SqlPreprocessor::process() — Method in class SqlPreprocessor
- $ Selection#primary — Property in class Selection
- $ Selection#primarySequence — Property in class Selection
primary column sequence name, false for autodetection
- $ 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
- $ DriverException#queryString — Property 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.
- Reflection — Class in namespace Nette\Database
- 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
referenced table
- $ GroupedSelection#refCacheCurrent — Property in class GroupedSelection
current assigned referencing array
- $ 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
- Connection::setRowNormalizer() — Method in class Connection
- StaticConventions — Class in namespace Nette\Database\Conventions
Conventions based on static definition.
- 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
Adds select clause, more calls appends to the end.
- 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
- Connection::transaction() — Method in class Connection
- Explorer::transaction() — Method in class Explorer
- Explorer::table() — Method in class Explorer
- $ Helpers#typePatterns — Property in class Helpers
- Helpers::toPairs() — Method in class Helpers
Reformat source to key -> value pairs.
- $ Reflection#tables — Property in class Reflection
- Table — Class in namespace Nette\Database\Reflection
Table reflection.
- 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
- DiscoveredConventions::__construct() — Method in class DiscoveredConventions
- StaticConventions::__construct() — Method in class StaticConventions
Create static conventional structure.
- DateTime::__toString() — Method in class DateTime
Returns the date and time in the format 'Y-m-d H:i:s.u'.
- Explorer::__construct() — Method in class Explorer
- Reflection::__construct() — Method in class Reflection
- Reflection::__get() — Method in class Reflection
- Column::__construct() — Method in class Column
- Column::__toString() — Method in class Column
- ForeignKey::__construct() — Method in class ForeignKey
- ForeignKey::__toString() — Method in class ForeignKey
- Index::__construct() — Method in class Index
- Index::__toString() — Method in class Index
- Table::__construct() — Method in class Table
- Table::__get() — Method in class Table
- Table::__toString() — Method in class Table
- 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