interface/modules/zend_modules/library/Zend/Db/Adapter/Platform/Oracle.php

   1 <?php
   2 /**
   3  * Zend Framework (http://framework.zend.com/)
   4  *
   5  * @link      http://github.com/zendframework/zf2 for the canonical source repository
   6  * @copyright Copyright (c) 2005-2013 Zend Technologies USA Inc. (http://www.zend.com)
   7  * @license   http://framework.zend.com/license/new-bsd New BSD License
   8  */
   9
  10 namespace Zend\Db\Adapter\Platform;
  11
  12 class Oracle implements PlatformInterface
  13 {
  14
  15     /**
  16      * @var bool
  17      */
  18     protected $quoteIdentifiers = true;
  19
  20     /**
  21      * @param array $options
  22      */
  23     public function __construct($options = array())
  24     {
  25         if (isset($options['quote_identifiers'])
  26             && ($options['quote_identifiers'] == false
  27             || $options['quote_identifiers'] === 'false')
  28         ) {
  29             $this->quoteIdentifiers = false;
  30         }
  31     }
  32
  33     /**
  34      * Get name
  35      *
  36      * @return string
  37      */
  38     public function getName()
  39     {
  40         return 'Oracle';
  41     }
  42
  43     /**
  44      * Get quote identifier symbol
  45      *
  46      * @return string
  47      */
  48     public function getQuoteIdentifierSymbol()
  49     {
  50         return '"';
  51     }
  52
  53     /**
  54      * Quote identifier
  55      *
  56      * @param  string $identifier
  57      * @return string
  58      */
  59     public function quoteIdentifier($identifier)
  60     {
  61         if ($this->quoteIdentifiers === false) {
  62             return $identifier;
  63         }
  64         return '"' . str_replace('"', '\\' . '"', $identifier) . '"';
  65     }
  66
  67     /**
  68      * Quote identifier chain
  69      *
  70      * @param string|string[] $identifierChain
  71      * @return string
  72      */
  73     public function quoteIdentifierChain($identifierChain)
  74     {
  75         if ($this->quoteIdentifiers === false) {
  76             return (is_array($identifierChain)) ? implode('.', $identifierChain) : $identifierChain;
  77         }
  78         $identifierChain = str_replace('"', '\\"', $identifierChain);
  79         if (is_array($identifierChain)) {
  80             $identifierChain = implode('"."', $identifierChain);
  81         }
  82         return '"' . $identifierChain . '"';
  83     }
  84
  85     /**
  86      * Get quote value symbol
  87      *
  88      * @return string
  89      */
  90     public function getQuoteValueSymbol()
  91     {
  92         return '\'';
  93     }
  94
  95     /**
  96      * Quote value
  97      *
  98      * @param  string $value
  99      * @return string
 100      */
 101     public function quoteValue($value)
 102     {
 103         trigger_error(
 104             'Attempting to quote a value in ' . __CLASS__ . ' without extension/driver support '
 105                 . 'can introduce security vulnerabilities in a production environment.'
 106         );
 107         return '\'' . addcslashes($value, "\x00\n\r\\'\"\x1a") . '\'';
 108     }
 109
 110     /**
 111      * Quote Trusted Value
 112      *
 113      * The ability to quote values without notices
 114      *
 115      * @param $value
 116      * @return mixed
 117      */
 118     public function quoteTrustedValue($value)
 119     {
 120         return '\'' . addcslashes($value, "\x00\n\r\\'\"\x1a") . '\'';
 121     }
 122
 123     /**
 124      * Quote value list
 125      *
 126      * @param string|string[] $valueList
 127      * @return string
 128      */
 129     public function quoteValueList($valueList)
 130     {
 131         if (!is_array($valueList)) {
 132             return $this->quoteValue($valueList);
 133         }
 134
 135         $value = reset($valueList);
 136         do {
 137             $valueList[key($valueList)] = $this->quoteValue($value);
 138         } while ($value = next($valueList));
 139         return implode(', ', $valueList);
 140     }
 141
 142     /**
 143      * Get identifier separator
 144      *
 145      * @return string
 146      */
 147     public function getIdentifierSeparator()
 148     {
 149         return '.';
 150     }
 151
 152     /**
 153      * Quote identifier in fragment
 154      *
 155      * @param  string $identifier
 156      * @param  array $safeWords
 157      * @return string
 158      */
 159     public function quoteIdentifierInFragment($identifier, array $safeWords = array())
 160     {
 161         if ($this->quoteIdentifiers === false) {
 162             return $identifier;
 163         }
 164         $parts = preg_split('#([\.\s\W])#', $identifier, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY);
 165         if ($safeWords) {
 166             $safeWords = array_flip($safeWords);
 167             $safeWords = array_change_key_case($safeWords, CASE_LOWER);
 168         }
 169         foreach ($parts as $i => $part) {
 170             if ($safeWords && isset($safeWords[strtolower($part)])) {
 171                 continue;
 172             }
 173             switch ($part) {
 174                 case ' ':
 175                 case '.':
 176                 case '*':
 177                 case 'AS':
 178                 case 'As':
 179                 case 'aS':
 180                 case 'as':
 181                     break;
 182                 default:
 183                     $parts[$i] = '"' . str_replace('"', '\\' . '"', $part) . '"';
 184             }
 185         }
 186         return implode('', $parts);
 187     }
 188
 189 }