aboutsummaryrefslogtreecommitdiffstats
path: root/tests/class_visibility/class_visibility_test.php
diff options
context:
space:
mode:
authorJosh Woody <a_jelly_doughnut@phpbb.com>2010-06-29 21:47:18 -0500
committerJoas Schilling <nickvergessen@gmx.de>2012-08-29 17:50:11 +0200
commit67393751356e9f02f7c1ab0a2f7a3a508403edc3 (patch)
tree3ce9667e340307f77f2679f470ddb1f645aa2558 /tests/class_visibility/class_visibility_test.php
parentfb13ab83e476d2afbc7bb181f7ab90df98f996da (diff)
downloadforums-67393751356e9f02f7c1ab0a2f7a3a508403edc3.tar
forums-67393751356e9f02f7c1ab0a2f7a3a508403edc3.tar.gz
forums-67393751356e9f02f7c1ab0a2f7a3a508403edc3.tar.bz2
forums-67393751356e9f02f7c1ab0a2f7a3a508403edc3.tar.xz
forums-67393751356e9f02f7c1ab0a2f7a3a508403edc3.zip
[feature/soft-delete] Add unit tests for the phpbb_visibility class
Add unit tests for the phpbb_visibility class. Adjust the phpbb_visibility class to pass those unit tests. The changes are pretty small, actually. PHPBB3-9657
Diffstat (limited to 'tests/class_visibility/class_visibility_test.php')
-rw-r--r--tests/class_visibility/class_visibility_test.php194
1 files changed, 194 insertions, 0 deletions
diff --git a/tests/class_visibility/class_visibility_test.php b/tests/class_visibility/class_visibility_test.php
new file mode 100644
index 0000000000..edcf5c2e6f
--- /dev/null
+++ b/tests/class_visibility/class_visibility_test.php
@@ -0,0 +1,194 @@
+<?php
+/**
+*
+* @package testing
+* @version $Id$
+* @copyright (c) 2010 phpBB Group
+* @license http://opensource.org/licenses/gpl-license.php GNU Public License
+*
+*/
+
+require_once 'test_framework/framework.php';
+require_once 'class_visibility/auth_mock.php';
+require_once 'class_visibility/user_mock.php';
+
+require_once '../phpBB/includes/class_visibility.php';
+require_once '../phpBB/includes/db/mysqli.php';
+require_once '../phpBB/includes/functions.php';
+require_once '../phpBB/includes/constants.php';
+
+$GLOBALS['db'] = new dbal_mysqli();
+
+class phpbb_class_visibility_test extends PHPUnit_Framework_TestCase
+{
+ public function test_get_visibility_sql()
+ {
+ $GLOBALS['auth'] = new phpbb_acl_mock_none;
+
+ $sql1 = phpbb_visibility::get_visibility_sql('topic', 1, '');
+ $this->assertEquals('topic_visibility = 1', $sql1);
+
+ $sql2 = phpbb_visibility::get_visibility_sql('post', 1, '');
+ $this->assertEquals('post_visibility = 1', $sql2);
+
+ $GLOBALS['auth'] = new phpbb_acl_mock_founder;
+
+ $sql3 = phpbb_visibility::get_visibility_sql('topic', 1, '');
+ $this->assertEquals('topic_visibility IN (1, 0, 2)', $sql3);
+
+ $sql4 = phpbb_visibility::get_visibility_sql('post', 1, '');
+ $this->assertEquals('post_visibility IN (1, 0, 2)', $sql4);
+
+ $GLOBALS['auth'] = new phpbb_acl_mock_user;
+ $GLOBALS['user'] = new phpbb_user_mock;
+ $GLOBALS['user']->data['user_id'] = 2;
+
+ $sql1 = phpbb_visibility::get_visibility_sql('topic', 1, '');
+ $this->assertEquals('(topic_visibility = 1
+ OR (topic_visibility = 2
+ AND topic_poster = 2))', $sql1);
+
+ $sql2 = phpbb_visibility::get_visibility_sql('post', 1, '');
+ $this->assertEquals('(post_visibility = 1
+ OR (post_visibility = 2
+ AND poster_id = 2))', $sql2);
+ }
+
+ public function test_get_visibility_sql_global()
+ {
+ $GLOBALS['auth'] = new phpbb_acl_mock_none;
+
+ $sql1 = phpbb_visibility::get_visibility_sql_global('topic', array(), '');
+ $this->assertEquals('(topic_visibility = 1)', $sql1);
+
+ $sql2 = phpbb_visibility::get_visibility_sql_global('post', array(), '');
+ $this->assertEquals('(post_visibility = 1)', $sql2);
+
+ $sql3 = phpbb_visibility::get_visibility_sql_global('post', range(2, 15), '');
+ $this->assertEquals('(post_visibility = 1)', $sql3);
+
+ $GLOBALS['auth'] = new phpbb_acl_mock_founder;
+
+ $sql1 = phpbb_visibility::get_visibility_sql_global('topic', array(), '');
+ $this->assertEquals('(topic_visibility = 1 OR (topic_visibility = 0
+ AND forum_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)) OR (topic_visibility = 2
+ AND forum_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)))', $sql1);
+
+ $sql2 = phpbb_visibility::get_visibility_sql_global('post', array(), '');
+ $this->assertEquals('(post_visibility = 1 OR (post_visibility = 0
+ AND forum_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)) OR (post_visibility = 2
+ AND forum_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)))', $sql2);
+
+ $sql3 = phpbb_visibility::get_visibility_sql_global('post', range(2, 14), '');
+ $this->assertEquals('(post_visibility = 1 OR (post_visibility = 0
+ AND forum_id = 1) OR (post_visibility = 2
+ AND forum_id = 1))', $sql3);
+
+ $GLOBALS['auth'] = new phpbb_acl_mock_user;
+ $GLOBALS['user'] = new phpbb_user_mock;
+ $GLOBALS['user']->data['user_id'] = 2;
+
+ $sql1 = phpbb_visibility::get_visibility_sql_global('topic', array(), '');
+ $this->assertEquals('(topic_visibility = 1 OR (topic_poster = 2
+ AND topic_visibility = 2
+ AND forum_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)))', $sql1);
+
+ $sql2 = phpbb_visibility::get_visibility_sql_global('post', array(), '');
+ $this->assertEquals('(post_visibility = 1 OR (poster_id = 2
+ AND post_visibility = 2
+ AND forum_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)))', $sql2);
+
+ $sql3 = phpbb_visibility::get_visibility_sql_global('post', range(2, 14), '');
+ $this->assertEquals('(post_visibility = 1 OR (poster_id = 2
+ AND post_visibility = 2
+ AND forum_id = 1))', $sql3);
+ }
+
+ public function test_can_soft_delete()
+ {
+ $GLOBALS['user'] = new phpbb_user_mock;
+ $GLOBALS['user']->data['user_id'] = 2;
+
+ $GLOBALS['auth'] = new phpbb_acl_mock_founder;
+ $result = phpbb_visibility::can_soft_delete(1, 4, true);
+ $this->assertEquals(true, $result);
+
+ $result = phpbb_visibility::can_soft_delete(1, 2, false);
+ $this->assertEquals(true, $result);
+
+ $GLOBALS['auth'] = new phpbb_acl_mock_none;
+ $result = phpbb_visibility::can_soft_delete(1, 4, true);
+ $this->assertEquals(false, $result);
+
+ $result = phpbb_visibility::can_soft_delete(1, 2, false);
+ $this->assertEquals(false, $result);
+
+ $GLOBALS['auth'] = new phpbb_acl_mock_user;
+ $result = phpbb_visibility::can_soft_delete(1, 4, true);
+ $this->assertEquals(false, $result);
+
+ $result = phpbb_visibility::can_soft_delete(1, 2, false);
+ $this->assertEquals(true, $result);
+
+ $result = phpbb_visibility::can_soft_delete(1, 2, true);
+ $this->assertEquals(false, $result);
+ }
+
+ public function test_can_restore()
+ {
+ $GLOBALS['user'] = new phpbb_user_mock;
+ $GLOBALS['user']->data['user_id'] = 2;
+
+ $GLOBALS['auth'] = new phpbb_acl_mock_founder;
+ $result = phpbb_visibility::can_restore(1, 4, true);
+ $this->assertEquals(true, $result);
+
+ $result = phpbb_visibility::can_restore(1, 2, false);
+ $this->assertEquals(true, $result);
+
+ $GLOBALS['auth'] = new phpbb_acl_mock_none;
+ $result = phpbb_visibility::can_restore(1, 4, true);
+ $this->assertEquals(false, $result);
+
+ $result = phpbb_visibility::can_restore(1, 2, false);
+ $this->assertEquals(false, $result);
+
+ $GLOBALS['auth'] = new phpbb_acl_mock_user;
+ $result = phpbb_visibility::can_restore(1, 4, true);
+ $this->assertEquals(false, $result);
+
+ $result = phpbb_visibility::can_restore(1, 2, false);
+ $this->assertEquals(true, $result);
+
+ $result = phpbb_visibility::can_restore(1, 2, true);
+ $this->assertEquals(false, $result);
+ }
+
+ public function test_hide_topic()
+ {
+ $GLOBALS['auth'] = new phpbb_acl_mock_founder;
+
+ $topic_row = array('topic_replies' => 3);
+ $sql_data = array();
+ phpbb_visibility::hide_topic(4, 2, $topic_row, $sql_data);
+ $this->assertEquals(
+ array(FORUMS_TABLE => 'forum_topics = forum_topics - 1, forum_posts = forum_posts - 4', USERS_TABLE => 'user_posts = user_posts - 1'),
+ $sql_data);
+ }
+
+ public function test_hide_post()
+ {
+ $GLOBALS['auth'] = new phpbb_acl_mock_founder;
+
+ $sql_data = array();
+ phpbb_visibility::hide_post(4, 111122211, $sql_data);
+ $this->assertEquals(
+ array(FORUMS_TABLE => 'forum_posts = forum_posts - 1',
+ TOPICS_TABLE => 'topic_replies = topic_replies - 1, topic_last_view_time = 111122211',
+ USERS_TABLE => 'user_posts = user_posts - 1'),
+ $sql_data);
+ }
+}
+
+//$a = new phpbb_class_visibility_test;
+//$a->test_can_soft_delete(); \ No newline at end of file