diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2012-06-20 02:10:54 +0200 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2012-06-20 02:10:54 +0200 |
| commit | 8cea7b2a5173a69889d76b1e27469cf15e95cefc (patch) | |
| tree | 120f1f1c10c9881359252a707d1979f558c70fa0 /tests/dbal/concatenate_test.php | |
| parent | 1e3272bfced5e5a2295e6410ef1fec0800b58d99 (diff) | |
| download | forums-8cea7b2a5173a69889d76b1e27469cf15e95cefc.tar forums-8cea7b2a5173a69889d76b1e27469cf15e95cefc.tar.gz forums-8cea7b2a5173a69889d76b1e27469cf15e95cefc.tar.bz2 forums-8cea7b2a5173a69889d76b1e27469cf15e95cefc.tar.xz forums-8cea7b2a5173a69889d76b1e27469cf15e95cefc.zip | |
[ticket/10942] Add unit tests for sql_concatenate
PHPBB3-10942
Diffstat (limited to 'tests/dbal/concatenate_test.php')
| -rw-r--r-- | tests/dbal/concatenate_test.php | 64 |
1 files changed, 64 insertions, 0 deletions
diff --git a/tests/dbal/concatenate_test.php b/tests/dbal/concatenate_test.php new file mode 100644 index 0000000000..0891fa58a0 --- /dev/null +++ b/tests/dbal/concatenate_test.php @@ -0,0 +1,64 @@ +<?php +/** +* +* @package testing +* @copyright (c) 2012 phpBB Group +* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2 +* +*/ + +class phpbb_dbal_concatenate_test extends phpbb_database_test_case +{ + public function getDataSet() + { + return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/config.xml'); + } + + public function test_concatenate_string() + { + $db = $this->new_dbal(); + + $sql = 'SELECT config_name, ' . $db->sql_concatenate('config_name', "'" . $db->sql_escape('append') . "'") . ' AS string + FROM phpbb_config'; + $result = $db->sql_query($sql); + + $db->sql_return_on_error(false); + + $this->assertEquals(array( + array( + 'config_name' => 'config1', + 'string' => 'config1append', + ), + array( + 'config_name' => 'config2', + 'string' => 'config2append', + ), + ), + $db->sql_fetchrowset($result) + ); + } + + public function test_concatenate_statement() + { + $db = $this->new_dbal(); + + $sql = 'SELECT config_name, ' . $db->sql_concatenate('config_name', 'config_value') . ' AS string + FROM phpbb_config'; + $result = $db->sql_query($sql); + + $db->sql_return_on_error(false); + + $this->assertEquals(array( + array( + 'config_name' => 'config1', + 'string' => 'config1foo', + ), + array( + 'config_name' => 'config2', + 'string' => 'config2bar', + ), + ), + $db->sql_fetchrowset($result) + ); + } +} |