- apc (APC cache driver)

- bz2 (compress tests)

- mysql, pdo_mysql (MySQL database driver)

- mysqli, pdo_mysql (MySQLi database driver)

- pcntl (flock class)

----------------------

In order to run tests on some of the databases that we support, it will be

necessary to provide a custom DSN string in test_config.php. This is only

$custom_dsn = "Driver={SQL Server Native Client 10.0};Server=$dbhost;Database=$dbname";

<column>session_id</column>

<column>provider</column>

<column>oauth_token</column>

</table>

</dataset>

use OAuth\OAuth2\Token\StdOAuth2Token;

class phpbb_auth_provider_oauth_token_storage_test extends phpbb_database_test_case

{

protected $db;

$this->assertEquals($token, $stored_token);

}

public function test_retrieveAccessToken_from_db()

{

$expected_token = new StdOAuth2Token('access', 'refresh', StdOAuth2Token::EOL_NEVER_EXPIRES);

new phpbb_mock_request()

),

new \phpbb\filesystem(),

$phpbb_root_path,

$phpEx

);

// $this->avatar_foobar will be needed later on

$this->avatar_foobar = $this->getMock('\phpbb\avatar\driver\foobar', array('get_name'), array($config, $phpbb_root_path, $phpEx, $path_helper, $cache));

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

foreach ($this->avatar_drivers() as $driver)

{

$cur_avatar->expects($this->any())

->method('get_name')

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

require_once 'test_framework/phpbb_test_case.php';

require_once 'test_framework/phpbb_database_test_case.php';

require_once 'test_framework/phpbb_database_test_connection_manager.php';

require_once 'test_framework/phpbb_functional_test_case.php';

public function get_command_tester()

{

$application = new Application();

$command = $application->find('cron:list');

$this->command_name = $command->getName();

$this->get_cron_manager($tasks);

$this->command_tester = $this->get_command_tester();

}

}

public function get_command_tester()

{

$application = new Application();

$command = $application->find('cron:run');

$this->command_name = $command->getName();

*/

public function test_delete_post($forum_id, $topic_id, $post_id, $data, $is_soft, $reason, $expected_posts, $expected_topic, $expected_forum)

{

$config['search_type'] = 'phpbb_mock_search';

$cache = new phpbb_mock_cache;

)));

$user = $this->getMock('\phpbb\user');

$phpbb_container = new phpbb_mock_container_builder();

$phpbb_container->set('notification_manager', new phpbb_mock_notification_manager());

$phpbb_container->set('content.visibility', new \phpbb\content_visibility($auth, $phpbb_config, $db, $user, $phpbb_root_path, $phpEx, FORUMS_TABLE, POSTS_TABLE, TOPICS_TABLE, USERS_TABLE));

new phpbb_mock_request()

),

new \phpbb\filesystem(),

$phpbb_root_path,

$phpEx

);

'c_bool' => array('BOOL', 1),

'c_vchar' => array('VCHAR', 'foo'),

'c_vchar_size' => array('VCHAR:4', 'foo'),

'c_char_size' => array('CHAR:4', 'foo'),

'c_xstext' => array('XSTEXT', 'foo'),

'c_stext' => array('STEXT', 'foo'),

'c_bool' => 0,

'c_vchar' => '',

'c_vchar_size' => '',

'c_char_size' => 'abcd',

'c_xstext' => '',

'c_stext' => '',

array('c_bool', 0),

array('c_vchar', str_repeat('a', 255)),

array('c_vchar_size', str_repeat('a', 4)),

array('c_char_size', str_repeat('a', 4)),

array('c_xstext', str_repeat('a', 1000)),

array('c_stext', str_repeat('a', 3000)),

{

$db = $this->new_dbal();

{

$this->markTestSkipped('MySQL 5.6 fails to order things correctly. See also: http://tracker.phpbb.com/browse/PHPBB3-11571 http://bugs.mysql.com/bug.php?id=69005');

}

{

$db = $this->new_dbal();

$where = ($like_expression) ? 'username_clean ' . $db->sql_like_expression($like_expression) : '';

$result = $db->sql_query('SELECT username_clean

public function test_multi_insert_disabled_insert_and_flush()

{

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

$this->assert_config_count(3);

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

public function test_multi_insert_disabled_insert_with_flush()

{

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

$this->assert_config_count(3);

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

public function test_multi_insert_disabled_insert_all_and_flush()

{

$this->assertTrue($this->buffer->insert_all($this->get_rows(3)));

$this->assert_config_count(5);

}

protected function check_multi_insert_support()

{

{

$this->markTestSkipped('Database does not support multi_insert');

}

namespace

{

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

{

{

$this->assertInstanceOf('Symfony\Component\DependencyInjection\ContainerBuilder', $container);

}

{

$this->assertInstanceOf('Symfony\Component\DependencyInjection\ContainerBuilder', $container);

$this->assertTrue($container->isFrozen());

}

{

$this->assertInstanceOf('Symfony\Component\DependencyInjection\ContainerBuilder', $container);

}

}

}

function sql_like_expression($expression)

{

}

}

}

array('* @since 3.1.0-a1', '3.1.0-a1'),

array('* @since 3.1.0-b3', '3.1.0-b3'),

array(' * @since 3.1.0-b3', '3.1.0-b3'),

);

}

array('* @since 3.1.0-a1 bertie is cool'),

array('bertie* @since 3.1.0-a1'),

array('* @since 3.1-A2'),

);

}

"role": "N/A"

}],

"require": {

},

"extra": {

}

}

"role": "N/A"

}],

"require": {

},

"extra": {

}

}

"role": "N/A"

}],

"require": {

},

"extra": {

}

}

"role": "N/A"

}],

"require": {

},

"extra": {

}

}

require_once dirname(__FILE__) . '/ext/vendor2/bar/ext.php';

require_once dirname(__FILE__) . '/ext/vendor2/foo/ext.php';

require_once dirname(__FILE__) . '/ext/vendor/moo/ext.php';

class phpbb_extension_manager_test extends phpbb_database_test_case

$this->extension_manager = $this->create_extension_manager();

}

{

// barfoo and vendor3/bar should not listed due to missing composer.json. barfoo also has incorrect dir structure.

}

{

$this->assertEquals(array('vendor2/foo'), array_keys($this->extension_manager->all_enabled()));

}

{

$this->assertEquals(array('vendor/moo', 'vendor2/foo'), array_keys($this->extension_manager->all_configured()));

}

public function test_enable()

{

vendor2\bar\ext::$state = 0;

$this->assertEquals(4, vendor2\bar\ext::$state);

}

public function test_disable()

{

vendor2\foo\ext::$disabled = false;

protected function create_extension_manager($with_cache = true)

{

$db = $this->new_dbal();

$db_tools = new \phpbb\db\tools($db);

$phpbb_root_path = __DIR__ . './../../phpBB/';

protected $cache;

protected $config;

protected $db;

protected $phpbb_root_path;

protected $phpEx;

protected $template;

protected $user;

new phpbb_mock_request()

),

new \phpbb\filesystem(),

$this->phpbb_root_path,

$this->phpEx

),

new \phpbb\db\migration\helper()

);

$container = new phpbb_mock_container_builder();

$this->extension_manager = new \phpbb\extension\manager(

$container,

{

$manager->get_metadata();

}

}

// Should be the same as a direct json_decode of the composer.json file

{

$metadata = $manager->get_metadata();

}

{

$this->fail($e);

}

$this->assertEquals($metadata, $json);

}

{

try

{

$this->fail('Exception not triggered');

}

catch(\phpbb\extension\exception $e)

{

}

try

{

$manager->validate_authors();

$this->fail('Exception not triggered');

}

{

$this->assertEquals((string) $e, $this->user->lang('META_FIELD_NOT_SET', 'authors'));

}

try

{

$manager->validate_authors();

$this->fail('Exception not triggered');

}

{

$this->assertEquals((string) $e, $this->user->lang('META_FIELD_NOT_SET', 'author name'));

}

}

{

// Invalid data

$manager->set_metadata(array(

));

try

{

$this->fail('Exception not triggered');

}

catch(\phpbb\extension\exception $e)

{

}

}

}

}

{

),

),

),

),

),

),

{

}

$manager->merge_metadata(array(

'require' => array(

),

));

}

/**

array('foo/bar/.', 'foo/bar'),

array('./foo/bar', './foo/bar'),

array('../foo/bar', '../foo/bar'),

array('one/two/three', 'one/two/three'),

array('one/two/../three', 'one/three'),

array('one/../two/three', 'two/three'),

),

));

$this->add_lang('posting');

$this->assertContainsLang('DELETE_PERMANENTLY', $crawler->text());

$this->add_lang('mcp');

$crawler = self::request('GET', 'adm/index.php?i=acp_extensions&mode=main&sid=' . $this->sid);

$this->assertCount(1, $crawler->filter('.ext_enabled'));

$this->assertContains('phpBB Foo Extension', $crawler->filter('.ext_enabled')->eq(0)->text());

$this->assertContainsLang('EXTENSION_DISABLE', $crawler->filter('.ext_enabled')->eq(0)->text());

$crawler = self::request('GET', 'adm/index.php?i=acp_extensions&mode=main&action=enable_pre&ext_name=vendor%2Fmoo&sid=' . $this->sid);

$this->assertContains($this->lang('EXTENSION_ENABLE_CONFIRM', 'phpBB Moo Extension'), $crawler->filter('#main')->text());

}

public function test_disable_pre()

),

));

$this->add_lang('posting');

$this->assertContainsLang('DELETE_PERMANENTLY', $crawler->text());

$this->add_lang('mcp');

unlink($fileinfo->getPathname());

}

}

private function upload_file($filename, $mimetype)

$crawler = $this->upload_file('disallowed.jpg', 'image/jpeg');

// DISALLOWED_CONTENT check

}

public function test_too_large()

*

*/

/**

* @group functional

*/

global $config, $user;

$user = null;

$config = array();

}

public function test_invalid_extension()

"role": "Developer"

}],

"require": {

},

"extra": {

}

}

'config[allow_password_reset]' => 1,

));

$crawler = self::submit($form);

}

}

{

$this->login();

}

}

public function test_handle_quickmod($crawler)

{

// Test moving a post

}

/**

$crawler = self::submit($form);

$this->assertContains($this->lang('POSTS_MERGED_SUCCESS'), $crawler->text());

}

}

unlink($fileinfo->getPathname());

}

}

public function get_urls()

$crawler = self::request('GET', "posting.php?mode=quote&f=2&t={$post2['topic_id']}&p={$post2['post_id']}&sid={$this->sid}");

$this->assertContains('This is a test post posted by the testing framework.', $crawler->filter('html')->text());

}

}

$this->assertContainsLang('UCP_PROFILE_PROFILE_INFO', $crawler->filter('#cp-main h2')->text());

$form = $crawler->selectButton('Submit')->form(array(

'pf_phpbb_location' => 'Bertie´s Empire',

));

$crawler = self::submit($form);

$this->assertContainsLang('PROFILE_UPDATED', $crawler->filter('#message')->text());

$crawler = self::request('GET', 'ucp.php?i=ucp_profile&mode=profile_info');

$form = $crawler->selectButton('Submit')->form();

$this->assertEquals('Bertie´s Empire', $form->get('pf_phpbb_location')->getValue());

}

}

'forum_last_post_id' => 0,

), 'before moving #2');

$this->assertContainsLang('SELECT_DESTINATION_FORUM', $crawler->text());

$this->add_lang('mcp');

'forum_last_post_id' => $this->data['posts']['Soft Delete Topic #1'],

), 'before softdeleting #2');

$this->add_lang('posting');

$this->assertContainsLang('DELETE_PERMANENTLY', $crawler->text());

$this->add_lang('mcp');

'forum_last_post_id' => 0,

), 'before moving #2');

$this->assertContainsLang('SELECT_DESTINATION_FORUM', $crawler->text());

$this->add_lang('mcp');

'forum_last_post_id' => 0,

), 'before splitting #2');

$this->add_lang('mcp');

$this->assertContainsLang('SPLIT_TOPIC_EXPLAIN', $crawler->text());

$form = $crawler->selectButton('Submit')->form(array(

),

));

$form = $crawler->selectButton('Yes')->form();

$form['to_forum_id']->select($this->data['forums']['Soft Delete #1']);

$crawler = self::submit($form);

$this->assertContainsLang('BOOKMARK_ADDED', $crawler_bookmark->text());

$this->add_lang('mcp');

$this->assertContainsLang('SELECT_MERGE', $crawler->text());

$crawler = self::request('GET', "mcp.php?f={$this->data['forums']['Soft Delete #1']}&t={$this->data['topics']['Soft Delete Topic #2']}&i=main&mode=forum_view&action=merge_topic&to_topic_id={$this->data['topics']['Soft Delete Topic #1']}");

'forum_last_post_id' => 0,

), 'before forking #2');

$this->add_lang('mcp');

$this->assertContainsLang('FORK_TOPIC', $crawler->text());

$form = $crawler->selectButton('Yes')->form();

new phpbb_mock_request()

),

new \phpbb\filesystem(),

$phpbb_root_path,

'php'

);

}

public function build_url_test_data()

{

public function convert_30_dbms_to_31_data()

{

return array(

array('mssql'),

array('mssql_odbc'),

array('mssqlnative'),

{

$expected = "phpbb\\db\\driver\\$input";

$this->assertEquals($expected, $output);

}

{

return array(

array(0, false, array(

'l_online_users' => 'ONLINE_USERS_TOTAL 5 REG_USERS_TOTAL 2 HIDDEN_USERS_TOTAL 3',

)),

array(0, true, array(

'l_online_users' => 'ONLINE_USERS_TOTAL_GUESTS 7 REG_USERS_TOTAL 2 HIDDEN_USERS_TOTAL 3 GUEST_USERS_TOTAL 2',

)),

array(1, false, array(

'l_online_users' => 'ONLINE_USERS_TOTAL 2 REG_USERS_TOTAL 1 HIDDEN_USERS_TOTAL 1',

)),

array(1, true, array(

'l_online_users' => 'ONLINE_USERS_TOTAL_GUESTS 3 REG_USERS_TOTAL 1 HIDDEN_USERS_TOTAL 1 GUEST_USERS_TOTAL 1',

)),

array(2, false, array(

global $phpbb_root_path, $phpEx;

return array(

array(2, 'Administrator', 'FF0000', false, false, '<a href="' . $phpbb_root_path . 'memberlist.' . $phpEx . '?mode=viewprofile&amp;u=2" style="color: #FF0000;" class="username-coloured">Administrator</a>'),

);

}

public function get_username_string_no_profile_data()

{

return array(

array(2, 'Administrator', 'FF0000', false, false, '<span style="color: #FF0000;" class="username-coloured">Administrator</span>'),

);

}

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

'reportee_id' => 2,

'reportee_username' => 'admin',

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

'reportee_id' => 1,

'reportee_username' => 'Anonymous',

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

'user_id' => 1,

'username' => 'Anonymous',

'ip' => '127.0.0.1',

'time' => 1,

$provider->find_routing_files($manager->get_finder());

$this->route_collection = $provider->find($phpbb_root_path_ext)->get_routes();

}

}

'post_username' => 'A',

'responders' => null,

),

),

array(

array(

array('username' => '', 'poster_id' => 3),

),

),

),

array(

array(

array('username' => '', 'poster_id' => 4),

),

),

),

array(

array(

array('username' => '', 'poster_id' => 5),

),

),

),

array(

array(

array('username' => '', 'poster_id' => 6),

),

),

),

);

}

class phpbb_path_helper_test extends phpbb_test_case

{

protected $path_helper;

protected $phpbb_root_path = '';

{

parent::setUp();

$this->path_helper = new \phpbb\path_helper(

new \phpbb\symfony_request(

new phpbb_mock_request()

),

new \phpbb\filesystem(),

$this->phpbb_root_path,

'php'

);

* any time we wish to use it in one of these functions (and

* also in general for everything else)

*/

{

}

public function test_get_web_root_path()

public function basic_update_web_root_path_data()

{

return array(

array(

),

array(

$this->phpbb_root_path . $this->phpbb_root_path . 'test.php',

),

);

}

*/

public function test_basic_update_web_root_path($input, $expected)

{

}

public function update_web_root_path_data()

{

return array(

array(

$this->phpbb_root_path . 'test.php',

'/',

),

array(

$this->phpbb_root_path . 'test.php',

'//',

),

array(

$this->phpbb_root_path . 'test.php',

'//',

'foo/bar.php',

'bar.php',

),

array(

$this->phpbb_root_path . 'test.php',

'/foo/template',

'/phpbb3-fork/phpBB/app.php/foo/template',

'/phpbb3-fork/phpBB/app.php',

),

array(

$this->phpbb_root_path . 'test.php',

'/foo/template',

'/phpbb3-fork/phpBB/foo/template',

'/phpbb3-fork/phpBB/app.php',

),

array(

$this->phpbb_root_path . 'test.php',

'/',

'/phpbb3-fork/phpBB/app.php/',

'/phpbb3-fork/phpBB/app.php',

),

);

}

/**

* @dataProvider update_web_root_path_data

*/

{

new phpbb_mock_request(),

));

$symfony_request->expects($this->any())

$path_helper = new \phpbb\path_helper(

$symfony_request,

new \phpbb\filesystem(),

$this->phpbb_root_path,

'php'

);

}

public function clean_url_data()

{

$this->assertEquals($expected, $this->path_helper->append_url_params($url, $params, $is_amp));

}

}

new phpbb_mock_request()

),

new \phpbb\filesystem(),

$this->phpbb_root_path,

'php'

);

new phpbb_mock_request()

),

new \phpbb\filesystem(),

$phpbb_root_path,

$phpEx

);

array(),

"13FOOBAR|foobar",

),

);

}

new phpbb_mock_request()

),

new \phpbb\filesystem(),

$phpbb_root_path,

$phpEx

);

new phpbb_mock_request()

),

new \phpbb\filesystem(),

$phpbb_root_path,

$phpEx

);

*/

class phpbb_database_connection_odbc_pdo_wrapper extends PDO

{

public $driver = '';

// Version number of driver since PDO::getAttribute(PDO::ATTR_CLIENT_VERSION) is pretty useless for this

public function createXMLDataSet($path)

{

$this->fixture_xml_data = parent::createXMLDataSet($path);

return $this->fixture_xml_data;

}

return new phpbb_database_test_connection_manager($config);

}

public function assert_array_content_equals($one, $two)

{

// http://stackoverflow.com/questions/3838288/phpunit-assert-two-arrays-are-equal-but-order-of-elements-not-important

// These require different connection strings on the phpBB side than they do in PDO

// so you must provide a DSN string for ODBC separately

{

$dsn = 'odbc:' . $this->config['custom_dsn'];

}

$this->pdo = new phpbb_database_connection_odbc_pdo_wrapper('mssql', 0, $dsn, $this->config['dbuser'], $this->config['dbpasswd']);

break;

default:

$this->pdo = new PDO($dsn, $this->config['dbuser'], $this->config['dbpasswd']);

break;

{

case 'phpbb\db\driver\sqlite':

case 'phpbb\db\driver\sqlite3':

$this->connect();

// Drop all of the tables

foreach ($this->get_tables() as $table)

FROM pg_stat_user_tables';

break;

case 'phpbb\db\driver\oracle':

$sql = 'SELECT table_name

FROM USER_TABLES';

$filename = $directory . $schema . '_schema.sql';

}

// Ok we have the db info go ahead and work on building the table

protected function get_dbms_data($dbms)

{

$available_dbms = array(

'phpbb\db\driver\mysqli' => array(

'SCHEMA' => 'mysql_41',

'DELIM' => ';',

switch ($this->config['dbms'])

{

case 'phpbb\db\driver\oracle':

$sql = 'SELECT sequence_name

FROM USER_SEQUENCES';

*

*/

use Symfony\Component\BrowserKit\CookieJar;

{

static protected $cookieJar;

protected $cache = null;

protected $db = null;

*/

protected $lang = array();

static protected $already_installed = false;

static public function setUpBeforeClass()

self::$config = phpbb_test_case_helpers::get_test_config();

self::$root_url = self::$config['phpbb_functional_url'];

// Important: this is used both for installation and by

// test cases for querying the tables.

// Therefore table prefix must be set before a board is

$this->bootstrap();

// Clear the language array so that things

// that were added in other tests are gone

$this->lang = array();

protected function tearDown()

{

if ($this->db instanceof \phpbb\db\driver\driver_interface)

{

// Close the database connections again this test

$this->db->sql_close();

}

}

/**

return $extension_manager;

}

public function install_ext($extension)

{

$this->login();

$this->logout();

}

/**

* Creates a new style

*

{

$this->add_lang('posting');

$crawler = self::request('GET', $posting_url);

$this->assertContains($this->lang($posting_contains), $crawler->filter('html')->text());

// I use a request because the form submission method does not allow you to send data that is not

// contained in one of the actual form fields that the browser sees (i.e. it ignores "hidden" inputs)

// Instead, I send it as a request with the submit button "post" set to true.

}

/**

*/

public function delete_topic($topic_id)

{

$this->add_lang('posting');

$this->assertContainsLang('DELETE_PERMANENTLY', $crawler->text());

$this->add_lang('mcp');

return $manager;

}

}

$phpbb_path_helper = new \phpbb\path_helper(

$symfony_request,

$phpbb_filesystem,

$phpbb_root_path,

$phpEx

);

$test_config = dirname(__FILE__) . '/../test_config.php';

}

if (file_exists($test_config))

{

$config = array_merge($config, array(

'dbhost' => $dbhost,

'dbport' => $dbport,

'dbname' => $dbname,

if (isset($_SERVER['PHPBB_TEST_DBMS']))

{

$config = array_merge($config, array(

'dbhost' => isset($_SERVER['PHPBB_TEST_DBHOST']) ? $_SERVER['PHPBB_TEST_DBHOST'] : '',

'dbport' => isset($_SERVER['PHPBB_TEST_DBPORT']) ? $_SERVER['PHPBB_TEST_DBPORT'] : '',

'dbname' => isset($_SERVER['PHPBB_TEST_DBNAME']) ? $_SERVER['PHPBB_TEST_DBNAME'] : '',

copy($fileinfo->getPathname(), $this->path . 'copies/' . $fileinfo->getFilename() . '_copy_2');

}

}

}

private function get_filespec($override = array())

'error' => '',

);

}

protected function tearDown()

array('png', 'image/png', true),

array('tif', 'image/tif', true),

array('txt', 'text/plain', false),

);

}

$this->assertEquals($expected, $filespec->is_image());

}

public function move_file_variables()

{

return array(