Interface ISupplementalDriver

Supplemental PDO database driver.

Direct known implementers

Nette\Database\Drivers\MsSqlDriver, Nette\Database\Drivers\MySqlDriver, Nette\Database\Drivers\OciDriver, Nette\Database\Drivers\OdbcDriver, Nette\Database\Drivers\PgSqlDriver, Nette\Database\Drivers\SqliteDriver, Nette\Database\Drivers\SqlsrvDriver

Indirect known implementers

Nette\Database\Drivers\Sqlite2Driver

Namespace: Nette\Database
Author: David Grudl
Located at Database/ISupplementalDriver.php

Methods summary
`public string`	# `delimite( string $name )` Delimites identifier for use in a SQL statement. Delimites identifier for use in a SQL statement. Parameters `$name` `string` Returns `string`
`public mixed`	# `formatBool( boolean $value )` Formats boolean for use in a SQL statement. Formats boolean for use in a SQL statement. Parameters `$value` `boolean` Returns `mixed`
`public string`	# `formatDateTime( $value )` Formats date-time for use in a SQL statement. Formats date-time for use in a SQL statement. Returns `string`
`public string`	# `formatLike( string $value, integer $pos )` Encodes string for use in a LIKE statement. Encodes string for use in a LIKE statement. Parameters `$value` `string` `$pos` `integer` Returns `string`
`public`	# `applyLimit( string & $sql, integer $limit, integer $offset )` Injects LIMIT/OFFSET to the SQL query. Injects LIMIT/OFFSET to the SQL query. Parameters `$sql` `string` SQL query that will be modified. `$limit` `integer` `$offset` `integer`
`public array`	# `normalizeRow( array $row )` Normalizes result row. Normalizes result row. Parameters `$row` `array` Returns `array`
`public array`	# `getTables( )` Returns list of tables. Returns list of tables. Returns `array` of [name [, (bool) view]]
`public array`	# `getColumns( string $table )` Returns metadata for all columns in a table. Returns metadata for all columns in a table. Parameters `$table` `string` Returns `array` of [name, nativetype, primary [, table, fullname, (int) size, (bool) nullable, (mixed) default, (bool) autoincrement, (array) vendor]]
`public array`	# `getIndexes( string $table )` Returns metadata for all indexes in a table. Returns metadata for all indexes in a table. Parameters `$table` `string` Returns `array` of [name, (array of names) columns [, (bool) unique, (bool) primary]]
`public array`	# `getForeignKeys( string $table )` Returns metadata for all foreign keys in a table. Returns metadata for all foreign keys in a table. Parameters `$table` `string` Returns `array`
`public array`	# `getColumnTypes( PDOStatement $statement )` Returns associative array of detected types (IStructure::FIELD_) in result set. Returns associative array of detected types (IStructure::FIELD_) in result set. Parameters `$statement` `PDOStatement` Returns `array`
`public boolean`	# `isSupported( string $item )` Cheks if driver supports specific property Cheks if driver supports specific property Parameters `$item` `string` self::SUPPORT_* property Returns `boolean`

Constants summary
`string`	`SUPPORT_SEQUENCE`	`'sequence'`	#
`string`	`SUPPORT_SELECT_UNGROUPED_COLUMNS`	`'ungrouped_cols'`	#
`string`	`SUPPORT_MULTI_INSERT_AS_SELECT`	`'insert_as_select'`	#
`string`	`SUPPORT_MULTI_COLUMN_AS_OR_COND`	`'multi_column_as_or'`	#
`string`	`SUPPORT_SUBSELECT`	`'subselect'`	#