Namespaces

  • Nette
    • Application
      • Diagnostics
      • Responses
      • Routers
      • UI
    • Caching
      • Storages
    • ComponentModel
    • Database
      • Diagnostics
      • Drivers
      • Reflection
      • Table
    • DI
      • Config
        • Adapters
      • Diagnostics
      • Extensions
    • Diagnostics
    • Forms
      • Controls
      • Rendering
    • Http
      • Diagnostics
    • Iterators
    • Latte
      • Macros
    • Loaders
    • Localization
    • Mail
    • PhpGenerator
    • Reflection
    • Security
      • Diagnostics
    • Templating
    • Utils
  • NetteModule
  • none

Classes

  • MsSqlDriver
  • MySqlDriver
  • OciDriver
  • OdbcDriver
  • PgSqlDriver
  • Sqlite2Driver
  • SqliteDriver
  • SqlsrvDriver
  • Overview
  • Namespace
  • Class
  • Tree
  • Deprecated
  • Other releases
  • Nette homepage

Class MsSqlDriver

Supplemental MS SQL database driver.

Nette\Object
Extended by Nette\Database\Drivers\MsSqlDriver implements Nette\Database\ISupplementalDriver
Namespace: Nette\Database\Drivers
Author: David Grudl
Located at Database/Drivers/MsSqlDriver.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

Implementation of

Nette\Database\ISupplementalDriver::delimite()
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

Implementation of

Nette\Database\ISupplementalDriver::formatBool()
public string
# formatDateTime( $value )

Formats date-time for use in a SQL statement.

Formats date-time for use in a SQL statement.

Returns

string

Implementation of

Nette\Database\ISupplementalDriver::formatDateTime()
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

Implementation of

Nette\Database\ISupplementalDriver::formatLike()
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

Implementation of

Nette\Database\ISupplementalDriver::applyLimit()
public array
# normalizeRow( array $row )

Normalizes result row.

Normalizes result row.

Parameters

$row
array

Returns

array

Implementation of

Nette\Database\ISupplementalDriver::normalizeRow()
public array
# getTables( )

Returns list of tables.

Returns list of tables.

Returns

array
of [name [, (bool) view]]

Implementation of

Nette\Database\ISupplementalDriver::getTables()
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 [, table, fullname, (int) size, (bool) nullable, (mixed) default, (bool) autoincrement, (array) vendor]]

Implementation of

Nette\Database\ISupplementalDriver::getColumns()
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]]

Implementation of

Nette\Database\ISupplementalDriver::getIndexes()
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

Implementation of

Nette\Database\ISupplementalDriver::getForeignKeys()
public array
# getColumnTypes( PDOStatement $statement )

Returns associative array of detected types (IReflection::FIELD_*) in result set.

Returns associative array of detected types (IReflection::FIELD_*) in result set.

Returns

array

Implementation of

Nette\Database\ISupplementalDriver::getColumnTypes()
public boolean
# isSupported( $item )

Returns

boolean

Implementation of

Nette\Database\ISupplementalDriver::isSupported()
Methods inherited from Nette\Object
__call(), __callStatic(), __get(), __isset(), __set(), __unset(), extensionMethod(), getReflection()
Constants inherited from Nette\Database\ISupplementalDriver
SUPPORT_MULTI_COLUMN_AS_OR_COND, SUPPORT_MULTI_INSERT_AS_SELECT, SUPPORT_SELECT_UNGROUPED_COLUMNS, SUPPORT_SEQUENCE, SUPPORT_SUBSELECT
Magic properties inherited from Nette\Object
$reflection
Nette 2.1 API documentation generated by ApiGen 2.8.0