Code Coverage for /data/phpBB/phpbb/db/driver/mssql

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	}