aboutsummaryrefslogtreecommitdiffstats
path: root/tests/dbal/dbal.php
diff options
context:
space:
mode:
authorNils Adermann <naderman@naderman.de>2010-10-25 19:20:51 +0200
committerNils Adermann <naderman@naderman.de>2010-10-25 19:43:39 +0200
commitfa8dca2400f1bef5e3faa43e491a5e2c15eafe11 (patch)
tree915487e33eb06061473b15a1bffa0e13ae5a4df3 /tests/dbal/dbal.php
parent9b4da986536e0bce0359d300df84fb03e265ef53 (diff)
downloadforums-fa8dca2400f1bef5e3faa43e491a5e2c15eafe11.tar
forums-fa8dca2400f1bef5e3faa43e491a5e2c15eafe11.tar.gz
forums-fa8dca2400f1bef5e3faa43e491a5e2c15eafe11.tar.bz2
forums-fa8dca2400f1bef5e3faa43e491a5e2c15eafe11.tar.xz
forums-fa8dca2400f1bef5e3faa43e491a5e2c15eafe11.zip
[task/mssql-db-tests] Split up database tests into SELECT and write operations
SELECT is based on the user table fixture, write (INSERT/UPDATE/DELETE) is tested using the config table fixture. PHPBB3-9868
Diffstat (limited to 'tests/dbal/dbal.php')
-rw-r--r--tests/dbal/dbal.php491
1 files changed, 0 insertions, 491 deletions
diff --git a/tests/dbal/dbal.php b/tests/dbal/dbal.php
deleted file mode 100644
index 663323ad61..0000000000
--- a/tests/dbal/dbal.php
+++ /dev/null
@@ -1,491 +0,0 @@
-<?php
-/**
-*
-* @package testing
-* @copyright (c) 2008 phpBB Group
-* @license http://opensource.org/licenses/gpl-license.php GNU Public License
-*
-*/
-
-require_once 'test_framework/framework.php';
-require_once '../phpBB/includes/functions.php';
-
-class phpbb_dbal_test extends phpbb_database_test_case
-{
- public function getDataSet()
- {
- return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/three_users.xml');
- }
-
- public static function return_on_error_select_data()
- {
- return array(
- array('phpbb_users', "username_clean = 'bertie'", array(array('username_clean' => 'bertie'))),
- array('phpbb_users', 'username_clean syntax_error', false),
- );
- }
-
- /**
- * @dataProvider return_on_error_select_data
- */
- public function test_return_on_error_select($table, $where, $expected)
- {
- $db = $this->new_dbal();
-
- $db->sql_return_on_error(true);
-
- $result = $db->sql_query('SELECT username_clean
- FROM ' . $table . '
- WHERE ' . $where . '
- ORDER BY user_id ASC');
-
- $db->sql_return_on_error(false);
-
- $this->assertEquals($expected, $db->sql_fetchrowset($result));
- }
-
- public static function fetchrow_data()
- {
- return array(
- array('', array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'),
- array('username_clean' => 'bertie'))),
- array('user_id = 2', array(array('username_clean' => 'foobar'))),
- array("username_clean = 'bertie'", array(array('username_clean' => 'bertie'))),
- array("username_clean = 'phpBB'", array()),
- );
- }
-
- /**
- * @dataProvider fetchrow_data
- */
- public function test_fetchrow($where, $expected)
- {
- $db = $this->new_dbal();
-
- $result = $db->sql_query('SELECT username_clean
- FROM phpbb_users
- ' . (($where) ? ' WHERE ' . $where : '') . '
- ORDER BY user_id ASC');
-
- $ary = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $ary[] = $row;
- }
- $db->sql_freeresult($result);
-
- $this->assertEquals($expected, $ary);
- }
-
- /**
- * @dataProvider fetchrow_data
- */
- public function test_fetchrowset($where, $expected)
- {
- $db = $this->new_dbal();
-
- $result = $db->sql_query('SELECT username_clean
- FROM phpbb_users
- ' . (($where) ? ' WHERE ' . $where : '') . '
- ORDER BY user_id ASC');
-
- $this->assertEquals($expected, $db->sql_fetchrowset($result));
-
- $db->sql_freeresult($result);
- }
-
- public static function fetchfield_data()
- {
- return array(
- array('', array('barfoo', 'foobar', 'bertie')),
- array('user_id = 2', array('foobar')),
- );
- }
-
- /**
- * @dataProvider fetchfield_data
- */
- public function test_fetchfield($where, $expected)
- {
- $db = $this->new_dbal();
-
- $result = $db->sql_query('SELECT username_clean
- FROM phpbb_users
- ' . (($where) ? ' WHERE ' . $where : '') . '
- ORDER BY user_id ASC');
-
- $ary = array();
- while ($row = $db->sql_fetchfield('username_clean'))
- {
- $ary[] = $row;
- }
- $db->sql_freeresult($result);
-
- $this->assertEquals($expected, $ary);
- }
-
- public static function query_limit_data()
- {
- return array(
- array(0, 0, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'),
- array('username_clean' => 'bertie'))),
- array(0, 1, array(array('username_clean' => 'foobar'),
- array('username_clean' => 'bertie'))),
- array(1, 0, array(array('username_clean' => 'barfoo'))),
- array(1, 2, array(array('username_clean' => 'bertie'))),
- array(2, 0, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'))),
- array(2, 2, array(array('username_clean' => 'bertie'))),
- array(2, 5, array()),
- array(10, 1, array(array('username_clean' => 'foobar'),
- array('username_clean' => 'bertie'))),
- array(10, 5, array()),
- );
- }
-
- /**
- * @dataProvider query_limit_data
- */
- public function test_query_limit($total, $offset, $expected)
- {
- $db = $this->new_dbal();
-
- $result = $db->sql_query_limit('SELECT username_clean
- FROM phpbb_users
- ORDER BY user_id ASC', $total, $offset);
-
- $ary = array();
- while ($row = $db->sql_fetchrow($result))
- {
- $ary[] = $row;
- }
- $db->sql_freeresult($result);
-
- $this->assertEquals($expected, $ary);
- }
-
- public static function like_expression_data()
- {
- // * = any_char; # = one_char
- return array(
- array('barfoo', array(array('username_clean' => 'barfoo'))),
- array('bar', array()),
- array('bar*', array(array('username_clean' => 'barfoo'))),
- array('*bar*', array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'))),
- array('b*r', array()),
- array('b*e', array(array('username_clean' => 'bertie'))),
- array('#b*e', array()),
- array('b####e', array(array('username_clean' => 'bertie'))),
- );
- }
-
- /**
- * @dataProvider like_expression_data
- */
- public function test_like_expression($like_expression, $expected)
- {
- $db = $this->new_dbal();
-
- $like_expression = str_replace('*', $db->any_char, $like_expression);
- $like_expression = str_replace('#', $db->one_char, $like_expression);
- $where = ($like_expression) ? 'username_clean ' . $db->sql_like_expression($like_expression) : '';
-
- $result = $db->sql_query('SELECT username_clean
- FROM phpbb_users
- ' . (($where) ? ' WHERE ' . $where : '') . '
- ORDER BY user_id ASC');
-
- $this->assertEquals($expected, $db->sql_fetchrowset($result));
-
- $db->sql_freeresult($result);
- }
-
- public static function in_set_data()
- {
- return array(
- array('user_id', 3, false, false, array(array('username_clean' => 'bertie'))),
- array('user_id', 3, false, true, array(array('username_clean' => 'bertie'))),
- array('user_id', 3, true, false, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'))),
- array('user_id', 3, true, true, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'))),
- array('username_clean', 'bertie', false, false, array(array('username_clean' => 'bertie'))),
- array('username_clean', 'bertie', false, true, array(array('username_clean' => 'bertie'))),
- array('username_clean', 'bertie', true, false, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'))),
- array('username_clean', 'bertie', true, true, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'))),
- array('user_id', array(3), false, false, array(array('username_clean' => 'bertie'))),
- array('user_id', array(3), false, true, array(array('username_clean' => 'bertie'))),
- array('user_id', array(3), true, false, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'))),
- array('user_id', array(3), true, true, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'))),
- array('user_id', array(1, 3), false, false, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'bertie'))),
- array('user_id', array(1, 3), false, true, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'bertie'))),
- array('user_id', array(1, 3), true, false, array(array('username_clean' => 'foobar'))),
- array('user_id', array(1, 3), true, true, array(array('username_clean' => 'foobar'))),
- array('username_clean', '', false, false, array()),
- array('username_clean', '', false, true, array()),
- array('username_clean', '', true, false, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'),
- array('username_clean' => 'bertie'))),
- array('username_clean', '', true, true, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'),
- array('username_clean' => 'bertie'))),
- array('user_id', array(), false, true, array()),
- array('user_id', array(), true, true, array(array('username_clean' => 'barfoo'),
- array('username_clean' => 'foobar'),
- array('username_clean' => 'bertie'))),
-
- // These here would throw errors and therefor $result should be false.
- // Removing for now because SQLite accepts empty IN() syntax
- /*array('user_id', array(), false, false, false, true),
- array('user_id', array(), true, false, false, true),*/
- );
- }
-
- /**
- * @dataProvider in_set_data
- */
- public function test_in_set($field, $array, $negate, $allow_empty_set, $expected, $catch_error = false)
- {
- $db = $this->new_dbal();
-
- if ($catch_error)
- {
- $db->sql_return_on_error(true);
- }
-
- $result = $db->sql_query('SELECT username_clean
- FROM phpbb_users
- WHERE ' . $db->sql_in_set($field, $array, $negate, $allow_empty_set) . '
- ORDER BY user_id ASC');
-
- if ($catch_error)
- {
- $db->sql_return_on_error(false);
- }
-
- $this->assertEquals($expected, $db->sql_fetchrowset($result));
-
- $db->sql_freeresult($result);
- }
-
- public static function build_array_data()
- {
- return array(
- array(array('username_clean' => 'barfoo'), array(array('username_clean' => 'barfoo'))),
- array(array('username_clean' => 'barfoo', 'user_id' => 1), array(array('username_clean' => 'barfoo'))),
- array(array('username_clean' => 'barfoo', 'user_id' => 2), array()),
-
- // These here would throw errors and therefor $result should be false.
- array(array(), false, true),
- array('no_array', false, true),
- array(0, false, true),
- );
- }
-
- /**
- * @dataProvider build_array_data
- */
- public function test_build_array($assoc_ary, $expected, $catch_error = false)
- {
- $db = $this->new_dbal();
-
- if ($catch_error)
- {
- $db->sql_return_on_error(true);
- }
-
- $sql = 'SELECT username_clean
- FROM phpbb_users
- WHERE ' . $db->sql_build_array('SELECT', $assoc_ary) . '
- ORDER BY user_id ASC';
- $result = $db->sql_query($sql);
-
- if ($catch_error)
- {
- $db->sql_return_on_error(false);
- }
-
- $this->assertEquals($expected, $db->sql_fetchrowset($result));
-
- $db->sql_freeresult($result);
- }
-
- 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 static function delete_data()
- {
- return array(
- array(
- "WHERE config_name = 'test_version'",
- array(
- array(
- 'config_name' => 'second config',
- 'config_value' => '10',
- 'is_dynamic' => 0,
- ),
- ),
- ),
- array(
- '',
- array(),
- ),
- );
- }
-
- /**
- * @dataProvider delete_data
- */
- public function test_delete($where, $expected)
- {
- $db = $this->new_dbal();
-
- $sql = 'DELETE FROM phpbb_config
- ' . $where;
- $result = $db->sql_query($sql);
-
- $sql = 'SELECT *
- FROM phpbb_config';
- $result = $db->sql_query($sql);
-
- $this->assertEquals($expected, $db->sql_fetchrowset($result));
-
- $db->sql_freeresult($result);
- }
-
- public function test_multiple_insert()
- {
- $db = $this->new_dbal();
-
- $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' => '20',
- 'is_dynamic' => 0,
- ),
- " WHERE config_name = 'batch one'",
- array(
- array(
- 'config_name' => 'batch one',
- 'config_value' => '20',
- 'is_dynamic' => 0,
- ),
- array(
- 'config_name' => 'batch two',
- 'config_value' => 'b2',
- 'is_dynamic' => 1,
- ),
- ),
- ),
- array(
- array(
- 'config_value' => '0',
- 'is_dynamic' => 1,
- ),
- '',
- array(
- array(
- 'config_name' => 'batch one',
- 'config_value' => '0',
- 'is_dynamic' => 1,
- ),
- array(
- 'config_name' => 'batch two',
- '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);
- }
-}
generated by cgit v1.2.1 (git 2.21.0) at 2024-09-22 14:23:50 +0000