diff options
| author | Igor Wiedler <igor@wiedler.ch> | 2011-01-10 00:18:37 +0100 |
|---|---|---|
| committer | Igor Wiedler <igor@wiedler.ch> | 2011-01-10 00:18:37 +0100 |
| commit | 01fe91c5c4e897801f5c179cd4060e686762f105 (patch) | |
| tree | 178535f1cecfa2fd5748b21f9d59d1d471d1bd35 /tests/dbal/write.php | |
| parent | 0a945100fd285658f1c3c936d413939eb11a6e16 (diff) | |
| download | forums-01fe91c5c4e897801f5c179cd4060e686762f105.tar forums-01fe91c5c4e897801f5c179cd4060e686762f105.tar.gz forums-01fe91c5c4e897801f5c179cd4060e686762f105.tar.bz2 forums-01fe91c5c4e897801f5c179cd4060e686762f105.tar.xz forums-01fe91c5c4e897801f5c179cd4060e686762f105.zip | |
[ticket/9987] Rename test files to include a _test suffix
PHPBB3-9987
Diffstat (limited to 'tests/dbal/write.php')
| -rw-r--r-- | tests/dbal/write.php | 171 |
1 files changed, 0 insertions, 171 deletions
diff --git a/tests/dbal/write.php b/tests/dbal/write.php deleted file mode 100644 index a24b6efcc4..0000000000 --- a/tests/dbal/write.php +++ /dev/null @@ -1,171 +0,0 @@ -<?php -/** -* -* @package testing -* @copyright (c) 2008 phpBB Group -* @license http://opensource.org/licenses/gpl-license.php GNU Public License -* -*/ - -require_once __DIR__ . '/../../phpBB/includes/functions.php'; - -class phpbb_dbal_write_test extends phpbb_database_test_case -{ - public function getDataSet() - { - return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/config.xml'); - } - - public static function build_array_insert_data() - { - return array( - array(array( - 'config_name' => 'test_version', - 'config_value' => '0.0.0', - 'is_dynamic' => 1, - )), - array(array( - 'config_name' => 'second config', - 'config_value' => '10', - 'is_dynamic' => 0, - )), - ); - } - - /** - * @dataProvider build_array_insert_data - */ - public function test_build_array_insert($sql_ary) - { - $db = $this->new_dbal(); - - $sql = 'INSERT INTO phpbb_config ' . $db->sql_build_array('INSERT', $sql_ary); - $result = $db->sql_query($sql); - - $sql = "SELECT * - FROM phpbb_config - WHERE config_name = '" . $sql_ary['config_name'] . "'"; - $result = $db->sql_query_limit($sql, 1); - - $this->assertEquals($sql_ary, $db->sql_fetchrow($result)); - - $db->sql_freeresult($result); - } - - public function test_delete() - { - $db = $this->new_dbal(); - - $sql = "DELETE FROM phpbb_config - WHERE config_name = 'config1'"; - $result = $db->sql_query($sql); - - $sql = 'SELECT * - FROM phpbb_config'; - $result = $db->sql_query($sql); - $rows = $db->sql_fetchrowset($result); - - $this->assertEquals(1, sizeof($rows)); - $this->assertEquals('config2', $rows[0]['config_name']); - - $db->sql_freeresult($result); - } - - public function test_multiple_insert() - { - $db = $this->new_dbal(); - - // empty the table - $sql = 'DELETE FROM phpbb_config'; - $db->sql_query($sql); - - $batch_ary = array( - array( - 'config_name' => 'batch one', - 'config_value' => 'b1', - 'is_dynamic' => 0, - ), - array( - 'config_name' => 'batch two', - 'config_value' => 'b2', - 'is_dynamic' => 1, - ), - ); - - $result = $db->sql_multi_insert('phpbb_config', $batch_ary); - - $sql = 'SELECT * - FROM phpbb_config - ORDER BY config_name ASC'; - $result = $db->sql_query($sql); - - $this->assertEquals($batch_ary, $db->sql_fetchrowset($result)); - - $db->sql_freeresult($result); - } - - public static function update_data() - { - return array( - array( - array( - 'config_value' => '23', - 'is_dynamic' => 0, - ), - " WHERE config_name = 'config1'", - array( - array( - 'config_name' => 'config1', - 'config_value' => '23', - 'is_dynamic' => 0, - ), - array( - 'config_name' => 'config2', - 'config_value' => 'bar', - 'is_dynamic' => 1, - ), - ), - ), - array( - array( - 'config_value' => '0', - 'is_dynamic' => 1, - ), - '', - array( - array( - 'config_name' => 'config1', - 'config_value' => '0', - 'is_dynamic' => 1, - ), - array( - 'config_name' => 'config2', - 'config_value' => '0', - 'is_dynamic' => 1, - ), - ), - ), - ); - } - - /** - * @dataProvider update_data - */ - public function test_update($sql_ary, $where, $expected) - { - $db = $this->new_dbal(); - - $sql = 'UPDATE phpbb_config - SET ' . $db->sql_build_array('UPDATE', $sql_ary) . $where; - $result = $db->sql_query($sql); - - $sql = 'SELECT * - FROM phpbb_config - ORDER BY config_name ASC'; - $result = $db->sql_query($sql); - - $this->assertEquals($expected, $db->sql_fetchrowset($result)); - - $db->sql_freeresult($result); - } -} |