- 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);

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';

$this->get_cron_manager($tasks);

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

}

}

*/

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, $db, $user, $phpbb_root_path, $phpEx, FORUMS_TABLE, POSTS_TABLE, TOPICS_TABLE, USERS_TABLE));

$this->assertFalse($this->tools->sql_column_exists('prefix_table_name', 'c_bug_12012'));

}

public function test_column_remove()

{

$this->assertTrue($this->tools->sql_column_exists('prefix_table_name', 'c_int_size'));

$this->assertFalse($this->tools->sql_column_exists('prefix_table_name', 'c_int_size'));

}

public function test_column_remove_with_index()

{

// Create column

{

$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');

}

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": {

}

}

$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('vendor/moo', 'vendor2/bar', 'vendor2/foo'), array_keys($this->extension_manager->all_available()));

}

{

$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;

protected $cache;

protected $config;

protected $db;

protected $phpbb_root_path;

protected $phpEx;

protected $template;

protected $user;

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');

),

));

$this->add_lang('posting');

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

$this->add_lang('mcp');

unlink($fileinfo->getPathname());

}

}

private function upload_file($filename, $mimetype)

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

}

/**

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();

public function convert_30_dbms_to_31_data()

{

return array(

array('mssql'),

array('mssql_odbc'),

array('mssqlnative'),

{

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,

'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(

* 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())

'php'

);

}

public function clean_url_data()

array(),

"13FOOBAR|foobar",

),

);

}

*/

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

*

if ($expected !== '')

{

return null;

}

$url = $crawler->selectLink($form_data['subject'])->link()->getUri();

return array(

*/

public function delete_topic($topic_id)

{

$this->add_lang('posting');

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

$this->add_lang('mcp');

return $manager;

}

}

$this->assertEquals($expected, $result, $label);

}

}