diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2012-06-20 12:57:08 +0200 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2012-06-20 12:57:08 +0200 |
| commit | 089e5f5c79965058a5288590a3a34d94f3bcb833 (patch) | |
| tree | 0a018e866f14b4332ed7b620a327c7137df549bb /tests/dbal/case_test.php | |
| parent | 79dfdf94063cf7cc64197e50807977acaf9a2e66 (diff) | |
| download | forums-089e5f5c79965058a5288590a3a34d94f3bcb833.tar forums-089e5f5c79965058a5288590a3a34d94f3bcb833.tar.gz forums-089e5f5c79965058a5288590a3a34d94f3bcb833.tar.bz2 forums-089e5f5c79965058a5288590a3a34d94f3bcb833.tar.xz forums-089e5f5c79965058a5288590a3a34d94f3bcb833.zip | |
[ticket/10942] Rename method sql_conditional() to sql_case()
PHPBB3-10942
Diffstat (limited to 'tests/dbal/case_test.php')
| -rw-r--r-- | tests/dbal/case_test.php | 64 |
1 files changed, 64 insertions, 0 deletions
diff --git a/tests/dbal/case_test.php b/tests/dbal/case_test.php new file mode 100644 index 0000000000..7e966c0ec1 --- /dev/null +++ b/tests/dbal/case_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_case_test extends phpbb_database_test_case +{ + public function getDataSet() + { + return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/config.xml'); + } + + public function test_case_string() + { + $db = $this->new_dbal(); + + $sql = 'SELECT config_name, ' . $db->sql_case('is_dynamic = 1', "'" . $db->sql_escape('true') . "'", "'" . $db->sql_escape('false') . "'") . ' AS string + FROM phpbb_config'; + $result = $db->sql_query($sql); + + $db->sql_return_on_error(false); + + $this->assertEquals(array( + array( + 'config_name' => 'config1', + 'string' => 'false', + ), + array( + 'config_name' => 'config2', + 'string' => 'true', + ), + ), + $db->sql_fetchrowset($result) + ); + } + + public function test_case_statement() + { + $db = $this->new_dbal(); + + $sql = 'SELECT config_name, ' . $db->sql_case('is_dynamic = 1', 'is_dynamic', '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' => 'foo', + ), + array( + 'config_name' => 'config2', + 'string' => '1', + ), + ), + $db->sql_fetchrowset($result) + ); + } +} |