Source of file SqlServer.php
Size: 5,363 Bytes - Last Modified: 2014-03-12T23:21:18+01:00
/home/theseer/Downloads/ZendFramework-2.3.0/library/Zend/Db/Adapter/Platform/SqlServer.php
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205 | <?php /** * Zend Framework (http://framework.zend.com/) * * @link http://github.com/zendframework/zf2 for the canonical source repository * @copyright Copyright (c) 2005-2014 Zend Technologies USA Inc. (http://www.zend.com) * @license http://framework.zend.com/license/new-bsd New BSD License */ namespace Zend\Db\Adapter\Platform; use Zend\Db\Adapter\Driver\DriverInterface; use Zend\Db\Adapter\Driver\Pdo; use Zend\Db\Adapter\Exception; class SqlServer implements PlatformInterface { /** @var resource|\PDO */ protected $resource = null; public function __construct($driver = null) { if ($driver) { $this->setDriver($driver); } } /** * @param \Zend\Db\Adapter\Driver\Sqlsrv\Sqlsrv|\Zend\Db\Adapter\Driver\Pdo\Pdo||resource|\PDO $driver * @throws \Zend\Db\Adapter\Exception\InvalidArgumentException * @return $this */ public function setDriver($driver) { // handle Zend\Db drivers if (($driver instanceof Pdo\Pdo && in_array($driver->getDatabasePlatformName(), array('SqlServer', 'Dblib'))) || (($driver instanceof \PDO && in_array($driver->getAttribute(\PDO::ATTR_DRIVER_NAME), array('sqlsrv', 'dblib')))) ) { $this->resource = $driver; return $this; } throw new Exception\InvalidArgumentException('$driver must be a Sqlsrv PDO Zend\Db\Adapter\Driver or Sqlsrv PDO instance'); } /** * Get name * * @return string */ public function getName() { return 'SQLServer'; } /** * Get quote identifier symbol * * @return string */ public function getQuoteIdentifierSymbol() { return array('[', ']'); } /** * Quote identifier * * @param string $identifier * @return string */ public function quoteIdentifier($identifier) { return '[' . $identifier . ']'; } /** * Quote identifier chain * * @param string|string[] $identifierChain * @return string */ public function quoteIdentifierChain($identifierChain) { if (is_array($identifierChain)) { $identifierChain = implode('].[', $identifierChain); } return '[' . $identifierChain . ']'; } /** * Get quote value symbol * * @return string */ public function getQuoteValueSymbol() { return '\''; } /** * Quote value * * @param string $value * @return string */ public function quoteValue($value) { if ($this->resource instanceof DriverInterface) { $this->resource = $this->resource->getConnection()->getResource(); } if ($this->resource instanceof \PDO) { return $this->resource->quote($value); } trigger_error( 'Attempting to quote a value in ' . __CLASS__ . ' without extension/driver support ' . 'can introduce security vulnerabilities in a production environment.' ); return '\'' . str_replace('\'', '\'\'', $value) . '\''; } /** * Quote Trusted Value * * The ability to quote values without notices * * @param $value * @return mixed */ public function quoteTrustedValue($value) { if ($this->resource instanceof DriverInterface) { $this->resource = $this->resource->getConnection()->getResource(); } if ($this->resource instanceof \PDO) { return $this->resource->quote($value); } return '\'' . str_replace('\'', '\'\'', $value) . '\''; } /** * Quote value list * * @param string|string[] $valueList * @return string */ public function quoteValueList($valueList) { if (!is_array($valueList)) { return $this->quoteValue($valueList); } $value = reset($valueList); do { $valueList[key($valueList)] = $this->quoteValue($value); } while ($value = next($valueList)); return implode(', ', $valueList); } /** * Get identifier separator * * @return string */ public function getIdentifierSeparator() { return '.'; } /** * Quote identifier in fragment * * @param string $identifier * @param array $safeWords * @return string */ public function quoteIdentifierInFragment($identifier, array $safeWords = array()) { $parts = preg_split('#([\.\s\W])#', $identifier, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY); if ($safeWords) { $safeWords = array_flip($safeWords); $safeWords = array_change_key_case($safeWords, CASE_LOWER); } foreach ($parts as $i => $part) { if ($safeWords && isset($safeWords[strtolower($part)])) { continue; } switch ($part) { case ' ': case '.': case '*': case 'AS': case 'As': case 'aS': case 'as': break; default: $parts[$i] = '[' . $part . ']'; } } return implode('', $parts); } } |