+- json (also a phpBB dependency)

+- pcntl (flock class)

+- redis (https://github.com/nicolasff/phpredis, Redis cache driver)

+ $dbms = 'phpbb_db_driver_mysqli';

+Redis

+-----

+

+In order to run tests for the Redis cache driver, at least one of Redis host

+or port must be specified in test configuration. This can be done via

+test_config.php as follows:

+

+ <?php

+ $phpbb_redis_host = 'localhost';

+ $phpbb_redis_port = 6379;

+

+Or via environment variables as follows:

+

+ $ PHPBB_TEST_REDIS_HOST=localhost PHPBB_TEST_REDIS_PORT=6379 phpunit

+

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>username</column>

+ <column>username_clean</column>

+ <column>user_password</column>

+ <column>user_passchg</column>

+ <column>user_pass_convert</column>

+ <column>user_email</column>

+ <column>user_type</column>

+ <column>user_login_attempts</column>

+ <column>user_permissions</column>

+ <column>user_sig</column>

+ <column>user_occ</column>

+ <column>user_interests</column>

+ <row>

+ <value>1</value>

+ <value>foobar</value>

+ <value>foobar</value>

+ <value>$H$9E45lK6J8nLTSm9oJE5aNCSTFK9wqa/</value>

+ <value>0</value>

+ <value>0</value>

+ <value>example@example.com</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+</dataset>

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__).'/../../phpBB/includes/functions.php';

+

+class phpbb_auth_provider_apache_test extends phpbb_database_test_case

+{

+ protected $provider;

+ protected $user;

+ protected $request;

+

+ protected function setup()

+ {

+ parent::setUp();

+

+ global $phpbb_root_path, $phpEx;

+

+ $db = $this->new_dbal();

+ $config = new phpbb_config(array());

+ $this->request = $this->getMock('phpbb_request');

+ $this->user = $this->getMock('phpbb_user');

+

+ $this->provider = new phpbb_auth_provider_apache($db, $config, $this->request, $this->user, $phpbb_root_path, $phpEx);

+ }

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/user.xml');

+ }

+

+ /**

+ * Test to see if a user is identified to Apache. Expects false if they are.

+ */

+ public function test_init()

+ {

+ $this->user->data['username'] = 'foobar';

+ $this->request->expects($this->once())

+ ->method('is_set')

+ ->with('PHP_AUTH_USER',

+ phpbb_request_interface::SERVER)

+ ->will($this->returnValue(true));

+ $this->request->expects($this->once())

+ ->method('server')

+ ->with('PHP_AUTH_USER')

+ ->will($this->returnValue('foobar'));

+

+ $this->assertFalse($this->provider->init());

+ }

+

+ public function test_login()

+ {

+ $username = 'foobar';

+ $password = 'example';

+

+ $this->request->expects($this->once())

+ ->method('is_set')

+ ->with('PHP_AUTH_USER',

+ phpbb_request_interface::SERVER)

+ ->will($this->returnValue(true));

+ $this->request->expects($this->at(1))

+ ->method('server')

+ ->with('PHP_AUTH_USER')

+ ->will($this->returnValue('foobar'));

+ $this->request->expects($this->at(2))

+ ->method('server')

+ ->with('PHP_AUTH_PW')

+ ->will($this->returnValue('example'));

+

+ $expected = array(

+ 'status' => LOGIN_SUCCESS,

+ 'error_msg' => false,

+ 'user_row' => array(

+ 'user_id' => '1',

+ 'username' => 'foobar',

+ 'user_password' => '$H$9E45lK6J8nLTSm9oJE5aNCSTFK9wqa/',

+ 'user_passchg' => '0',

+ 'user_email' => 'example@example.com',

+ 'user_type' => '0',

+ ),

+ );

+

+ $this->assertEquals($expected, $this->provider->login($username, $password));

+ }

+

+ public function test_autologin()

+ {

+ $this->request->expects($this->once())

+ ->method('is_set')

+ ->with('PHP_AUTH_USER',

+ phpbb_request_interface::SERVER)

+ ->will($this->returnValue(true));

+ $this->request->expects($this->at(1))

+ ->method('server')

+ ->with('PHP_AUTH_USER')

+ ->will($this->returnValue('foobar'));

+ $this->request->expects($this->at(2))

+ ->method('server')

+ ->with('PHP_AUTH_PW')

+ ->will($this->returnValue('example'));

+

+ $expected = array(

+ 'user_id' => '1',

+ 'user_type' => '0',

+ 'group_id' => '3',

+ 'user_permissions' => '',

+ 'user_perm_from' => '0',

+ 'user_ip' => '',

+ 'user_regdate' => '0',

+ 'username' => 'foobar',

+ 'username_clean' => 'foobar',

+ 'user_password' => '$H$9E45lK6J8nLTSm9oJE5aNCSTFK9wqa/',

+ 'user_passchg' => '0',

+ 'user_pass_convert' => '0',

+ 'user_email' => 'example@example.com',

+ 'user_email_hash' => '0',

+ 'user_birthday' => '',

+ 'user_lastvisit' => '0',

+ 'user_lastmark' => '0',

+ 'user_lastpost_time' => '0',

+ 'user_lastpage' => '',

+ 'user_last_confirm_key' => '',

+ 'user_last_search' => '0',

+ 'user_warnings' => '0',

+ 'user_last_warning' => '0',

+ 'user_login_attempts' => '0',

+ 'user_inactive_reason' => '0',

+ 'user_inactive_time' => '0',

+ 'user_posts' => '0',

+ 'user_lang' => '',

+ 'user_timezone' => 'UTC',

+ 'user_dateformat' => 'd M Y H:i',

+ 'user_style' => '0',

+ 'user_rank' => '0',

+ 'user_colour' => '',

+ 'user_new_privmsg' => '0',

+ 'user_unread_privmsg' => '0',

+ 'user_last_privmsg' => '0',

+ 'user_message_rules' => '0',

+ 'user_full_folder' => '-3',

+ 'user_emailtime' => '0',

+ 'user_topic_show_days' => '0',

+ 'user_topic_sortby_type' => 't',

+ 'user_topic_sortby_dir' => 'd',

+ 'user_post_show_days' => '0',

+ 'user_post_sortby_type' => 't',

+ 'user_post_sortby_dir' => 'a',

+ 'user_notify' => '0',

+ 'user_notify_pm' => '1',

+ 'user_notify_type' => '0',

+ 'user_allow_pm' => '1',

+ 'user_allow_viewonline' => '1',

+ 'user_allow_viewemail' => '1',

+ 'user_allow_massemail' => '1',

+ 'user_options' => '230271',

+ 'user_avatar' => '',

+ 'user_avatar_type' => '',

+ 'user_avatar_width' => '0',

+ 'user_avatar_height' => '0',

+ 'user_sig' => '',

+ 'user_sig_bbcode_uid' => '',

+ 'user_sig_bbcode_bitfield' => '',

+ 'user_from' => '',

+ 'user_icq' => '',

+ 'user_aim' => '',

+ 'user_yim' => '',

+ 'user_msnm' => '',

+ 'user_jabber' => '',

+ 'user_website' => '',

+ 'user_occ' => '',

+ 'user_interests' => '',

+ 'user_actkey' => '',

+ 'user_newpasswd' => '',

+ 'user_form_salt' => '',

+ 'user_new' => '1',

+ 'user_reminded' => '0',

+ 'user_reminded_time' => '0',

+ );

+

+ $this->assertEquals($expected, $this->provider->autologin());

+ }

+

+ public function test_validate_session()

+ {

+ $user = array(

+ 'username' => 'foobar',

+ 'user_type'

+ );

+ $this->request->expects($this->once())

+ ->method('is_set')

+ ->with('PHP_AUTH_USER',

+ phpbb_request_interface::SERVER)

+ ->will($this->returnValue(true));

+ $this->request->expects($this->once())

+ ->method('server')

+ ->with('PHP_AUTH_USER')

+ ->will($this->returnValue('foobar'));

+

+ $this->assertTrue($this->provider->validate_session($user));

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__).'/../../phpBB/includes/functions.php';

+

+class phpbb_auth_provider_db_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/user.xml');

+ }

+

+ public function test_login()

+ {

+ global $phpbb_root_path, $phpEx;

+

+ $db = $this->new_dbal();

+ $config = new phpbb_config(array(

+ 'ip_login_limit_max' => 0,

+ 'ip_login_limit_use_forwarded' => 0,

+ 'max_login_attempts' => 0,

+ ));

+ $request = $this->getMock('phpbb_request');

+ $user = $this->getMock('phpbb_user');

+ $provider = new phpbb_auth_provider_db($db, $config, $request, $user, $phpbb_root_path, $phpEx);

+

+ $expected = array(

+ 'status' => LOGIN_SUCCESS,

+ 'error_msg' => false,

+ 'user_row' => array(

+ 'user_id' => '1',

+ 'username' => 'foobar',

+ 'user_password' => '$H$9E45lK6J8nLTSm9oJE5aNCSTFK9wqa/',

+ 'user_passchg' => '0',

+ 'user_pass_convert' => '0',

+ 'user_email' => 'example@example.com',

+ 'user_type' => '0',

+ 'user_login_attempts' => '0',

+ ),

+ );

+

+ $this->assertEquals($expected, $provider->login('foobar', 'example'));

+ }

+}

+<?php

+

+class phpbb_avatar_driver_barfoo extends phpbb_avatar_driver

+{

+ public function get_data($row)

+ {

+ return array();

+ }

+

+ public function prepare_form($request, $template, $user, $row, &$error)

+ {

+ return false;

+ }

+

+ public function process_form($request, $template, $user, $row, &$error)

+ {

+ return false;

+ }

+}

+<?php

+

+class phpbb_avatar_driver_foobar extends phpbb_avatar_driver

+{

+ public function get_data($row)

+ {

+ return array();

+ }

+

+ public function prepare_form($request, $template, $user, $row, &$error)

+ {

+ return false;

+ }

+

+ public function process_form($request, $template, $user, $row, &$error)

+ {

+ return false;

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__) . '/driver/foobar.php';

+

+class phpbb_avatar_manager_test extends PHPUnit_Framework_TestCase

+{

+ public function setUp()

+ {

+ global $phpbb_root_path, $phpEx;

+

+ // Mock phpbb_container

+ $this->phpbb_container = $this->getMock('Symfony\Component\DependencyInjection\ContainerInterface');

+ $this->phpbb_container->expects($this->any())

+ ->method('get')

+ ->with('avatar.driver.foobar')->will($this->returnValue('avatar.driver.foobar'));

+

+ // Prepare dependencies for avatar manager and driver

+ $config = new phpbb_config(array());

+ $request = $this->getMock('phpbb_request');

+ $cache = $this->getMock('phpbb_cache_driver_interface');

+

+ $this->avatar_foobar = $this->getMock('phpbb_avatar_driver_foobar', array('get_name'), array($config, $phpbb_root_path, $phpEx, $cache));

+ $this->avatar_foobar->expects($this->any())

+ ->method('get_name')

+ ->will($this->returnValue('avatar.driver.foobar'));

+ $this->avatar_barfoo = $this->getMock('phpbb_avatar_driver_barfoo', array('get_name'));

+ $this->avatar_barfoo->expects($this->any())

+ ->method('get_name')

+ ->will($this->returnValue('avatar.driver.barfoo'));

+

+ $avatar_drivers = array($this->avatar_foobar, $this->avatar_barfoo);

+

+ $config['allow_avatar_' . get_class($this->avatar_foobar)] = true;

+ $config['allow_avatar_' . get_class($this->avatar_barfoo)] = false;

+

+ // Set up avatar manager

+ $this->manager = new phpbb_avatar_manager($config, $avatar_drivers, $this->phpbb_container);

+ }

+

+ public function test_get_driver()

+ {

+ $driver = $this->manager->get_driver('avatar.driver.foobar', false);

+ $this->assertEquals('avatar.driver.foobar', $driver);

+

+ $driver = $this->manager->get_driver('avatar.driver.foo_wrong', false);

+ $this->assertNull($driver);

+

+ $driver = $this->manager->get_driver('avatar.driver.foobar');

+ $this->assertEquals('avatar.driver.foobar', $driver);

+

+ $driver = $this->manager->get_driver('avatar.driver.foo_wrong');

+ $this->assertNull($driver);

+ }

+

+ public function test_get_all_drivers()

+ {

+ $drivers = $this->manager->get_all_drivers();

+ $this->assertArrayHasKey('avatar.driver.foobar', $drivers);

+ $this->assertArrayHasKey('avatar.driver.barfoo', $drivers);

+ $this->assertEquals('avatar.driver.foobar', $drivers['avatar.driver.foobar']);

+ $this->assertEquals('avatar.driver.barfoo', $drivers['avatar.driver.barfoo']);

+ }

+

+ public function test_get_enabled_drivers()

+ {

+ $drivers = $this->manager->get_enabled_drivers();

+ $this->assertArrayHasKey('avatar.driver.foobar', $drivers);

+ $this->assertArrayNotHasKey('avatar.driver.barfoo', $drivers);

+ $this->assertEquals('avatar.driver.foobar', $drivers['avatar.driver.foobar']);

+ }

+

+ public function test_get_avatar_settings()

+ {

+ $avatar_settings = $this->manager->get_avatar_settings($this->avatar_foobar);

+

+ $expected_settings = array(

+ 'allow_avatar_' . get_class($this->avatar_foobar) => array('lang' => 'ALLOW_' . strtoupper(get_class($this->avatar_foobar)), 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

+ );

+

+ $this->assertEquals($expected_settings, $avatar_settings);

+ }

+

+ public function database_row_data()

+ {

+ return array(

+ array(

+ array(

+ 'user_avatar' => '',

+ 'user_avatar_type' => '',

+ 'user_avatar_width' => '',

+ 'user_avatar_height' => '',

+ ),

+ array(

+ 'avatar' => '',

+ 'avatar_type' => '',

+ 'avatar_width' => '',

+ 'avatar_height' => '',

+ ),

+ ),

+ array(

+ array(

+ 'group_avatar' => '',

+ 'group_avatar_type' => '',

+ 'group_avatar_width' => '',

+ 'group_avatar_height' => '',

+ ),

+ array(

+ 'avatar' => '',

+ 'avatar_type' => '',

+ 'avatar_width' => '',

+ 'avatar_height' => '',

+ ),

+ ),

+ array(

+ array(),

+ array(

+ 'avatar' => '',

+ 'avatar_type' => '',

+ 'avatar_width' => '',

+ 'avatar_height' => '',

+ ),

+ ),

+ array(

+ array(

+ 'foobar_avatar' => '',

+ 'foobar_avatar_type' => '',

+ 'foobar_avatar_width' => '',

+ 'foobar_avatar_height' => '',

+ ),

+ array(

+ 'foobar_avatar' => '',

+ 'foobar_avatar_type' => '',

+ 'foobar_avatar_width' => '',

+ 'foobar_avatar_height' => '',

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider database_row_data

+ */

+ public function test_clean_row(array $input, array $output)

+ {

+ $cleaned_row = array();

+

+ $cleaned_row = phpbb_avatar_manager::clean_row($input);

+ foreach ($output as $key => $null)

+ {

+ $this->assertArrayHasKey($key, $cleaned_row);

+ }

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions_content.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/bbcode.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/message_parser.php';

+

+class phpbb_bbcode_parser_test extends PHPUnit_Framework_TestCase

+{

+ public function bbcode_firstpass_data()

+ {

+ return array(

+ // Default bbcodes from in their simplest way

+ array(

+ 'Test default bbcodes: simple bold',

+ '[b]bold[/b]',

+ '[b:]bold[/b:]',

+ ),

+ array(

+ 'Test default bbcodes: simple underlined',

+ '[u]underlined[/u]',

+ '[u:]underlined[/u:]',

+ ),

+ array(

+ 'Test default bbcodes: simple italic',

+ '[i]italic[/i]',

+ '[i:]italic[/i:]',

+ ),

+ array(

+ 'Test default bbcodes: simple color rgb',

+ '[color=#FF0000]colored[/color]',

+ '[color=#FF0000:]colored[/color:]',

+ ),

+ array(

+ 'Test default bbcodes: simple color name',

+ '[color=red]colored[/color]',

+ '[color=red:]colored[/color:]',

+ ),

+ array(

+ 'Test default bbcodes: simple size',

+ '[size=75]smaller[/size]',

+ '[size=75:]smaller[/size:]',

+ ),

+ array(

+ 'Test default bbcodes: simple quote',

+ '[quote]quoted[/quote]',

+ '[quote:]quoted[/quote:]',

+ ),

+ array(

+ 'Test default bbcodes: simple quote with username',

+ '[quote=&quot;username&quot;]quoted[/quote]',

+ '[quote=&quot;username&quot;:]quoted[/quote:]',

+ ),

+ array(

+ 'Test default bbcodes: simple code',

+ '[code]unparsed code[/code]',

+ '[code:]unparsed code[/code:]',

+ ),

+ array(

+ 'Test default bbcodes: simple php code',

+ '[code=php]unparsed code[/code]',

+ '[code=php:]<span class="syntaxdefault">unparsed&nbsp;code</span>[/code:]',

+ ),

+ array(

+ 'Test default bbcodes: simple list',

+ '[list]no item[/list]',

+ '[list:]no item[/list:u:]',

+ ),

+ array(

+ 'Test default bbcodes: simple list-item only',

+ '[*]unparsed',

+ '[*]unparsed',

+ ),

+ array(

+ 'Test default bbcodes: simple list-item',

+ '[list][*]item[/list]',

+ '[list:][*:]item[/*:m:][/list:u:]',

+ ),

+ array(

+ 'Test default bbcodes: simple list-item closed',

+ '[list][*]item[/*][/list]',

+ '[list:][*:]item[/*:][/list:u:]',

+ ),

+ array(

+ 'Test default bbcodes: simple list-item numbered',

+ '[list=1][*]item[/list]',

+ '[list=1:][*:]item[/*:m:][/list:o:]',

+ ),

+ array(

+ 'Test default bbcodes: simple list-item alpha',

+ '[list=a][*]item[/list]',

+ '[list=a:][*:]item[/*:m:][/list:o:]',

+ ),

+ array(

+ 'Test default bbcodes: simple list-item roman',

+ '[list=i][*]item[/list]',

+ '[list=i:][*:]item[/*:m:][/list:o:]',

+ ),

+ array(

+ 'Test default bbcodes: simple list-item disc',

+ '[list=disc][*]item[/list]',

+ '[list=disc:][*:]item[/*:m:][/list:u:]',

+ ),

+ array(

+ 'Test default bbcodes: simple list-item circle',

+ '[list=circle][*]item[/list]',

+ '[list=circle:][*:]item[/*:m:][/list:u:]',

+ ),

+ array(

+ 'Test default bbcodes: simple list-item square',

+ '[list=square][*]item[/list]',

+ '[list=square:][*:]item[/*:m:][/list:u:]',

+ ),

+ array(

+ 'Test default bbcodes: simple img',

+ '[img]https://area51.phpbb.com/images/area51.png[/img]',

+ '[img:]https&#58;//area51&#46;phpbb&#46;com/images/area51&#46;png[/img:]',

+ ),

+ array(

+ 'Test default bbcodes: simple url',

+ '[url]https://area51.phpbb.com/[/url]',

+ '[url:]https&#58;//area51&#46;phpbb&#46;com/[/url:]',

+ ),

+ array(

+ 'Test default bbcodes: simple url with description',

+ '[url=https://area51.phpbb.com/]Area51[/url]',

+ '[url=https&#58;//area51&#46;phpbb&#46;com/:]Area51[/url:]',

+ ),

+ array(

+ 'Test default bbcodes: simple email',

+ '[email]bbcode-test@phpbb.com[/email]',

+ '[email:]bbcode-test@phpbb&#46;com[/email:]',

+ ),

+ array(

+ 'Test default bbcodes: simple email with description',

+ '[email=bbcode-test@phpbb.com]Email[/email]',

+ '[email=bbcode-test@phpbb&#46;com:]Email[/email:]',

+ ),

+ array(

+ 'Test default bbcodes: simple attachment',

+ '[attachment=0]filename[/attachment]',

+ '[attachment=0:]<!-- ia0 -->filename<!-- ia0 -->[/attachment:]',

+ ),

+

+ // Special cases for quote which were reported as bugs before

+ array(

+ 'PHPBB3-1401 - correct: parsed',

+ '[quote=&quot;&#91;test]test&quot;]test [ test[/quote]',

+ '[quote=&quot;&#91;test]test&quot;:]test [ test[/quote:]',

+ ),

+ array(

+ 'PHPBB3-6117 - correct: parsed',

+ '[quote]test[/quote] test ] and [ test [quote]test[/quote]',

+ '[quote:]test[/quote:] test ] and [ test [quote:]test[/quote:]',

+ ),

+ array(

+ 'PHPBB3-6200 - correct: parsed',

+ '[quote=&quot;[&quot;]test[/quote]',

+ '[quote=&quot;&#91;&quot;:]test[/quote:]',

+ ),

+ array(

+ 'PHPBB3-9364 - quoted: "test[/[/b]quote] test" / non-quoted: "[/quote] test" - also failed if layout distorted',

+ '[quote]test[/[/b]quote] test [/quote][/quote] test',

+ '[quote:]test[/[/b]quote] test [/quote:][/quote] test',

+ ),

+ array(

+ 'PHPBB3-8096 - first quote tag parsed, second quote tag unparsed',

+ '[quote=&quot;a&quot;]a[/quote][quote=&quot;a]a[/quote]',

+ '[quote=&quot;a&quot;:]a[/quote:][quote=&quot;a]a[/quote]',

+ ),

+

+ // Simple bbcodes nesting

+ array(

+ 'Allow textual bbcodes in textual bbcodes',

+ '[b]bold [i]bold + italic[/i][/b]',

+ '[b:]bold [i:]bold + italic[/i:][/b:]',

+ ),

+ array(

+ 'Allow textual bbcodes in url with description',

+ '[url=https://area51.phpbb.com/]Area51 [i]italic[/i][/url]',

+ '[url=https&#58;//area51&#46;phpbb&#46;com/:]Area51 [i:]italic[/i:][/url:]',

+ ),

+ array(

+ 'Allow url with description in textual bbcodes',

+ '[i]italic [url=https://area51.phpbb.com/]Area51[/url][/i]',

+ '[i:]italic [url=https&#58;//area51&#46;phpbb&#46;com/:]Area51[/url:][/i:]',

+ ),

+

+ // Nesting bbcodes into quote usernames

+ array(

+ 'Allow textual bbcodes in usernames',

+ '[quote=&quot;[i]test[/i]&quot;]test[/quote]',

+ '[quote=&quot;[i:]test[/i:]&quot;:]test[/quote:]',

+ ),

+ array(

+ 'Allow links bbcodes in usernames',

+ '[quote=&quot;[url=https://area51.phpbb.com/]test[/url]&quot;]test[/quote]',

+ '[quote=&quot;[url=https&#58;//area51&#46;phpbb&#46;com/:]test[/url:]&quot;:]test[/quote:]',

+ ),

+ array(

+ 'Allow img bbcodes in usernames - Username displayed the image',

+ '[quote=&quot;[img]https://area51.phpbb.com/images/area51.png[/img]&quot;]test[/quote]',

+ '[quote=&quot;[img:]https&#58;//area51&#46;phpbb&#46;com/images/area51&#46;png[/img:]&quot;:]test[/quote:]',

+ ),

+ array(

+ 'Disallow flash bbcodes in usernames - Username displayed as [flash]http://www.phpbb.com/[/flash]',

+ '[quote=&quot;[flash]http://www.phpbb.com/[/flash]&quot;]test[/quote]',

+ '[quote=&quot;&#91;flash]http://www.phpbb.com/&#91;/flash]&quot;:]test[/quote:]',

+ ),

+ array(

+ 'Disallow quote bbcodes in usernames - Username displayed as [quote]test[/quote]',

+ '[quote=&quot;[quote]test[/quote]&quot;]test[/quote]',

+ '[quote=&quot;&#91;quote]test&#91;/quote]&quot;:]test[/quote:]',

+ ),

+

+ // Do not parse bbcodes in code boxes

+ array(

+ 'Do not parse textual bbcodes in code',

+ '[code]unparsed code [b]bold [i]bold + italic[/i][/b][/code]',

+ '[code:]unparsed code &#91;b&#93;bold &#91;i&#93;bold + italic&#91;/i&#93;&#91;/b&#93;[/code:]',

+ ),

+ array(

+ 'Do not parse quote bbcodes in code',

+ '[code]unparsed code [quote=&quot;username&quot;]quoted[/quote][/code]',

+ '[code:]unparsed code &#91;quote=&quot;username&quot;&#93;quoted&#91;/quote&#93;[/code:]',

+ ),

+

+ // New user friendly mixed nesting

+ array(

+ 'Textual bbcode nesting into textual bbcode',

+ '[b]bold [i]bold + italic[/b] italic[/i]',

+ '[b:]bold [i:]bold + italic[/b:] italic[/i:]',

+ 'Incomplete test case: secondpass parses as [b:]bold [i:]bold + italic[/i:] italic[/b:]',

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider bbcode_firstpass_data

+ */

+ public function test_bbcode_firstpass($description, $message, $expected, $incomplete = false)

+ {

+ if ($incomplete)

+ {

+ $this->markTestIncomplete($incomplete);

+ }

+

+ global $user, $request;

+ $user = new phpbb_mock_user;

+ $request = new phpbb_mock_request;

+

+ $bbcode = new bbcode_firstpass();

+ $bbcode->message = $message;

+ $bbcode->bbcode_init(false);

+ $bbcode->parse_bbcode();

+ $this->assertEquals($expected, $bbcode->message);

+ }

+}

+ global $user, $request;

+ $request = new phpbb_mock_request;

+require_once $phpbb_root_path . 'includes/class_loader.' . $phpEx;

+

+$phpbb_class_loader_mock = new phpbb_class_loader('phpbb_mock_', $phpbb_root_path . '../tests/mock/', "php");

+$phpbb_class_loader_mock->register();

+$phpbb_class_loader_ext = new phpbb_class_loader('phpbb_ext_', $phpbb_root_path . 'ext/', "php");

+$phpbb_class_loader_ext->register();

+$phpbb_class_loader = new phpbb_class_loader('phpbb_', $phpbb_root_path . 'includes/', "php");

+$phpbb_class_loader->register();

+require_once 'test_framework/phpbb_functional_test_case.php';

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+// Important: apc.enable_cli=1 must be in php.ini.

+// http://forums.devshed.com/php-development-5/apc-problem-561290.html

+// http://php.net/manual/en/apc.configuration.php

+

+require_once dirname(__FILE__) . '/common_test_case.php';

+

+class phpbb_cache_apc_driver_test extends phpbb_cache_common_test_case

+{

+ protected static $config;

+ protected $driver;

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/config.xml');

+ }

+

+ static public function setUpBeforeClass()

+ {

+ if (!extension_loaded('apc'))

+ {

+ self::markTestSkipped('APC extension is not loaded');

+ }

+

+ $php_ini = new phpbb_php_ini;

+

+ if (!$php_ini->get_bool('apc.enabled'))

+ {

+ self::markTestSkipped('APC is not enabled. Make sure apc.enabled=1 in php.ini');

+ }

+

+ if (PHP_SAPI == 'cli' && !$php_ini->get_bool('apc.enable_cli'))

+ {

+ self::markTestSkipped('APC is not enabled for CLI. Set apc.enable_cli=1 in php.ini');

+ }

+ }

+

+ protected function setUp()

+ {

+ parent::setUp();

+

+ $this->driver = new phpbb_cache_driver_apc;

+ $this->driver->purge();

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+abstract class phpbb_cache_common_test_case extends phpbb_database_test_case

+{

+ public function test_get_put_exists()

+ {

+ $this->assertFalse($this->driver->_exists('test_key'));

+ $this->assertSame(false, $this->driver->get('test_key'));

+

+ $this->driver->put('test_key', 'test_value');

+

+ $this->assertTrue($this->driver->_exists('test_key'));

+ $this->assertEquals(

+ 'test_value',

+ $this->driver->get('test_key'),

+ 'File ACM put and get'

+ );

+ }

+

+ public function test_purge()

+ {

+ $this->driver->put('test_key', 'test_value');

+

+ $this->assertEquals(

+ 'test_value',

+ $this->driver->get('test_key'),

+ 'File ACM put and get'

+ );

+

+ $this->driver->purge();

+

+ $this->assertSame(false, $this->driver->get('test_key'));

+ }

+

+ public function test_destroy()

+ {

+ $this->driver->put('first_key', 'first_value');

+ $this->driver->put('second_key', 'second_value');

+

+ $this->assertEquals(

+ 'first_value',

+ $this->driver->get('first_key')

+ );

+ $this->assertEquals(

+ 'second_value',

+ $this->driver->get('second_key')

+ );

+

+ $this->driver->destroy('first_key');

+

+ $this->assertFalse($this->driver->_exists('first_key'));

+ $this->assertEquals(

+ 'second_value',

+ $this->driver->get('second_key')

+ );

+ }

+

+ public function test_cache_sql()

+ {

+ global $db, $cache, $phpbb_root_path, $phpEx;

+ $config = new phpbb_config(array());

+ $db = $this->new_dbal();

+ $cache = new phpbb_cache_service($this->driver, $config, $db, $phpbb_root_path, $phpEx);

+

+ $sql = "SELECT * FROM phpbb_config

+ WHERE config_name = 'foo'";

+

+ $result = $db->sql_query($sql, 300);

+ $first_result = $db->sql_fetchrow($result);

+ $expected = array('config_name' => 'foo', 'config_value' => '23', 'is_dynamic' => 0);

+ $this->assertEquals($expected, $first_result);

+

+ $sql = 'DELETE FROM phpbb_config';

+ $result = $db->sql_query($sql);

+

+ $sql = "SELECT * FROM phpbb_config

+ WHERE config_name = 'foo'";

+ $result = $db->sql_query($sql, 300);

+

+ $this->assertEquals($expected, $db->sql_fetchrow($result));

+

+ $sql = "SELECT * FROM phpbb_config

+ WHERE config_name = 'foo'";

+ $result = $db->sql_query($sql);

+

+ $no_cache_result = $db->sql_fetchrow($result);

+ $this->assertSame(false, $no_cache_result);

+

+ $db->sql_close();

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__) . '/common_test_case.php';

+

+class phpbb_cache_file_driver_test extends phpbb_cache_common_test_case

+{

+ private $cache_dir;

+ protected $driver;

+

+ public function __construct()

+ {

+ $this->cache_dir = dirname(__FILE__) . '/../tmp/cache/';

+ }

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/config.xml');

+ }

+

+ protected function setUp()

+ {

+ parent::setUp();

+

+ if (file_exists($this->cache_dir))

+ {

+ // cache directory possibly left after aborted

+ // or failed run earlier

+ $this->remove_cache_dir();

+ }

+ $this->create_cache_dir();

+

+ $this->driver = new phpbb_cache_driver_file($this->cache_dir);

+ }

+

+ protected function tearDown()

+ {

+ if (file_exists($this->cache_dir))

+ {

+ $this->remove_cache_dir();

+ }

+

+ parent::tearDown();

+ }

+

+ private function create_cache_dir()

+ {

+ $this->get_test_case_helpers()->makedirs($this->cache_dir);

+ }

+

+ private function remove_cache_dir()

+ {

+ $iterator = new DirectoryIterator($this->cache_dir);

+ foreach ($iterator as $file)

+ {

+ if ($file != '.' && $file != '..')

+ {

+ unlink($this->cache_dir . '/' . $file);

+ }

+ }

+ rmdir($this->cache_dir);

+ }

+}

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_config">

+ <column>config_name</column>

+ <column>config_value</column>

+ <column>is_dynamic</column>

+ <row>

+ <value>foo</value>

+ <value>23</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>bar</value>

+ <value>42</value>

+ <value>1</value>

+ </row>

+ </table>

+</dataset>

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_cache_null_driver_test extends phpbb_database_test_case

+{

+ protected $driver;

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/config.xml');

+ }

+

+ protected function setUp()

+ {

+ parent::setUp();

+

+ $this->driver = new phpbb_cache_driver_null;

+ }

+

+ public function test_get_put()

+ {

+ $this->assertSame(false, $this->driver->get('key'));

+

+ $this->driver->put('key', 'value');

+

+ // null driver does not cache

+ $this->assertSame(false, $this->driver->get('key'));

+ }

+

+ public function test_purge()

+ {

+ // does nothing

+ $this->driver->purge();

+ }

+

+ public function test_destroy()

+ {

+ // does nothing

+ $this->driver->destroy('foo');

+ }

+

+ public function test_cache_sql()

+ {

+ global $db, $cache, $phpbb_root_path, $phpEx;

+ $config = new phpbb_config(array());

+ $db = $this->new_dbal();

+ $cache = new phpbb_cache_service($this->driver, $config, $db, $phpbb_root_path, $phpEx);

+

+ $sql = "SELECT * FROM phpbb_config

+ WHERE config_name = 'foo'";

+ $result = $db->sql_query($sql, 300);

+ $first_result = $db->sql_fetchrow($result);

+ $expected = array('config_name' => 'foo', 'config_value' => '23', 'is_dynamic' => 0);

+ $this->assertEquals($expected, $first_result);

+

+ $sql = 'DELETE FROM phpbb_config';

+ $result = $db->sql_query($sql);

+

+ // As null cache driver does not actually cache,

+ // this should return no results

+ $sql = "SELECT * FROM phpbb_config

+ WHERE config_name = 'foo'";

+ $result = $db->sql_query($sql, 300);

+

+ $this->assertSame(false, $db->sql_fetchrow($result));

+

+ $db->sql_close();

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__) . '/common_test_case.php';

+

+class phpbb_cache_redis_driver_test extends phpbb_cache_common_test_case

+{

+ protected static $config;

+ protected $driver;

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/config.xml');

+ }

+

+ static public function setUpBeforeClass()

+ {

+ if (!extension_loaded('redis'))

+ {

+ self::markTestSkipped('redis extension is not loaded');

+ }

+

+ $config = phpbb_test_case_helpers::get_test_config();

+ if (isset($config['redis_host']) || isset($config['redis_port']))

+ {

+ $host = isset($config['redis_host']) ? $config['redis_host'] : 'localhost';

+ $port = isset($config['redis_port']) ? $config['redis_port'] : 6379;

+ self::$config = array('host' => $host, 'port' => $port);

+ }

+ else

+ {

+ self::markTestSkipped('Test redis host/port is not specified');

+ }

+ }

+

+ protected function setUp()

+ {

+ parent::setUp();

+

+ $this->driver = new phpbb_cache_driver_redis(self::$config['host'], self::$config['port']);

+ $this->driver->purge();

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_class_loader_test extends PHPUnit_Framework_TestCase

+{

+ public function setUp()

+ {

+ global $phpbb_class_loader;

+ $phpbb_class_loader->unregister();

+

+ global $phpbb_class_loader_ext;

+ $phpbb_class_loader_ext->unregister();

+ }

+

+ public function tearDown()

+ {

+ global $phpbb_class_loader_ext;

+ $phpbb_class_loader_ext->register();

+

+ global $phpbb_class_loader;

+ $phpbb_class_loader->register();

+ }

+

+ public function test_resolve_path()

+ {

+ $prefix = dirname(__FILE__) . '/';

+ $class_loader = new phpbb_class_loader('phpbb_', $prefix . 'includes/');

+

+ $prefix .= 'includes/';

+

+ $this->assertEquals(

+ '',

+ $class_loader->resolve_path('phpbb_dir'),

+ 'Class with same name as a directory is unloadable'

+ );

+

+ $this->assertEquals(

+ $prefix . 'class_name.php',

+ $class_loader->resolve_path('phpbb_class_name'),

+ 'Top level class'

+ );

+ $this->assertEquals(

+ $prefix . 'dir/class_name.php',

+ $class_loader->resolve_path('phpbb_dir_class_name'),

+ 'Class in a directory'

+ );

+ $this->assertEquals(

+ $prefix . 'dir/subdir/class_name.php',

+ $class_loader->resolve_path('phpbb_dir_subdir_class_name'),

+ 'Class in a sub-directory'

+ );

+ $this->assertEquals(

+ $prefix . 'dir2/dir2.php',

+ $class_loader->resolve_path('phpbb_dir2'),

+ 'Class with name of dir within dir (short class name)'

+ );

+ }

+

+ public function test_resolve_cached()

+ {

+ $cache_map = array(

+ 'class_loader_phpbb_' => array('phpbb_a_cached_name' => 'a/cached_name'),

+ 'class_loader_phpbb_ext_' => array('phpbb_ext_foo' => 'foo'),

+ );

+ $cache = new phpbb_mock_cache($cache_map);

+

+ $prefix = dirname(__FILE__) . '/';

+ $class_loader = new phpbb_class_loader('phpbb_', $prefix . 'includes/', 'php', $cache);

+ $class_loader_ext = new phpbb_class_loader('phpbb_ext_', $prefix . 'includes/', 'php', $cache);

+

+ $prefix .= 'includes/';

+

+ $this->assertEquals(

+ $prefix . 'dir/class_name.php',

+ $class_loader->resolve_path('phpbb_dir_class_name'),

+ 'Class in a directory'

+ );

+

+ $this->assertFalse($class_loader->resolve_path('phpbb_ext_foo'));

+ $this->assertFalse($class_loader_ext->resolve_path('phpbb_a_cached_name'));

+

+ $this->assertEquals(

+ $prefix . 'a/cached_name.php',

+ $class_loader->resolve_path('phpbb_a_cached_name'),

+ 'Cached class found'

+ );

+

+ $this->assertEquals(

+ $prefix . 'foo.php',

+ $class_loader_ext->resolve_path('phpbb_ext_foo'),

+ 'Cached class found in alternative loader'

+ );

+

+ $cache_map['class_loader_phpbb_']['phpbb_dir_class_name'] = 'dir/class_name';

+ $cache->check($this, $cache_map);

+ }

+}

+<?php

+

+class phpbb_class_name

+{

+}

+

+<?php

+

+class phpbb_dir

+{

+}

+

+<?php

+

+class phpbb_dir_class_name

+{

+}

+

+<?php

+

+class phpbb_dir_subdir_class_name

+{

+}

+

+<?php

+

+class phpbb_dir2

+{

+}

+

+ protected $conflicts = array(

+ '1_1.txt',

+ '1_2.txt',

+ 'dir/2_1.txt',

+ );

+

+

+ // Add multiples of the same file to check conflicts are handled

+ $compress->add_file($this->path . '1.txt', $this->path);

+ $compress->add_file($this->path . '1.txt', $this->path);

+ $compress->add_file($this->path . 'dir/2.txt', $this->path);

+ $this->valid_extraction($this->conflicts);

+ $this->valid_extraction($this->conflicts);

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_config_test extends phpbb_test_case

+{

+ public function test_offset_exists()

+ {

+ $config = new phpbb_config(array('foo' => 'bar'));

+

+ $this->assertTrue(isset($config['foo']));

+ $this->assertFalse(isset($config['foobar']));

+ }

+

+ public function test_offset_get()

+ {

+ $config = new phpbb_config(array('foo' => 'bar'));

+ $this->assertEquals('bar', $config['foo']);

+ }

+

+ public function test_offset_get_missing()

+ {

+ $config = new phpbb_config(array());

+ $this->assertEquals('', $config['foo']);

+ }

+

+ public function test_offset_set()

+ {

+ $config = new phpbb_config(array());

+ $config['foo'] = 'x';

+ $this->assertEquals('x', $config['foo']);

+ }

+

+ public function test_offset_unset_fails()

+ {

+ $this->setExpectedTriggerError(E_USER_ERROR);

+ $config = new phpbb_config(array('foo' => 'x'));

+ unset($config['foo']);

+ }

+

+ public function test_count()

+ {

+ $config = new phpbb_config(array('foo' => 'bar'));

+ $this->assertEquals(1, count($config));

+ }

+

+ public function test_iterate()

+ {

+ $vars = array('foo' => '23', 'bar' => '42');

+ $config = new phpbb_config($vars);

+

+ $count = 0;

+ foreach ($config as $key => $value)

+ {

+ $this->assertTrue(isset($vars[$key]));

+ $this->assertEquals($vars[$key], $value);

+

+ $count++;

+ }

+

+ $this->assertEquals(count($vars), $count);

+ }

+

+ public function test_set_overwrite()

+ {

+ $config = new phpbb_config(array('foo' => 'x'));

+ $config->set('foo', 'bar');

+ $this->assertEquals('bar', $config['foo']);

+ }

+

+ public function test_set_new()

+ {

+ $config = new phpbb_config(array());

+ $config->set('foo', 'bar');

+ $this->assertEquals('bar', $config['foo']);

+ }

+

+ public function test_set_atomic_overwrite()

+ {

+ $config = new phpbb_config(array('foo' => 'bar'));

+ $this->assertTrue($config->set_atomic('foo', 'bar', '23'));

+ $this->assertEquals('23', $config['foo']);

+ }

+

+ public function test_set_atomic_new()

+ {

+ $config = new phpbb_config(array());

+ $this->assertTrue($config->set_atomic('foo', false, '23'));

+ $this->assertEquals('23', $config['foo']);

+ }

+

+ public function test_set_atomic_failure()

+ {

+ $config = new phpbb_config(array('foo' => 'bar'));

+ $this->assertFalse($config->set_atomic('foo', 'wrong', '23'));

+ $this->assertEquals('bar', $config['foo']);

+ }

+

+ public function test_increment()

+ {

+ $config = new phpbb_config(array('foo' => '23'));

+ $config->increment('foo', 3);

+ $this->assertEquals(26, $config['foo']);

+ $config->increment('foo', 1);

+ $this->assertEquals(27, $config['foo']);

+ }

+

+ public function test_delete()

+ {

+ $config = new phpbb_config(array('foo' => 'bar'));

+

+ $config->delete('foo');

+ $this->assertFalse(isset($config['foo']));

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_config_db_test extends phpbb_database_test_case

+{

+ private $cache;

+ private $db;

+ private $config;

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/config.xml');

+ }

+

+ public function setUp()

+ {

+ parent::setUp();

+

+ $this->cache = new phpbb_mock_cache;

+ $this->db = $this->new_dbal();

+ $this->config = new phpbb_config_db($this->db, $this->cache, 'phpbb_config');

+ }

+

+ public function test_load_config()

+ {

+ $this->assertEquals('23', $this->config['foo']);

+ $this->assertEquals('42', $this->config['bar']);

+ }

+

+ public function test_load_cached()

+ {

+ $cache = new phpbb_mock_cache(array('config' => array('x' => 'y')));

+ $this->config = new phpbb_config_db($this->db, $cache, 'phpbb_config');

+

+ $this->assertTrue(!isset($this->config['foo']));

+ $this->assertEquals('42', $this->config['bar']);

+

+ $this->assertEquals('y', $this->config['x']);

+ }

+

+ public function test_offset_set()

+ {

+ $this->config['foo'] = 'x'; // temporary set

+ $this->assertEquals('x', $this->config['foo']);

+

+ $config2 = new phpbb_config_db($this->db, $this->cache, 'phpbb_config');

+ $this->assertEquals('23', $config2['foo']);

+ }

+

+ public function test_set_overwrite()

+ {

+ $this->config->set('foo', '17');

+ $this->assertEquals('17', $this->config['foo']);

+

+ // re-read config and populate cache

+ $config2 = new phpbb_config_db($this->db, $this->cache, 'phpbb_config');

+ $this->cache->checkVar($this, 'config', array('foo' => '17'));

+ }

+

+ public function test_set_overwrite_uncached()

+ {

+ $this->config->set('bar', '17', false);

+

+ // re-read config and populate cache

+ $config2 = new phpbb_config_db($this->db, $this->cache, 'phpbb_config');

+ $this->cache->checkVar($this, 'config', array('foo' => '23'));

+ }

+

+ public function test_set_new()

+ {

+ $this->config->set('foobar', '5');

+ $this->assertEquals('5', $this->config['foobar']);

+

+ // re-read config and populate cache

+ $config2 = new phpbb_config_db($this->db, $this->cache, 'phpbb_config');

+ $this->cache->checkVar($this, 'config', array('foo' => '23', 'foobar' => '5'));

+ }

+

+ public function test_set_new_uncached()

+ {

+ $this->config->set('foobar', '5', false);

+ $this->assertEquals('5', $this->config['foobar']);

+

+ // re-read config and populate cache

+ $config2 = new phpbb_config_db($this->db, $this->cache, 'phpbb_config');

+ $this->cache->checkVar($this, 'config', array('foo' => '23'));

+ }

+

+ public function test_set_atomic_overwrite()

+ {

+ $this->assertTrue($this->config->set_atomic('foo', '23', '17'));

+ $this->assertEquals('17', $this->config['foo']);

+ }

+

+ public function test_set_atomic_new()

+ {

+ $this->assertTrue($this->config->set_atomic('foobar', false, '5'));

+ $this->assertEquals('5', $this->config['foobar']);

+ }

+

+ public function test_set_atomic_failure()

+ {

+ $this->assertFalse($this->config->set_atomic('foo', 'wrong', '17'));

+ $this->assertEquals('23', $this->config['foo']);

+ }

+

+ public function test_increment()

+ {

+ $this->config->increment('foo', 3);

+ $this->assertEquals(26, $this->config['foo']);

+ $this->config->increment('foo', 1);

+ $this->assertEquals(27, $this->config['foo']);

+ }

+

+ public function test_increment_new()

+ {

+ $this->config->increment('foobar', 3);

+ $this->assertEquals(3, $this->config['foobar']);;

+ }

+

+ public function test_delete()

+ {

+ $this->assertTrue(isset($this->config['foo']));

+ $this->config->delete('foo');

+ $this->cache->checkVarUnset($this, 'foo');

+ $this->assertFalse(isset($this->config['foo']));

+

+ // re-read config and populate cache

+ $cache2 = new phpbb_mock_cache;

+ $config2 = new phpbb_config_db($this->db, $cache2, 'phpbb_config');

+ $cache2->checkVarUnset($this, 'foo');

+ $this->assertFalse(isset($config2['foo']));

+ }

+

+ public function test_delete_write_read_not_cacheable()

+ {

+ // bar is dynamic

+ $this->assertTrue(isset($this->config['bar']));

+ $this->config->delete('bar');

+ $this->cache->checkVarUnset($this, 'bar');

+ $this->assertFalse(isset($this->config['bar']));

+

+ $this->config->set('bar', 'new bar', false);

+ $this->assertEquals('new bar', $this->config['bar']);

+ }

+

+ public function test_delete_write_read_cacheable()

+ {

+ // foo is not dynamic

+ $this->assertTrue(isset($this->config['foo']));

+ $this->config->delete('foo');

+ $this->cache->checkVarUnset($this, 'foo');

+ $this->assertFalse(isset($this->config['foo']));

+

+ $this->config->set('foo', 'new foo', true);

+ $this->assertEquals('new foo', $this->config['foo']);

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_config_db_text_test extends phpbb_database_test_case

+{

+ private $db;

+ private $config_text;

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/config_text.xml');

+ }

+

+ public function setUp()

+ {

+ parent::setUp();

+

+ $this->db = $this->new_dbal();

+ $this->config_text = new phpbb_config_db_text($this->db, 'phpbb_config_text');

+ }

+

+ public function test_get()

+ {

+ $this->assertSame('23', $this->config_text->get('foo'));

+ $this->assertSame('string-de-ding', $this->config_text->get('meh'));

+ }

+

+ public function test_get_nonexisting()

+ {

+ $this->assertNull($this->config_text->get('noooooo'));

+ }

+

+ public function test_set_new_get()

+ {

+ $this->config_text->set('barz', 'phpbb');

+ $this->assertSame('phpbb', $this->config_text->get('barz'));

+ }

+

+ public function test_set_replace_get()

+ {

+ $this->config_text->set('foo', '24');

+ $this->assertSame('24', $this->config_text->get('foo'));

+ }

+

+ public function test_set_get_long_string()

+ {

+ $expected = str_repeat('ABC', 10000);

+ $this->config_text->set('long', $expected);

+ $this->assertSame($expected, $this->config_text->get('long'));

+ }

+

+ public function test_delete_get()

+ {

+ $this->config_text->delete('foo');

+ $this->assertNull($this->config_text->get('foo'));

+

+ $this->assertSame('42', $this->config_text->get('bar'));

+ $this->assertSame('string-de-ding', $this->config_text->get('meh'));

+ }

+

+ public function test_get_array_empty()

+ {

+ $this->assertEmpty($this->config_text->get_array(array('key1', 'key2')));

+ }

+

+ public function test_get_array_subset()

+ {

+ $expected = array(

+ 'bar' => '42',

+ 'foo' => '23',

+ );

+

+ $actual = $this->config_text->get_array(array_keys($expected));

+ ksort($actual);

+

+ $this->assertSame($expected, $actual);

+ }

+

+ public function test_set_array_get_array_subset()

+ {

+ $set_array_param = array(

+ // New entry

+ 'baby' => 'phpBB',

+ // Entry update

+ 'bar' => '64',

+ );

+

+ $this->config_text->set_array($set_array_param);

+

+ $expected = array_merge($set_array_param, array(

+ 'foo' => '23',

+ ));

+

+ $actual = $this->config_text->get_array(array_keys($expected));

+ ksort($actual);

+

+ $this->assertSame($expected, $actual);

+ }

+

+ public function test_delete_array_get_remaining()

+ {

+ $this->config_text->delete_array(array('foo', 'bar'));

+

+ $this->assertNull($this->config_text->get('bar'));

+ $this->assertNull($this->config_text->get('foo'));

+

+ $this->assertSame('string-de-ding', $this->config_text->get('meh'));

+ }

+}

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_config">

+ <column>config_name</column>

+ <column>config_value</column>

+ <column>is_dynamic</column>

+ <row>

+ <value>foo</value>

+ <value>23</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>bar</value>

+ <value>42</value>

+ <value>1</value>

+ </row>

+ </table>

+</dataset>

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_config_text">

+ <column>config_name</column>

+ <column>config_value</column>

+ <row>

+ <value>foo</value>

+ <value>23</value>

+ </row>

+ <row>

+ <value>bar</value>

+ <value>42</value>

+ </row>

+ <row>

+ <value>meh</value>

+ <value>string-de-ding</value>

+ </row>

+ </table>

+</dataset>

+core_controller:

+ pattern: /core_foo

+ defaults: { _controller: core_foo.controller:bar }

+services:

+ core_foo.controller:

+ class: phpbb_controller_foo

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+use Symfony\Component\HttpFoundation\Request;

+use Symfony\Component\Routing\Route;

+use Symfony\Component\Routing\RouteCollection;

+use Symfony\Component\Config\FileLocator;

+use Symfony\Component\DependencyInjection\ContainerBuilder;

+use Symfony\Component\DependencyInjection\Loader\YamlFileLoader;

+

+class phpbb_controller_controller_test extends phpbb_test_case

+{

+ public function setUp()

+ {

+ $this->extension_manager = new phpbb_mock_extension_manager(

+ dirname(__FILE__) . '/',

+ array(

+ 'foo' => array(

+ 'ext_name' => 'foo',

+ 'ext_active' => '1',

+ 'ext_path' => 'ext/foo/',

+ ),

+ ));

+ }

+

+ public function test_provider()

+ {

+ $provider = new phpbb_controller_provider;

+ $routes = $provider

+ ->import_paths_from_finder($this->extension_manager->get_finder())

+ ->find('./tests/controller/');

+

+ // This will need to be updated if any new routes are defined

+ $this->assertEquals(2, sizeof($routes));

+ }

+

+ public function test_controller_resolver()

+ {

+ $container = new ContainerBuilder();

+ // YamlFileLoader only uses one path at a time, so we need to loop

+ // through all of the ones we are using.

+ foreach (array(__DIR__.'/config', __DIR__.'/ext/foo/config') as $path)

+ {

+ $loader = new YamlFileLoader($container, new FileLocator($path));

+ $loader->load('services.yml');

+ }

+

+ // Autoloading classes within the tests folder does not work

+ // so I'll include them manually.

+ if (!class_exists('phpbb_ext_foo_controller'))

+ {

+ include(__DIR__.'/ext/foo/controller.php');

+ }

+ if (!class_exists('phpbb_controller_foo'))

+ {

+ include(__DIR__.'/includes/controller/foo.php');

+ }

+

+ $resolver = new phpbb_controller_resolver(new phpbb_user, $container);

+ $symfony_request = new Request();

+ $symfony_request->attributes->set('_controller', 'foo.controller:handle');

+

+ $this->assertEquals($resolver->getController($symfony_request), array(new phpbb_ext_foo_controller, 'handle'));

+

+ $symfony_request = new Request();

+ $symfony_request->attributes->set('_controller', 'core_foo.controller:bar');

+

+ $this->assertEquals($resolver->getController($symfony_request), array(new phpbb_controller_foo, 'bar'));

+ }

+}

+controller1:

+ pattern: /foo

+ defaults: { _controller: foo.controller:handle }

+services:

+ foo.controller:

+ class: phpbb_ext_foo_controller

+<?php

+

+use Symfony\Component\HttpFoundation\Response;

+

+class phpbb_ext_foo_controller

+{

+ /**

+ * Handle method

+ *

+ * @return null

+ */

+ public function handle()

+ {

+ return new Response('Test', 200);

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+

+class phpbb_controller_helper_url_test extends phpbb_test_case

+{

+

+ public function helper_url_data()

+ {

+ return array(

+ array('foo/bar?t=1&amp;f=2', false, true, false, 'app.php?t=1&amp;f=2&amp;controller=foo/bar', 'parameters in url-argument'),

+ array('foo/bar', 't=1&amp;f=2', true, false, 'app.php?controller=foo/bar&amp;t=1&amp;f=2', 'parameters in params-argument using amp'),

+ array('foo/bar', 't=1&f=2', false, false, 'app.php?controller=foo/bar&t=1&f=2', 'parameters in params-argument using &'),

+ array('foo/bar', array('t' => 1, 'f' => 2), true, false, 'app.php?controller=foo/bar&amp;t=1&amp;f=2', 'parameters in params-argument as array'),

+

+ // Custom sid parameter

+ array('foo/bar', 't=1&amp;f=2', true, 'custom-sid', 'app.php?controller=foo/bar&amp;t=1&amp;f=2&amp;sid=custom-sid', 'using session_id'),

+

+ // Testing anchors

+ array('foo/bar?t=1&amp;f=2#anchor', false, true, false, 'app.php?t=1&amp;f=2&amp;controller=foo/bar#anchor', 'anchor in url-argument'),

+ array('foo/bar', 't=1&amp;f=2#anchor', true, false, 'app.php?controller=foo/bar&amp;t=1&amp;f=2#anchor', 'anchor in params-argument'),

+ array('foo/bar', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, false, 'app.php?controller=foo/bar&amp;t=1&amp;f=2#anchor', 'anchor in params-argument (array)'),

+

+ // Anchors and custom sid

+ array('foo/bar?t=1&amp;f=2#anchor', false, true, 'custom-sid', 'app.php?t=1&amp;f=2&amp;controller=foo/bar&amp;sid=custom-sid#anchor', 'anchor in url-argument using session_id'),

+ array('foo/bar', 't=1&amp;f=2#anchor', true, 'custom-sid', 'app.php?controller=foo/bar&amp;t=1&amp;f=2&amp;sid=custom-sid#anchor', 'anchor in params-argument using session_id'),

+ array('foo/bar', array('t' => 1, 'f' => 2, '#' => 'anchor'), true, 'custom-sid', 'app.php?controller=foo/bar&amp;t=1&amp;f=2&amp;sid=custom-sid#anchor', 'anchor in params-argument (array) using session_id'),

+

+ // Empty parameters should not append the &amp;

+ array('foo/bar', false, true, false, 'app.php?controller=foo/bar', 'no params using bool false'),

+ array('foo/bar', '', true, false, 'app.php?controller=foo/bar', 'no params using empty string'),

+ array('foo/bar', array(), true, false, 'app.php?controller=foo/bar', 'no params using empty array'),

+ );

+ }

+

+ /**

+ * @dataProvider helper_url_data

+ */

+ public function test_helper_url($route, $params, $is_amp, $session_id, $expected, $description)

+ {

+ global $phpbb_dispatcher, $phpbb_root_path, $phpEx;

+

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher;

+ $this->style_resource_locator = new phpbb_style_resource_locator();

+ $this->user = $this->getMock('phpbb_user');

+ $this->template = new phpbb_template_twig($phpbb_root_path, $phpEx, $config, $this->user, new phpbb_template_context());

+ $this->style_resource_locator = new phpbb_style_resource_locator();

+ $this->style_provider = new phpbb_style_path_provider();

+ $this->style = new phpbb_style($phpbb_root_path, $phpEx, new phpbb_config(array()), $this->user, $this->style_resource_locator, $this->style_provider, $this->template);

+

+ $helper = new phpbb_controller_helper($this->template, $this->user, '', 'php');

+ $this->assertEquals($helper->url($route, $params, $is_amp, $session_id), $expected);

+ }

+}

+<?php

+

+use Symfony\Component\HttpFoundation\Response;

+

+class phpbb_controller_foo

+{

+ /**

+ * Bar method

+ *

+ * @return null

+ */

+ public function bar()

+ {

+ return new Response('bar()', 200);

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_ext_testext_cron_dummy_task extends phpbb_cron_task_base

+{

+ static public $was_run = 0;

+

+ public function get_name()

+ {

+ return get_class($this);

+ }

+

+ public function run()

+ {

+ self::$was_run++;

+ }

+

+ public function should_run()

+ {

+ return true;

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_cron_task_core_dummy_task extends phpbb_cron_task_base

+{

+ static public $was_run = 0;

+

+ public function get_name()

+ {

+ return get_class($this);

+ }

+

+ public function run()

+ {

+ self::$was_run++;

+ }

+

+ public function should_run()

+ {

+ return true;

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_cron_task_core_second_dummy_task extends phpbb_cron_task_base

+{

+ static public $was_run = 0;

+

+ public function get_name()

+ {

+ return get_class($this);

+ }

+

+ public function run()

+ {

+ self::$was_run++;

+ }

+

+ public function should_run()

+ {

+ return true;

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2010 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__) . '/includes/cron/task/core/dummy_task.php';

+require_once dirname(__FILE__) . '/includes/cron/task/core/second_dummy_task.php';

+require_once dirname(__FILE__) . '/ext/testext/cron/dummy_task.php';

+require_once dirname(__FILE__) . '/tasks/simple_ready.php';

+require_once dirname(__FILE__) . '/tasks/simple_not_runnable.php';

+require_once dirname(__FILE__) . '/tasks/simple_should_not_run.php';

+

+class phpbb_cron_manager_test extends PHPUnit_Framework_TestCase

+{

+ public function setUp()

+ {

+ $this->manager = $this->create_cron_manager(array(

+ new phpbb_cron_task_core_dummy_task(),

+ new phpbb_cron_task_core_second_dummy_task(),

+ new phpbb_ext_testext_cron_dummy_task(),

+ ));

+ $this->task_name = 'phpbb_cron_task_core_dummy_task';

+ }

+

+ public function test_manager_finds_shipped_task_by_name()

+ {

+ $task = $this->manager->find_task($this->task_name);

+ $this->assertInstanceOf('phpbb_cron_task_wrapper', $task);

+ $this->assertEquals($this->task_name, $task->get_name());

+ }

+

+ public function test_manager_finds_all_ready_tasks()

+ {

+ $tasks = $this->manager->find_all_ready_tasks();

+ $this->assertEquals(3, sizeof($tasks));

+ }

+

+ public function test_manager_finds_one_ready_task()

+ {

+ $task = $this->manager->find_one_ready_task();

+ $this->assertInstanceOf('phpbb_cron_task_wrapper', $task);

+ }

+

+ public function test_manager_finds_only_ready_tasks()

+ {

+ $manager = $this->create_cron_manager(array(

+ new phpbb_cron_task_core_simple_ready(),

+ new phpbb_cron_task_core_simple_not_runnable(),

+ new phpbb_cron_task_core_simple_should_not_run(),

+ ));

+ $tasks = $manager->find_all_ready_tasks();

+ $task_names = $this->tasks_to_names($tasks);

+ $this->assertEquals(array('phpbb_cron_task_core_simple_ready'), $task_names);

+ }

+

+ private function tasks_to_names($tasks)

+ {

+ $names = array();

+ foreach ($tasks as $task)

+ {

+ $names[] = $task->get_name();

+ }

+ return $names;

+ }

+

+ private function create_cron_manager($tasks)

+ {

+ global $phpbb_root_path, $phpEx;

+

+ return new phpbb_cron_manager($tasks, $phpbb_root_path, $phpEx);

+ }

+}

+<?php

+

+class phpbb_cron_task_core_simple_not_runnable extends phpbb_cron_task_base

+{

+ public function get_name()

+ {

+ return get_class($this);

+ }

+

+ public function run()

+ {

+ }

+

+ public function is_runnable()

+ {

+ return false;

+ }

+}

+<?php

+

+class phpbb_cron_task_core_simple_ready extends phpbb_cron_task_base

+{

+ public function get_name()

+ {

+ return get_class($this);

+ }

+

+ public function run()

+ {

+ }

+}

+<?php

+

+class phpbb_cron_task_core_simple_should_not_run extends phpbb_cron_task_base

+{

+ public function get_name()

+ {

+ return get_class($this);

+ }

+

+ public function run()

+ {

+ }

+

+ public function should_run()

+ {

+ return false;

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/session.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/user.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/datetime.php';

+require_once dirname(__FILE__) . '/../mock/lang.php';

+

+class phpbb_datetime_from_format_test extends phpbb_test_case

+{

+ public function from_format_data()

+ {

+ return array(

+ array(

+ 'UTC',

+ 'Y-m-d',

+ '2012-06-08',

+ ),

+

+ array(

+ 'Europe/Berlin',

+ 'Y-m-d H:i:s',

+ '2012-06-08 14:01:02',

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider from_format_data()

+ */

+ public function test_from_format($timezone, $format, $expected)

+ {

+ global $user;

+

+ $user = new phpbb_user();

+ $user->timezone = new DateTimeZone($timezone);

+ $user->lang['datetime'] = array(

+ 'TODAY' => 'Today',

+ 'TOMORROW' => 'Tomorrow',

+ 'YESTERDAY' => 'Yesterday',

+ 'AGO' => array(

+ 0 => 'less than a minute ago',

+ 1 => '%d minute ago',

+ 2 => '%d minutes ago',

+ ),

+ );

+

+ $timestamp = $user->get_timestamp_from_format($format, $expected, new DateTimeZone($timezone));

+ $this->assertEquals($expected, $user->format_date($timestamp, $format, true));

+ }

+}

+<?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_int()

+ {

+ $db = $this->new_dbal();

+

+ $sql = 'SELECT ' . $db->sql_case('1 = 1', '1', '2') . ' AS test_num

+ FROM phpbb_config';

+ $result = $db->sql_query_limit($sql, 1);

+

+ $this->assertEquals(1, (int) $db->sql_fetchfield('test_num'));

+

+ $sql = 'SELECT ' . $db->sql_case('1 = 0', '1', '2') . ' AS test_num

+ FROM phpbb_config';

+ $result = $db->sql_query_limit($sql, 1);

+

+ $this->assertEquals(2, (int) $db->sql_fetchfield('test_num'));

+ }

+

+ public function test_case_string()

+ {

+ $db = $this->new_dbal();

+

+ $sql = 'SELECT ' . $db->sql_case('1 = 1', "'foo'", "'bar'") . ' AS test_string

+ FROM phpbb_config';

+ $result = $db->sql_query_limit($sql, 1);

+

+ $this->assertEquals('foo', $db->sql_fetchfield('test_string'));

+

+ $sql = 'SELECT ' . $db->sql_case('1 = 0', "'foo'", "'bar'") . ' AS test_string

+ FROM phpbb_config';

+ $result = $db->sql_query_limit($sql, 1);

+

+ $this->assertEquals('bar', $db->sql_fetchfield('test_string'));

+ }

+

+ public function test_case_column()

+ {

+ $db = $this->new_dbal();

+

+ $sql = 'SELECT ' . $db->sql_case("config_name = 'config1'", 'config_name', 'config_value') . " AS test_string

+ FROM phpbb_config

+ WHERE config_name = 'config1'";

+ $result = $db->sql_query_limit($sql, 1);

+

+ $this->assertEquals('config1', $db->sql_fetchfield('test_string'));

+

+ $sql = 'SELECT ' . $db->sql_case("config_name = 'config1'", 'config_name', 'config_value') . " AS test_string

+ FROM phpbb_config

+ WHERE config_value = 'bar'";

+ $result = $db->sql_query_limit($sql, 1);

+

+ $this->assertEquals('bar', $db->sql_fetchfield('test_string'));

+ }

+}

+<?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)

+ );

+ }

+}

+ $db = new $config['dbms']();

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_migrations">

+ <column>migration_name</column>

+ <column>migration_depends_on</column>

+ <column>migration_schema_done</column>

+ <column>migration_data_done</column>

+ <column>migration_data_state</column>

+ <column>migration_start_time</column>

+ <column>migration_end_time</column>

+ <row>

+ <value>installed_migration</value>

+ <value></value>

+ <value>1</value>

+ <value>1</value>

+ <value></value>

+ <value>1234</value>

+ <value>5678</value>

+ </row>

+ </table>

+ <table name="phpbb_config">

+ <column>config_name</column>

+ <column>config_value</column>

+ <row>

+ <value>foo</value>

+ <value>bar</value>

+ </row>

+ </table>

+</dataset>

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_modules">

+ <column>module_id</column>

+ <column>module_enabled</column>

+ <column>module_display</column>

+ <column>module_basename</column>

+ <column>module_class</column>

+ <column>parent_id</column>

+ <column>left_id</column>

+ <column>right_id</column>

+ <column>module_langname</column>

+ <column>module_mode</column>

+ <column>module_auth</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value></value>

+ <value>acp</value>

+ <value>0</value>

+ <value>1</value>

+ <value>4</value>

+ <value>ACP_CAT</value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>1</value>

+ <value>1</value>

+ <value>acp_test</value>

+ <value>acp</value>

+ <value>1</value>

+ <value>2</value>

+ <value>3</value>

+ <value>ACP_MODULE</value>

+ <value>test</value>

+ <value></value>

+ </row>

+ </table>

+</dataset>

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_acl_options">

+ <column>auth_option_id</column>

+ <column>auth_option</column>

+ <column>is_global</column>

+ <column>is_local</column>

+ <column>founder_only</column>

+ <row>

+ <value>1</value>

+ <value>global</value>

+ <value>1</value>

+ <value>0</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>local</value>

+ <value>0</value>

+ <value>1</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>both</value>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ </row>

+ </table>

+</dataset>

+ <column>style_path</column>

+ <column>bbcode_bitfield</column>

+ <column>style_parent_id</column>

+ <column>style_parent_tree</column>

+ <value>prosilver</value>

+ <value>kNg=</value>

+ <value>0</value>

+ <value></value>

+ <value>prosilver2</value>

+ <value>kNg=</value>

+ <value>0</value>

+ <value></value>

+ <value>prosilver1</value>

+ <value>kNg=</value>

+ <value>1</value>

+ <value>prosilver</value>

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+class phpbb_dbal_migration_dummy extends phpbb_db_migration

+{

+ static public function depends_on()

+ {

+ return array('installed_migration');

+ }

+

+ function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ 'phpbb_config' => array(

+ 'extra_column' => array('UINT', 1),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

+class phpbb_dbal_migration_fail extends phpbb_db_migration

+{

+ function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ $this->table_prefix . 'config' => array(

+ 'test_column' => array('BOOL', 1),

+ ),

+ ),

+ );

+ }

+

+ function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'config' => array(

+ 'test_column',

+ ),

+ ),

+ );

+ }

+

+ function update_data()

+ {

+ return array(

+ array('config.add', array('foobar3', true)),

+ array('config.update', array('does_not_exist', true)),

+ );

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+class phpbb_dbal_migration_if extends phpbb_db_migration

+{

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ return array(

+ array('if', array(

+ true,

+ array('custom', array(array(&$this, 'test_true'))),

+ )),

+ array('if', array(

+ false,

+ array('custom', array(array(&$this, 'test_false'))),

+ )),

+ );

+ }

+

+ function test_true()

+ {

+ global $migrator_test_if_true_failed;

+

+ $migrator_test_if_true_failed = false;

+ }

+

+ function test_false()

+ {

+ global $migrator_test_if_false_failed;

+

+ $migrator_test_if_false_failed = true;

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+class phpbb_dbal_migration_installed extends phpbb_db_migration

+{

+ function effectively_installed()

+ {

+ return true;

+ }

+

+ function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'test'))),

+ );

+ }

+

+ function test()

+ {

+ global $migrator_test_installed_failed;

+

+ $migrator_test_installed_failed = true;

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+class phpbb_dbal_migration_recall extends phpbb_db_migration

+{

+ function update_schema()

+ {

+ return array();

+ }

+

+ function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'test_call'))),

+ );

+ }

+

+ // This function should be called 10 times

+ function test_call($input)

+ {

+ global $migrator_test_call_input;

+

+ $migrator_test_call_input = (int) $input;

+

+ if ($migrator_test_call_input < 10)

+ {

+ return ($migrator_test_call_input + 1);

+ }

+

+ return;

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+class phpbb_dbal_migration_revert extends phpbb_db_migration

+{

+ function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ 'phpbb_config' => array(

+ 'bar_column' => array('UINT', 1),

+ ),

+ ),

+ );

+ }

+

+ function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ 'phpbb_config' => array(

+ 'bar_column',

+ ),

+ ),

+ );

+ }

+

+ function update_data()

+ {

+ return array(

+ array('config.add', array('foobartest', 0)),

+ );

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+class phpbb_dbal_migration_revert_with_dependency extends phpbb_db_migration

+{

+ static public function depends_on()

+ {

+ return array('phpbb_dbal_migration_revert');

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+class phpbb_dbal_migration_unfulfillable extends phpbb_db_migration

+{

+ static public function depends_on()

+ {

+ return array('installed_migration', 'phpbb_dbal_migration_dummy', 'non_existant_migration');

+ }

+

+ function update_schema()

+ {

+ trigger_error('Schema update of migration with unfulfillable dependency was run!');

+ }

+

+ function update_data()

+ {

+ trigger_error('Data update of migration with unfulfillable dependency was run!');

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/db/migrator.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/db/migration/migration.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/db/db_tools.php';

+

+require_once dirname(__FILE__) . '/migration/dummy.php';

+require_once dirname(__FILE__) . '/migration/unfulfillable.php';

+require_once dirname(__FILE__) . '/migration/if.php';

+require_once dirname(__FILE__) . '/migration/recall.php';

+require_once dirname(__FILE__) . '/migration/revert.php';

+require_once dirname(__FILE__) . '/migration/revert_with_dependency.php';

+require_once dirname(__FILE__) . '/migration/fail.php';

+require_once dirname(__FILE__) . '/migration/installed.php';

+

+class phpbb_dbal_migrator_test extends phpbb_database_test_case

+{

+ protected $db;

+ protected $db_tools;

+ protected $migrator;

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/migrator.xml');

+ }

+

+ public function setUp()

+ {

+ parent::setUp();

+

+ $this->db = $this->new_dbal();

+ $this->db_tools = new phpbb_db_tools($this->db);

+

+ $this->config = new phpbb_config_db($this->db, new phpbb_mock_cache, 'phpbb_config');

+

+ $tools = array(

+ new phpbb_db_migration_tool_config($this->config),

+ );

+

+ $this->migrator = new phpbb_db_migrator(

+ $this->config,

+ $this->db,

+ $this->db_tools,

+ 'phpbb_migrations',

+ dirname(__FILE__) . '/../../phpBB/',

+ 'php',

+ 'phpbb_',

+ $tools

+ );

+

+ $container = new phpbb_mock_container_builder();

+ $container->set('migrator', $migrator);

+

+ $this->extension_manager = new phpbb_extension_manager(

+ $container,

+ $this->db,

+ $this->config,

+ new phpbb_filesystem(),

+ 'phpbb_ext',

+ dirname(__FILE__) . '/../../phpBB/',

+ 'php',

+ null

+ );

+ }

+

+ public function test_update()

+ {

+ $this->migrator->set_migrations(array('phpbb_dbal_migration_dummy'));

+

+ // schema

+ $this->migrator->update();

+ $this->assertFalse($this->migrator->finished());

+

+ $this->assertSqlResultEquals(

+ array(array('success' => '1')),

+ "SELECT 1 as success

+ FROM phpbb_migrations

+ WHERE migration_name = 'phpbb_dbal_migration_dummy'

+ AND migration_start_time >= " . (time() - 1) . "

+ AND migration_start_time <= " . (time() + 1),

+ 'Start time set correctly'

+ );

+

+ // data

+ $this->migrator->update();

+ $this->assertTrue($this->migrator->finished());

+

+ $this->assertSqlResultEquals(

+ array(array('extra_column' => '1')),

+ "SELECT extra_column FROM phpbb_config WHERE config_name = 'foo'",

+ 'Dummy migration created extra_column with value 1 in all rows.'

+ );

+

+ $this->assertSqlResultEquals(

+ array(array('success' => '1')),

+ "SELECT 1 as success

+ FROM phpbb_migrations

+ WHERE migration_name = 'phpbb_dbal_migration_dummy'

+ AND migration_start_time <= migration_end_time

+ AND migration_end_time >= " . (time() - 1) . "

+ AND migration_end_time <= " . (time() + 1),

+ 'End time set correctly'

+ );

+

+ // cleanup

+ $this->db_tools->sql_column_remove('phpbb_config', 'extra_column');

+ }

+

+ public function test_unfulfillable()

+ {

+ $this->migrator->set_migrations(array('phpbb_dbal_migration_unfulfillable', 'phpbb_dbal_migration_dummy'));

+

+ while (!$this->migrator->finished())

+ {

+ $this->migrator->update();

+ }

+

+ $this->assertTrue($this->migrator->finished());

+

+ $this->assertSqlResultEquals(

+ array(array('extra_column' => '1')),

+ "SELECT extra_column FROM phpbb_config WHERE config_name = 'foo'",

+ 'Dummy migration was run, even though an unfulfillable migration was found.'

+ );

+

+ $this->db_tools->sql_column_remove('phpbb_config', 'extra_column');

+ }

+

+ public function test_if()

+ {

+ $this->migrator->set_migrations(array('phpbb_dbal_migration_if'));

+

+ // Don't like this, but I'm not sure there is any other way to do this

+ global $migrator_test_if_true_failed, $migrator_test_if_false_failed;

+ $migrator_test_if_true_failed = true;

+ $migrator_test_if_false_failed = false;

+

+ while (!$this->migrator->finished())

+ {

+ $this->migrator->update();

+ }

+

+ $this->assertFalse($migrator_test_if_true_failed, 'True test failed');

+ $this->assertFalse($migrator_test_if_false_failed, 'False test failed');

+ }

+

+ public function test_recall()

+ {

+ $this->migrator->set_migrations(array('phpbb_dbal_migration_recall'));

+

+ global $migrator_test_call_input;

+

+ // Run the schema first

+ $this->migrator->update();

+

+ $i = 0;

+ while (!$this->migrator->finished())

+ {

+ $this->migrator->update();

+

+ $this->assertSame($i, $migrator_test_call_input);

+

+ $i++;

+ }

+

+ $this->assertSame(10, $migrator_test_call_input);

+ }

+

+ public function test_revert()

+ {

+ // Make sure there are no other migrations in the db, this could cause issues

+ $this->db->sql_query("DELETE FROM phpbb_migrations");

+ $this->migrator->load_migration_state();

+

+ $this->migrator->set_migrations(array('phpbb_dbal_migration_revert', 'phpbb_dbal_migration_revert_with_dependency'));

+

+ $this->assertFalse($this->migrator->migration_state('phpbb_dbal_migration_revert'));

+ $this->assertFalse($this->migrator->migration_state('phpbb_dbal_migration_revert_with_dependency'));

+

+ // Install the migration first

+ while (!$this->migrator->finished())

+ {

+ $this->migrator->update();

+ }

+

+ $this->assertTrue($this->migrator->migration_state('phpbb_dbal_migration_revert') !== false);

+ $this->assertTrue($this->migrator->migration_state('phpbb_dbal_migration_revert_with_dependency') !== false);

+

+ $this->assertSqlResultEquals(

+ array(array('bar_column' => '1')),

+ "SELECT bar_column FROM phpbb_config WHERE config_name = 'foo'",

+ 'Installing revert migration failed to create bar_column.'

+ );

+

+ $this->assertTrue(isset($this->config['foobartest']));

+

+ while ($this->migrator->migration_state('phpbb_dbal_migration_revert') !== false)

+ {

+ $this->migrator->revert('phpbb_dbal_migration_revert');

+ }

+

+ $this->assertFalse($this->migrator->migration_state('phpbb_dbal_migration_revert'));

+ $this->assertFalse($this->migrator->migration_state('phpbb_dbal_migration_revert_with_dependency'));

+

+ $this->assertFalse(isset($this->config['foobartest']));

+

+ $sql = 'SELECT * FROM phpbb_config';

+ $result = $this->db->sql_query_limit($sql, 1);

+ $row = $this->db->sql_fetchrow($result);

+ $this->db->sql_freeresult($result);

+

+ if (isset($row['bar_column']))

+ {

+ $this->fail('Revert did not remove test_column.');

+ }

+ }

+

+ public function test_fail()

+ {

+ $this->migrator->set_migrations(array('phpbb_dbal_migration_fail'));

+

+ $this->assertFalse(isset($this->config['foobar3']));

+

+ try

+ {

+ while (!$this->migrator->finished())

+ {

+ $this->migrator->update();

+ }

+ }

+ catch (phpbb_db_migration_exception $e) {}

+

+ // Failure should have caused an automatic roll-back, so this should not exist.

+ $this->assertFalse(isset($this->config['foobar3']));

+

+ $sql = 'SELECT * FROM phpbb_config';

+ $result = $this->db->sql_query_limit($sql, 1);

+ $row = $this->db->sql_fetchrow($result);

+ $this->db->sql_freeresult($result);

+

+ if (isset($row['test_column']))

+ {

+ $this->fail('Revert did not remove test_column.');

+ }

+ }

+

+ public function test_installed()

+ {

+ $this->migrator->set_migrations(array('phpbb_dbal_migration_installed'));

+

+ global $migrator_test_installed_failed;

+ $migrator_test_installed_failed = false;

+

+ while (!$this->migrator->finished())

+ {

+ $this->migrator->update();

+ }

+

+ $this->assertTrue($this->migrator->migration_state('phpbb_dbal_migration_installed') !== false);

+

+ if ($migrator_test_installed_failed)

+ {

+ $this->fail('Installed test failed');

+ }

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/db/migration/tool/config.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/db/migration/exception.php';

+

+class phpbb_dbal_migrator_tool_config_test extends phpbb_test_case

+{

+ public function setup()

+ {

+ $this->config = new phpbb_config(array());

+

+ $this->tool = new phpbb_db_migration_tool_config($this->config);

+

+ parent::setup();

+ }

+

+ public function test_add()

+ {

+ try

+ {

+ $this->tool->add('foo', 'bar');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals('bar', $this->config['foo']);

+

+ try

+ {

+ $this->tool->add('foo', 'bar');

+ $this->fail('Exception not thrown');

+ }

+ catch (Exception $e) {}

+ }

+

+ public function test_update()

+ {

+ $this->config->set('foo', 'bar');

+ try

+ {

+ $this->tool->update('foo', 'bar2');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals('bar2', $this->config['foo']);

+ }

+

+ public function test_update_if_equals()

+ {

+ $this->config->set('foo', 'bar');

+

+ try

+ {

+ $this->tool->update_if_equals('', 'foo', 'bar2');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals('bar', $this->config['foo']);

+

+ try

+ {

+ $this->tool->update_if_equals('bar', 'foo', 'bar2');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals('bar2', $this->config['foo']);

+ }

+

+ public function test_remove()

+ {

+ $this->config->set('foo', 'bar');

+

+ try

+ {

+ $this->tool->remove('foo');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertFalse(isset($this->config['foo']));

+ }

+

+ public function test_reverse()

+ {

+ $this->config->set('foo', 'bar');

+

+ try

+ {

+ $this->tool->reverse('add', 'foo');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertFalse(isset($this->config['foo']));

+

+ $this->config->set('foo', 'bar');

+

+ try

+ {

+ $this->tool->reverse('update_if_equals', 'test', 'foo', 'bar');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals('test', $this->config['foo']);

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/db/migration/tool/module.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/db/migration/exception.php';

+

+class phpbb_dbal_migrator_tool_module_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/migrator_module.xml');

+ }

+

+ public function setup()

+ {

+ // Need global $db, $user for delete_module function in acp_modules

+ global $phpbb_root_path, $phpEx, $skip_add_log, $db, $user, $phpbb_log;

+

+ parent::setup();

+

+ // Force add_log function to not be used

+ $skip_add_log = true;

+

+ $db = $this->db = $this->new_dbal();

+ $this->cache = new phpbb_cache_service(new phpbb_cache_driver_null(), new phpbb_config(array()), $this->db, $phpbb_root_path, $phpEx);

+ $user = $this->user = new phpbb_user();

+

+ $cache = new phpbb_mock_cache;

+ $phpbb_dispatcher = new phpbb_mock_event_dispatcher();

+ $auth = $this->getMock('phpbb_auth');

+ $phpbb_log = new phpbb_log($db, $user, $auth, $phpbb_dispatcher, $phpbb_root_path, 'adm/', $phpEx, LOG_TABLE);

+

+ $this->tool = new phpbb_db_migration_tool_module($this->db, $this->cache, $this->user, $phpbb_root_path, $phpEx, 'phpbb_modules');

+ }

+

+ public function exists_data()

+ {

+ return array(

+ // Test the category

+ array(

+ '',

+ 'ACP_CAT',

+ true,

+ ),

+ array(

+ 0,

+ 'ACP_CAT',

+ true,

+ ),

+

+ // Test the module

+ array(

+ '',

+ 'ACP_MODULE',

+ false,

+ ),

+ array(

+ false,

+ 'ACP_MODULE',

+ true,

+ ),

+ array(

+ 'ACP_CAT',

+ 'ACP_MODULE',

+ true,

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider exists_data

+ */

+ public function test_exists($parent, $module, $expected)

+ {

+ $this->assertEquals($expected, $this->tool->exists('acp', $parent, $module));

+ }

+

+ public function test_add()

+ {

+ try

+ {

+ $this->tool->add('acp', 0, 'ACP_NEW_CAT');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals(true, $this->tool->exists('acp', 0, 'ACP_NEW_CAT'));

+

+ // Should throw an exception when trying to add a module that already exists

+ try

+ {

+ $this->tool->add('acp', 0, 'ACP_NEW_CAT');

+ $this->fail('Exception not thrown');

+ }

+ catch (Exception $e) {}

+

+ try

+ {

+ $this->tool->add('acp', 'ACP_NEW_CAT', array(

+ 'module_basename' => 'acp_new_module',

+ 'module_langname' => 'ACP_NEW_MODULE',

+ 'module_mode' => 'test',

+ 'module_auth' => '',

+ ));

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals(true, $this->tool->exists('acp', 'ACP_NEW_CAT', 'ACP_NEW_MODULE'));

+ }

+

+ public function test_remove()

+ {

+ try

+ {

+ $this->tool->remove('acp', 'ACP_CAT', 'ACP_MODULE');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals(false, $this->tool->exists('acp', 'ACP_CAT', 'ACP_MODULE'));

+ }

+

+ public function test_reverse()

+ {

+ try

+ {

+ $this->tool->add('acp', 0, 'ACP_NEW_CAT');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+

+ try

+ {

+ $this->tool->reverse('add', 'acp', 0, 'ACP_NEW_CAT');

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertFalse($this->tool->exists('acp', 0, 'ACP_NEW_CAT'));

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/db/migration/tool/permission.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/db/migration/exception.php';

+

+class phpbb_dbal_migrator_tool_permission_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/migrator_permission.xml');

+ }

+

+ public function setup()

+ {

+ // Global $db and $cache are needed in acp/auth.php constructor

+ global $phpbb_root_path, $phpEx, $db, $cache;

+

+ parent::setup();

+

+ $db = $this->db = $this->new_dbal();

+ $cache = $this->cache = new phpbb_cache_service(new phpbb_cache_driver_null(), new phpbb_config(array()), $this->db, $phpbb_root_path, $phpEx);

+ $this->auth = new phpbb_auth();

+

+ $this->tool = new phpbb_db_migration_tool_permission($this->db, $this->cache, $this->auth, $phpbb_root_path, $phpEx);

+ }

+

+ public function exists_data()

+ {

+ return array(

+ array(

+ 'global',

+ true,

+ true,

+ ),

+ array(

+ 'local',

+ false,

+ true,

+ ),

+ array(

+ 'both',

+ true,

+ true,

+ ),

+ array(

+ 'both',

+ false,

+ true,

+ ),

+ array(

+ 'does_not_exist',

+ true,

+ false,

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider exists_data

+ */

+ public function test_exists($auth_option, $global, $expected)

+ {

+ $this->assertEquals($expected, $this->tool->exists($auth_option, $global));

+ }

+

+ public function test_add()

+ {

+ try

+ {

+ $this->tool->add('new', true);

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals(true, $this->tool->exists('new', true));

+ $this->assertEquals(false, $this->tool->exists('new', false));

+

+ try

+ {

+ $this->tool->add('new', false);

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals(true, $this->tool->exists('new', false));

+

+ // Should fail (duplicate)

+ try

+ {

+ $this->tool->add('new', true);

+ $this->fail('Did not throw exception on duplicate');

+ }

+ catch (Exception $e) {}

+ }

+

+ public function test_remove()

+ {

+ try

+ {

+ $this->tool->remove('global', true);

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals(false, $this->tool->exists('global', true));

+

+ try

+ {

+ $this->tool->remove('both', false);

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertEquals(false, $this->tool->exists('both', false));

+

+ // Should fail (does not exist)

+ try

+ {

+ $this->tool->remove('new', true);

+ $this->fail('Did not throw exception on duplicate');

+ }

+ catch (Exception $e) {}

+ }

+

+ public function test_reverse()

+ {

+ try

+ {

+ $this->tool->reverse('remove', 'global_test', true);

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertTrue($this->tool->exists('global_test', true));

+

+ try

+ {

+ $this->tool->reverse('add', 'global_test', true);

+ }

+ catch (Exception $e)

+ {

+ $this->fail($e);

+ }

+ $this->assertFalse($this->tool->exists('global_test', true));

+ }

+}

+ 'style_path' => 'prosilver',

+ 'bbcode_bitfield' => 'kNg=',

+ 'style_parent_id' => 0,

+ 'style_parent_tree' => '',

+ 'style_path' => 'prosilver1',

+ 'bbcode_bitfield' => 'kNg=',

+ 'style_parent_id' => 1,

+ 'style_parent_tree' => 'prosilver',

+ 'style_path' => 'prosilver2',

+ 'bbcode_bitfield' => 'kNg=',

+ 'style_parent_id' => 0,

+ 'style_parent_tree' => '',

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+

+class phpbb_dbal_schema_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/config.xml');

+ }

+

+ public function test_config_value_multibyte()

+ {

+ $db = $this->new_dbal();

+

+ $value = str_repeat("\xC3\x84", 255);

+ $sql = "INSERT INTO phpbb_config

+ (config_name, config_value)

+ VALUES ('name', '$value')";

+ $result = $db->sql_query($sql);

+

+ $sql = "SELECT config_value

+ FROM phpbb_config

+ WHERE config_name = 'name'";

+ $result = $db->sql_query_limit($sql, 1);

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ $this->assertEquals($value, $row['config_value']);

+ }

+}

+ public function return_on_error_select_data()

+ public function fetchrow_data()

+ public function fetchfield_data()

+ public function like_expression_data()

+ public function in_set_data()

+ public function build_array_data()

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_dbal_sql_insert_buffer_test extends phpbb_database_test_case

+{

+ protected $db;

+ protected $buffer;

+

+ public function setUp()

+ {

+ parent::setUp();

+

+ $this->db = $this->new_dbal();

+ $this->buffer = new phpbb_db_sql_insert_buffer($this->db, 'phpbb_config', 2);

+ $this->assert_config_count(2);

+ }

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/config.xml');

+ }

+

+ public function test_multi_insert_disabled_insert_and_flush()

+ {

+ $this->db->multi_insert = false;

+ $this->assertTrue($this->buffer->insert($this->get_row(1)));

+ $this->assert_config_count(3);

+ $this->assertFalse($this->buffer->flush());

+ $this->assert_config_count(3);

+ }

+

+ public function test_multi_insert_enabled_insert_and_flush()

+ {

+ $this->check_multi_insert_support();

+ $this->assertFalse($this->buffer->insert($this->get_row(1)));

+ $this->assert_config_count(2);

+ $this->assertTrue($this->buffer->flush());

+ $this->assert_config_count(3);

+ }

+

+ public function test_multi_insert_disabled_insert_with_flush()

+ {

+ $this->db->multi_insert = false;

+ $this->assertTrue($this->buffer->insert($this->get_row(1)));

+ $this->assert_config_count(3);

+ $this->assertTrue($this->buffer->insert($this->get_row(2)));