[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3  *
   4  * This file is part of the phpBB Forum Software package.
   5  *
   6  * @copyright (c) phpBB Limited <https://www.phpbb.com>
   7  * @license GNU General Public License, version 2 (GPL-2.0)
   8  *
   9  * For full copyright and license information, please see
  10  * the docs/CREDITS.txt file.
  11  *
  12  */
  13  
  14  namespace phpbb\db\driver;
  15  
  16  /**
  17  * MSSQL Database Base Abstraction Layer
  18   */
  19  abstract class mssql_base extends \phpbb\db\driver\driver
  20  {
  21      /**
  22      * {@inheritDoc}
  23      */
  24  	public function sql_concatenate($expr1, $expr2)
  25      {
  26          return $expr1 . ' + ' . $expr2;
  27      }
  28  
  29      /**
  30      * {@inheritDoc}
  31      */
  32  	function sql_escape($msg)
  33      {
  34          return str_replace(array("'", "\0"), array("''", ''), $msg);
  35      }
  36  
  37      /**
  38      * {@inheritDoc}
  39      */
  40  	function sql_lower_text($column_name)
  41      {
  42          return "LOWER(SUBSTRING($column_name, 1, DATALENGTH($column_name)))";
  43      }
  44  
  45      /**
  46      * Build LIKE expression
  47      * @access private
  48      */
  49  	function _sql_like_expression($expression)
  50      {
  51          return $expression . " ESCAPE '\\'";
  52      }
  53  
  54      /**
  55      * Build NOT LIKE expression
  56      * @access private
  57      */
  58  	function _sql_not_like_expression($expression)
  59      {
  60          return $expression . " ESCAPE '\\'";
  61      }
  62  
  63      /**
  64      * {@inheritDoc}
  65      */
  66  	function cast_expr_to_bigint($expression)
  67      {
  68          return 'CONVERT(BIGINT, ' . $expression . ')';
  69      }
  70  
  71      /**
  72      * Build db-specific query data
  73      * @access private
  74      */
  75  	function _sql_custom_build($stage, $data)
  76      {
  77          return $data;
  78      }
  79  
  80      /**
  81      * {@inheritDoc}
  82      */
  83  	function sql_quote($msg)
  84      {
  85          return '"' . $msg . '"';
  86      }
  87  }