Inheritance diagram for Zend_Db_Adapter_Pdo_Mssql:

Public Member Functions
	listTables ()

	describeTable ($tableName, $schemaName=null)

	limit ($sql, $count, $offset=0)

	lastInsertId ($tableName=null, $primaryKey=null)

	getServerVersion ()

Public Member Functions inherited from Zend_Db_Adapter_Pdo_Abstract
	isConnected ()

	closeConnection ()

	prepare ($sql)

	lastInsertId ($tableName=null, $primaryKey=null)

	query ($sql, $bind=array())

	exec ($sql)

	setFetchMode ($mode)

	supportsParameters ($type)

	getServerVersion ()

Public Member Functions inherited from Zend_Db_Adapter_Abstract
	__construct ($config)

	getConnection ()

	getConfig ()

	setProfiler ($profiler)

	getProfiler ()

	getStatementClass ()

	setStatementClass ($class)

	query ($sql, $bind=array())

	beginTransaction ()

	commit ()

	rollBack ()

	insert ($table, array $bind)

	update ($table, array $bind, $where='')

	delete ($table, $where='')

	select ()

	getFetchMode ()

	fetchAll ($sql, $bind=array(), $fetchMode=null)

	fetchRow ($sql, $bind=array(), $fetchMode=null)

	fetchAssoc ($sql, $bind=array())

	fetchCol ($sql, $bind=array())

	fetchPairs ($sql, $bind=array())

	fetchOne ($sql, $bind=array())

	quote ($value, $type=null)

	quoteInto ($text, $value, $type=null, $count=null)

	quoteIdentifier ($ident, $auto=false)

	quoteColumnAs ($ident, $alias, $auto=false)

	quoteTableAs ($ident, $alias=null, $auto=false)

	getQuoteIdentifierSymbol ()

	lastSequenceId ($sequenceName)

	nextSequenceId ($sequenceName)

	foldCase ($key)

	__sleep ()

	__wakeup ()

	listTables ()

	describeTable ($tableName, $schemaName=null)

	isConnected ()

	closeConnection ()

	prepare ($sql)

	lastInsertId ($tableName=null, $primaryKey=null)

	setFetchMode ($mode)

	limit ($sql, $count, $offset=0)

	supportsParameters ($type)

	getServerVersion ()

Protected Member Functions
	_dsn ()

	_connect ()

	_beginTransaction ()

	_commit ()

	_rollBack ()

	_quote ($value)

Protected Member Functions inherited from Zend_Db_Adapter_Pdo_Abstract
	_dsn ()

	_connect ()

	_quote ($value)

	_beginTransaction ()

	_commit ()

	_rollBack ()

Protected Member Functions inherited from Zend_Db_Adapter_Abstract
	_checkRequiredOptions (array $config)

	_whereExpr ($where)

	_quote ($value)

	_quoteIdentifierAs ($ident, $alias=null, $auto=false, $as=' AS ')

	_quoteIdentifier ($value, $auto=false)

	_connect ()

	_beginTransaction ()

	_commit ()

	_rollBack ()

Protected Attributes
	$_pdoType = 'mssql'

	$_numericDataTypes

Protected Attributes inherited from Zend_Db_Adapter_Pdo_Abstract
	$_defaultStmtClass = 'Zend_Db_Statement_Pdo'

Protected Attributes inherited from Zend_Db_Adapter_Abstract
	$_config = array()

	$_fetchMode = Zend_Db::FETCH_ASSOC

	$_profiler

	$_defaultStmtClass = 'Zend_Db_Statement'

	$_defaultProfilerClass = 'Zend_Db_Profiler'

	$_connection = null

	$_caseFolding = Zend_Db::CASE_NATURAL

	$_autoQuoteIdentifiers = true

	$_numericDataTypes

	$_allowSerialization = true

	$_autoReconnectOnUnserialize = false

Detailed Description

Definition at line 39 of file Mssql.php.

Member Function Documentation

◆ _beginTransaction()

_beginTransaction ( )

protected

Begin a transaction.

It is necessary to override the abstract PDO transaction functions here, as the PDO driver for MSSQL does not support transactions.

Definition at line 147 of file Mssql.php.

     {
         $this->_connect();
         $this->_connection->exec('BEGIN TRANSACTION');
         return true;
     }

◆ _commit()

_commit ( )

protected

Commit a transaction.

It is necessary to override the abstract PDO transaction functions here, as the PDO driver for MSSQL does not support transactions.

Definition at line 160 of file Mssql.php.

     {
         $this->_connect();
         $this->_connection->exec('COMMIT TRANSACTION');
         return true;
     }

◆ _connect()

_connect ( )

protected

Returns: void

Definition at line 132 of file Mssql.php.

     {
         if ($this->_connection) {
             return;
         }
         parent::_connect();
         $this->_connection->exec('SET QUOTED_IDENTIFIER ON');
     }

◆ _dsn()

_dsn ( )

protected

Creates a PDO DSN for the adapter from $this->_config settings.

Returns: string

Definition at line 80 of file Mssql.php.

     {
         // baseline of DSN parts
         $dsn = $this->_config;
 
         // don't pass the username and password in the DSN
         unset($dsn['username']);
         unset($dsn['password']);
         unset($dsn['options']);
         unset($dsn['persistent']);
         unset($dsn['driver_options']);
 
         if (isset($dsn['port'])) {
             $seperator = ':';
             if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') {
                 $seperator = ',';
             }
             $dsn['host'] .= $seperator . $dsn['port'];
             unset($dsn['port']);
         }
 
         // this driver supports multiple DSN prefixes
         // @see http://www.php.net/manual/en/ref.pdo-dblib.connection.php
         if (isset($dsn['pdoType'])) {
             switch (strtolower($dsn['pdoType'])) {
                 case 'freetds':
                 case 'sybase':
                     $this->_pdoType = 'sybase';
                     break;
                 case 'mssql':
                     $this->_pdoType = 'mssql';
                     break;
                 case 'dblib':
                 default:
                     $this->_pdoType = 'dblib';
                     break;
             }
             unset($dsn['pdoType']);
         }
 
         // use all remaining parts in the DSN
         foreach ($dsn as $key => $val) {
             $dsn[$key] = "$key=$val";
         }
 
         $dsn = $this->_pdoType . ':' . implode(';', $dsn);
         return $dsn;
     }

◆ _quote()

_quote ( $value )

protected

Quote a raw string.

Parameters

string $value Raw string

Returns: string Quoted string

Definition at line 430 of file Mssql.php.

     {
         if (!is_int($value) && !is_float($value)) {
             // Fix for null-byte injection
             $value = addcslashes($value, "\000\032");
         }
         return parent::_quote($value);
     }

◆ _rollBack()

_rollBack ( )

protected

Roll-back a transaction.

It is necessary to override the abstract PDO transaction functions here, as the PDO driver for MSSQL does not support transactions.

Definition at line 173 of file Mssql.php.

                                    {
         $this->_connect();
         $this->_connection->exec('ROLLBACK TRANSACTION');
         return true;
     }

◆ describeTable()

describeTable	(	$tableName,
		$schemaName = `null`
	)

Returns the column descriptions for a table.

The return value is an associative array keyed by the column name, as returned by the RDBMS.

The value of each array element is an associative array with the following keys:

SCHEMA_NAME => string; name of database or schema TABLE_NAME => string; COLUMN_NAME => string; column name COLUMN_POSITION => number; ordinal position of column in table DATA_TYPE => string; SQL datatype name of column DEFAULT => string; default expression of column, null if none NULLABLE => boolean; true if column can have nulls LENGTH => number; length of CHAR/VARCHAR SCALE => number; scale of NUMERIC/DECIMAL PRECISION => number; precision of NUMERIC/DECIMAL UNSIGNED => boolean; unsigned property of an integer type PRIMARY => boolean; true if column is part of the primary key PRIMARY_POSITION => integer; position of column in primary key PRIMARY_AUTO => integer; position of auto-generated column in primary key

Todo:

Discover column primary key position.

Discover integer unsigned property.

Parameters

string	$tableName
string	$schemaName	OPTIONAL

Returns: array

Discover metadata information about this table.

Discover primary key column(s) for this table.

Definition at line 221 of file Mssql.php.

     {
         if ($schemaName != null) {
             if (strpos($schemaName, '.') !== false) {
                 $result = explode('.', $schemaName);
                 $schemaName = $result[1];
             }
         }
         $sql = "exec sp_columns @table_name = " . $this->quoteIdentifier($tableName, true);
         if ($schemaName != null) {
             $sql .= ", @table_owner = " . $this->quoteIdentifier($schemaName, true);
         }
 
         $stmt = $this->query($sql);
         $result = $stmt->fetchAll(Zend_Db::FETCH_NUM);
 
         $table_name  = 2;
         $column_name = 3;
         $type_name   = 5;
         $precision   = 6;
         $length      = 7;
         $scale       = 8;
         $nullable    = 10;
         $column_def  = 12;
         $column_position = 16;
 
         $sql = "exec sp_pkeys @table_name = " . $this->quoteIdentifier($tableName, true);
         if ($schemaName != null) {
             $sql .= ", @table_owner = " . $this->quoteIdentifier($schemaName, true);
         }
 
         $stmt = $this->query($sql);
         $primaryKeysResult = $stmt->fetchAll(Zend_Db::FETCH_NUM);
         $primaryKeyColumn = array();
         $pkey_column_name = 3;
         $pkey_key_seq = 4;
         foreach ($primaryKeysResult as $pkeysRow) {
             $primaryKeyColumn[$pkeysRow[$pkey_column_name]] = $pkeysRow[$pkey_key_seq];
         }
 
         $desc = array();
         $p = 1;
         foreach ($result as $key => $row) {
             $identity = false;
             $words = explode(' ', $row[$type_name], 2);
             if (isset($words[0])) {
                 $type = $words[0];
                 if (isset($words[1])) {
                     $identity = (bool) preg_match('/identity/', $words[1]);
                 }
             }
 
             $isPrimary = array_key_exists($row[$column_name], $primaryKeyColumn);
             if ($isPrimary) {
                 $primaryPosition = $primaryKeyColumn[$row[$column_name]];
             } else {
                 $primaryPosition = null;
             }
 
             $desc[$this->foldCase($row[$column_name])] = array(
                 'SCHEMA_NAME'      => null, // @todo
                 'TABLE_NAME'       => $this->foldCase($row[$table_name]),
                 'COLUMN_NAME'      => $this->foldCase($row[$column_name]),
                 'COLUMN_POSITION'  => (int) $row[$column_position],
                 'DATA_TYPE'        => $type,
                 'DEFAULT'          => $row[$column_def],
                 'NULLABLE'         => (bool) $row[$nullable],
                 'LENGTH'           => $row[$length],
                 'SCALE'            => $row[$scale],
                 'PRECISION'        => $row[$precision],
                 'UNSIGNED'         => null, // @todo
                 'PRIMARY'          => $isPrimary,
                 'PRIMARY_POSITION' => $primaryPosition,
                 'IDENTITY'         => $identity
             );
         }
         return $desc;
     }

◆ getServerVersion()

getServerVersion ( )

Retrieve server version in PHP style Pdo_Mssql doesn't support getAttribute(PDO::ATTR_SERVER_VERSION)

Returns: string

Definition at line 410 of file Mssql.php.

     {
         try {
             $stmt = $this->query("SELECT CAST(SERVERPROPERTY('productversion') AS VARCHAR)");
             $result = $stmt->fetchAll(Zend_Db::FETCH_NUM);
             if (count($result)) {
                 return $result[0][0];
             }
             return null;
         } catch (PDOException $e) {
             return null;
         }
     }

◆ lastInsertId()

lastInsertId	(	$tableName = `null`,
		$primaryKey = `null`
	)

Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.

As a convention, on RDBMS brands that support sequences (e.g. Oracle, PostgreSQL, DB2), this method forms the name of a sequence from the arguments and returns the last id generated by that sequence. On RDBMS brands that support IDENTITY/AUTOINCREMENT columns, this method returns the last value generated for such a column, and the table name argument is disregarded.

Microsoft SQL Server does not support sequences, so the arguments to this method are ignored.

Parameters

string	$tableName	OPTIONAL Name of table.
string	$primaryKey	OPTIONAL Name of primary key column.

Returns: string

Exceptions

Zend_Db_Adapter_Exception

Definition at line 399 of file Mssql.php.

     {
         $sql = 'SELECT SCOPE_IDENTITY()';
         return (int)$this->fetchOne($sql);
     }

◆ limit()

limit	(	$sql,
		$count,
		$offset = `0`
	)

Adds an adapter-specific LIMIT clause to the SELECT statement.

string $sql integer $count integer $offset OPTIONAL Zend_Db_Adapter_Exception string

See also: Zend_Db_Adapter_Exception; Zend_Db_Adapter_Exception

Definition at line 317 of file Mssql.php.

      {
         $count = intval($count);
         if ($count <= 0) {
             #require_once 'Zend/Db/Adapter/Exception.php';
             throw new Zend_Db_Adapter_Exception("LIMIT argument count=$count is not valid");
         }
 
         $offset = intval($offset);
         if ($offset < 0) {
             #require_once 'Zend/Db/Adapter/Exception.php';
             throw new Zend_Db_Adapter_Exception("LIMIT argument offset=$offset is not valid");
         }
 
         $sql = preg_replace(
             '/^SELECT\s+(DISTINCT\s)?/i',
             'SELECT $1TOP ' . ($count+$offset) . ' ',
             $sql
             );
 
         if ($offset > 0) {
             $orderby = stristr($sql, 'ORDER BY');
 
             if ($orderby !== false) {
                 $orderParts = explode(',', substr($orderby, 8));
                 $pregReplaceCount = null;
                 $orderbyInverseParts = array();
                 foreach ($orderParts as $orderPart) {
                     $orderPart = rtrim($orderPart);
                     $inv = preg_replace('/\s+desc$/i', ' ASC', $orderPart, 1, $pregReplaceCount);
                     if ($pregReplaceCount) {
                         $orderbyInverseParts[] = $inv;
                         continue;
                     }
                     $inv = preg_replace('/\s+asc$/i', ' DESC', $orderPart, 1, $pregReplaceCount);
                     if ($pregReplaceCount) {
                         $orderbyInverseParts[] = $inv;
                         continue;
                     } else {
                         $orderbyInverseParts[] = $orderPart . ' DESC';
                     }
                 }
 
                 $orderbyInverse = 'ORDER BY ' . implode(', ', $orderbyInverseParts);
             }
 
 
 
 
             $sql = 'SELECT * FROM (SELECT TOP ' . $count . ' * FROM (' . $sql . ') AS inner_tbl';
             if ($orderby !== false) {
                 $sql .= ' ' . $orderbyInverse . ' ';
             }
             $sql .= ') AS outer_tbl';
             if ($orderby !== false) {
                 $sql .= ' ' . $orderby;
             }
         }
 
         return $sql;
     }

◆ listTables()

listTables ( )

Returns a list of the tables in the database.

Returns: array

Definition at line 184 of file Mssql.php.

     {
         $sql = "SELECT name FROM sysobjects WHERE type = 'U' ORDER BY name";
         return $this->fetchCol($sql);
     }

Field Documentation

◆ $_numericDataTypes

$_numericDataTypes

protected

Initial value:

= array(
        Zend_Db::INT_TYPE    => Zend_Db::INT_TYPE,
        Zend_Db::BIGINT_TYPE => Zend_Db::BIGINT_TYPE,
        Zend_Db::FLOAT_TYPE  => Zend_Db::FLOAT_TYPE,
        'INT'                => Zend_Db::INT_TYPE,
        'SMALLINT'           => Zend_Db::INT_TYPE,
        'TINYINT'            => Zend_Db::INT_TYPE,
        'BIGINT'             => Zend_Db::BIGINT_TYPE,
        'DECIMAL'            => Zend_Db::FLOAT_TYPE,
        'FLOAT'              => Zend_Db::FLOAT_TYPE,
        'MONEY'              => Zend_Db::FLOAT_TYPE,
        'NUMERIC'            => Zend_Db::FLOAT_TYPE,
        'REAL'               => Zend_Db::FLOAT_TYPE,
        'SMALLMONEY'         => Zend_Db::FLOAT_TYPE
    )

Definition at line 59 of file Mssql.php.

◆ $_pdoType

$_pdoType = 'mssql'

protected

Definition at line 46 of file Mssql.php.

The documentation for this class was generated from the following file:

vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mssql.php

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Member Function Documentation

◆ _beginTransaction()

◆ _commit()

◆ _connect()

◆ _dsn()

◆ _quote()

◆ _rollBack()

◆ describeTable()

◆ getServerVersion()

◆ lastInsertId()

◆ limit()

◆ listTables()

Field Documentation

◆ $_numericDataTypes

◆ $_pdoType