interface/modules/zend_modules/library/Zend/Db/Adapter/Platform/Sql92.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 Sql92 implements PlatformInterface
  13 {
  14     /**
  15      * Get name
  16      *
  17      * @return string
  18      */
  19     public function getName()
  20     {
  21         return 'SQL92';
  22     }
  23
  24     /**
  25      * Get quote indentifier symbol
  26      *
  27      * @return string
  28      */
  29     public function getQuoteIdentifierSymbol()
  30     {
  31         return '"';
  32     }
  33
  34     /**
  35      * Quote identifier
  36      *
  37      * @param  string $identifier
  38      * @return string
  39      */
  40     public function quoteIdentifier($identifier)
  41     {
  42         return '"' . str_replace('"', '\\' . '"', $identifier) . '"';
  43     }
  44
  45     /**
  46      * Quote identifier chain
  47      *
  48      * @param string|string[] $identifierChain
  49      * @return string
  50      */
  51     public function quoteIdentifierChain($identifierChain)
  52     {
  53         $identifierChain = str_replace('"', '\\"', $identifierChain);
  54         if (is_array($identifierChain)) {
  55             $identifierChain = implode('"."', $identifierChain);
  56         }
  57         return '"' . $identifierChain . '"';
  58     }
  59
  60     /**
  61      * Get quote value symbol
  62      *
  63      * @return string
  64      */
  65     public function getQuoteValueSymbol()
  66     {
  67         return '\'';
  68     }
  69
  70     /**
  71      * Quote value
  72      *
  73      * @param  string $value
  74      * @return string
  75      */
  76     public function quoteValue($value)
  77     {
  78         trigger_error(
  79             'Attempting to quote a value without specific driver level support can introduce security vulnerabilities in a production environment.'
  80         );
  81         return '\'' . addcslashes($value, "\x00\n\r\\'\"\x1a") . '\'';
  82     }
  83
  84     /**
  85      * Quote Trusted Value
  86      *
  87      * The ability to quote values without notices
  88      *
  89      * @param $value
  90      * @return mixed
  91      */
  92     public function quoteTrustedValue($value)
  93     {
  94         return '\'' . addcslashes($value, "\x00\n\r\\'\"\x1a") . '\'';
  95     }
  96
  97     /**
  98      * Quote value list
  99      *
 100      * @param string|string[] $valueList
 101      * @return string
 102      */
 103     public function quoteValueList($valueList)
 104     {
 105         if (!is_array($valueList)) {
 106             return $this->quoteValue($valueList);
 107         }
 108
 109         $value = reset($valueList);
 110         do {
 111             $valueList[key($valueList)] = $this->quoteValue($value);
 112         } while ($value = next($valueList));
 113         return implode(', ', $valueList);
 114     }
 115
 116     /**
 117      * Get identifier separator
 118      *
 119      * @return string
 120      */
 121     public function getIdentifierSeparator()
 122     {
 123         return '.';
 124     }
 125
 126     /**
 127      * Quote identifier in fragment
 128      *
 129      * @param  string $identifier
 130      * @param  array $safeWords
 131      * @return string
 132      */
 133     public function quoteIdentifierInFragment($identifier, array $safeWords = array())
 134     {
 135         $parts = preg_split('#([\.\s\W])#', $identifier, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY);
 136         if ($safeWords) {
 137             $safeWords = array_flip($safeWords);
 138             $safeWords = array_change_key_case($safeWords, CASE_LOWER);
 139         }
 140         foreach ($parts as $i => $part) {
 141             if ($safeWords && isset($safeWords[strtolower($part)])) {
 142                 continue;
 143             }
 144
 145             switch ($part) {
 146                 case ' ':
 147                 case '.':
 148                 case '*':
 149                 case 'AS':
 150                 case 'As':
 151                 case 'aS':
 152                 case 'as':
 153                     break;
 154                 default:
 155                     $parts[$i] = '"' . str_replace('"', '\\' . '"', $part) . '"';
 156             }
 157         }
 158
 159         return implode('', $parts);
 160     }
 161
 162 }