diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2013-04-19 10:15:03 +0200 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2013-04-19 19:11:22 +0200 |
| commit | db5df5b6ac025f360cdc97182678536d88c0dccb (patch) | |
| tree | 89221519cb2ed0fbff4e33811445c7c4dc14f0d9 /phpBB/includes/db/driver/mssql_base.php | |
| parent | ae240930cd267943c536677c67b9fcd153ff5137 (diff) | |
| download | forums-db5df5b6ac025f360cdc97182678536d88c0dccb.tar forums-db5df5b6ac025f360cdc97182678536d88c0dccb.tar.gz forums-db5df5b6ac025f360cdc97182678536d88c0dccb.tar.bz2 forums-db5df5b6ac025f360cdc97182678536d88c0dccb.tar.xz forums-db5df5b6ac025f360cdc97182678536d88c0dccb.zip | |
[ticket/10966] Introduce MSSQL base class for native and ODBC
PHPBB3-10966
Diffstat (limited to 'phpBB/includes/db/driver/mssql_base.php')
| -rw-r--r-- | phpBB/includes/db/driver/mssql_base.php | 65 |
1 files changed, 65 insertions, 0 deletions
diff --git a/phpBB/includes/db/driver/mssql_base.php b/phpBB/includes/db/driver/mssql_base.php new file mode 100644 index 0000000000..56c111c871 --- /dev/null +++ b/phpBB/includes/db/driver/mssql_base.php @@ -0,0 +1,65 @@ +<?php +/** +* +* @package dbal +* @copyright (c) 2013 phpBB Group +* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2 +* +*/ + +/** +* @ignore +*/ +if (!defined('IN_PHPBB')) +{ + exit; +} + +/** +* MSSQL Database Base Abstraction Layer +* @package dbal + */ +abstract class phpbb_db_driver_mssql_base extends phpbb_db_driver +{ + /** + * {@inheritDoc} + */ + public function sql_concatenate($expr1, $expr2) + { + return $expr1 . ' + ' . $expr2; + } + + /** + * Escape string used in sql query + */ + function sql_escape($msg) + { + return str_replace(array("'", "\0"), array("''", ''), $msg); + } + + /** + * {@inheritDoc} + */ + function sql_lower_text($column_name) + { + return "LOWER(SUBSTRING($column_name, 1, DATALENGTH($column_name)))"; + } + + /** + * Build LIKE expression + * @access private + */ + function _sql_like_expression($expression) + { + return $expression . " ESCAPE '\\'"; + } + + /** + * Build db-specific query data + * @access private + */ + function _sql_custom_build($stage, $data) + { + return $data; + } +} |