ConversationMapperTest::tearDown() - Code Metrics - owncloud/chat - Measure and Improve Code Quality continuously with Scrutinizer

ConversationMapperTest::tearDown() A
last analyzed 2016-04-23 05:25 UTC

↳ Parent: ConversationMapperTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	7
rs	9.4285
cc	1
eloc	5
nc	1
nop	0

<?php
/**
 * Created by PhpStorm.
 * User: tobis
 * Date: 8/19/14
 * Time: 1:50 PM
 */

namespace OCA\Chat\OCH\Db;

use OCA\Chat\App\Container;
use \OCA\Chat\OCH\Db\User;
use \OCA\Chat\OCH\Db\UserMapper;

class ConversationMapperTest extends \PHPUnit_Framework_TestCase {

	/**
	 * @var \OCA\Chat\App\Container
	 */
	public $container;

	/**
	 * @var \OCA\Chat\OCH\Db\ConversationMapper
	 */
	public $conversationMapper;

	/**
	 * @var \OCA\Chat\OCH\Db\UserMapper
	 */
	public $userMapper;



	public function setUp(){
		$this->container = new Container();
		$this->conversationMapper = $this->container->query('ConversationMapper');
		$this->userMapper = $this->container->query('UserMapper');
	}

	public function convProvider(){
		$conv1 = new Conversation();
		$conv1->setConversationId(md5(time()));

		$conv2 = new Conversation();
		$conv2->setConversationId(md5(time() - 3434));


		$conv3 = new Conversation();
		$conv3->setConversationId(md5(time() - 3432452345334));


		$conv4 = new Conversation();
		$conv4->setConversationId(md5(time() - 23455854634));

		return array(
			array(
				$conv1,
				$conv2,
				$conv3,
				$conv4
			)
		);
	}

	/**
	 * @dataProvider convProvider
	 * @param $conv1 \OCA\Chat\OCH\Db\Conversation;
	 * @param $conv2 \OCA\Chat\OCH\Db\Conversation
	 */
	public function testFindByConversationId($conv1, $conv2){
		$this->conversationMapper->insert($conv1);
		$this->conversationMapper->insert($conv2);

		$result1 = $this->conversationMapper->findByConversationId($conv1->getConversationId());
		$result2 = $this->conversationMapper->findByConversationId($conv2->getConversationId());

		$this->assertEquals(
			$conv1->getConversationId(),
			$result1->getConversationId()
		);
		$this->assertEquals(
			$conv1->getId(),
			$result1->getId()
		);
		$this->assertEquals(
			$conv2->getConversationId(),
			$result2->getConversationId()
		);
		$this->assertEquals(
			$conv2->getId(),
			$result2->getId()
		);
	}
	/**
	 * This also tests existsByConvId
	 * @dataProvider convProvider
	 * @param $conv1 \OCA\Chat\OCH\Db\Conversation
	 * @param $conv2 \OCA\Chat\OCH\Db\Conversation
	 * @param $conv3 \OCA\Chat\OCH\Db\Conversation
	 * @param $conv4 \OCA\Chat\OCH\Db\Conversation
	 */
	public function testDelete($conv1, $conv2, $conv3, $conv4){
		$this->conversationMapper->insert($conv1);
		$this->conversationMapper->insert($conv2);
		$this->conversationMapper->insert($conv3);
		$this->conversationMapper->insert($conv4);

		// Delete 2 conversation
		$this->conversationMapper->deleteConversation($conv1->getConversationId());
		$this->conversationMapper->deleteConversation($conv4->getConversationId());

		$this->assertEquals(
			false,
			$this->conversationMapper->existsByConvId($conv1->getConversationId())
		);
		$this->assertEquals(
			false,
			$this->conversationMapper->existsByConvId($conv4->getConversationId())
		);
		$this->assertEquals(
			true,
			$this->conversationMapper->existsByConvId($conv2->getConversationId())
		);
		$this->assertEquals(
			true,
			$this->conversationMapper->existsByConvId($conv3->getConversationId())
		);
	}

	public function existsByUserProvider(){
		$conv1Id = md5(time());
		$conv1 = new Conversation();
		$conv1->setConversationId($conv1Id);

		$user1InConv1 = new User();
		$user1InConv1->setConversationId($conv1Id);
		$user1InConv1->setUser('foo');
		$user1InConv1->setJoined(time() - 53353);

		$user2InConv1 = new User();
		$user2InConv1->setConversationId($conv1Id);
		$user2InConv1->setUser('bar');
		$user2InConv1->setJoined(time() - 53353);

		$conv2Id = md5(time() - 3434);
		$conv2 = new Conversation();
		$conv2->setConversationId($conv2Id);

		$user1InConv2 = new User();
		$user1InConv2->setConversationId($conv2Id);
		$user1InConv2->setUser('foo');
		$user1InConv2->setJoined(time() - 53353);

		$user2InConv2 = new User();
		$user2InConv2->setConversationId($conv2Id);
		$user2InConv2->setUser('bar');
		$user2InConv2->setJoined(time() - 53353);

		$user3InConv2 = new User();
		$user3InConv2->setConversationId($conv2Id);
		$user3InConv2->setUser('foobar');
		$user3InConv2->setJoined(time() - 53353);

		return array(
			array(
				$conv1,
				$user1InConv1,
				$user2InConv1,
				$conv2,
				$user1InConv2,
				$user2InConv2,
				$user3InConv2
			)
		);
	}

	/**
	 * @dataProvider existsByUserProvider
	 * @param $conv1 \OCA\Chat\OCH\Db\Conversation
	 * @param $user1InConv1 \OCA\Chat\OCH\Db\User
	 * @param $user2InConv1 \OCA\Chat\OCH\Db\User
	 * @param $conv2 \OCA\Chat\OCH\Db\Conversation
	 * @param $user1InConv2 \OCA\Chat\OCH\Db\User
	 * @param $user2InConv2 \OCA\Chat\OCH\Db\User
	 * @param $user3InConv2 \OCA\Chat\OCH\Db\User
	 */
	public function testExistsByUsers(
		$conv1,
		$user1InConv1,
		$user2InConv1,
		$conv2,
		$user1InConv2,
		$user2InConv2,
		$user3InConv2
	){
		// Insert dummy data
		$this->conversationMapper->insert($conv1);
		$this->userMapper->insert($user1InConv1);
		$this->userMapper->insert($user2InConv1);
		$this->conversationMapper->insert($conv2);
		$this->userMapper->insert($user1InConv2);
		$this->userMapper->insert($user2InConv2);
		$this->userMapper->insert($user3InConv2);

		// Test if we can find $conv1, by providing $user1Inconv1 and $user2InConv1
		$result1 = $this->conversationMapper->existsByUsers(array(
			$user1InConv1->getUser(),
			$user2InConv1->getUser()
		));

		$this->assertEquals($conv1->getConversationId(), $result1['conv_id']);

		// Test if we can find $conv2, by providing $user1Inconv2 and $user2InConv2 $user3InConv2
		$result2 = $this->conversationMapper->existsByUsers(array(
			$user1InConv2->getUser(),
			$user2InConv2->getUser(),
			$user3InConv2->getUser(),
		));

		$this->assertEquals($conv2->getConversationId(), $result2['conv_id']);


	}



	/**
	 * Remove all records from the table so future test can run without problems
	 */
	public function tearDown(){
		$query = \OCP\DB::prepare('DELETE FROM `' . $this->conversationMapper->getTableName() . '`');
		$query->execute(array());

		$query = \OCP\DB::prepare('DELETE FROM `' . $this->userMapper->getTableName() . '`');
		$query->execute(array());
 	}



}

1			<?php
2			/**
3			* Created by PhpStorm.
4			* User: tobis
5			* Date: 8/19/14
6			* Time: 1:50 PM
7			*/
8
9			namespace OCA\Chat\OCH\Db;
10
11			use OCA\Chat\App\Container;
12			use \OCA\Chat\OCH\Db\User;
13			use \OCA\Chat\OCH\Db\UserMapper;
14
15			class ConversationMapperTest extends \PHPUnit_Framework_TestCase {
16
17			/**
18			* @var \OCA\Chat\App\Container
19			*/
20			public $container;
21
22			/**
23			* @var \OCA\Chat\OCH\Db\ConversationMapper
24			*/
25			public $conversationMapper;
26
27			/**
28			* @var \OCA\Chat\OCH\Db\UserMapper
29			*/
30			public $userMapper;
31
32
33
34			public function setUp(){
35			$this->container = new Container();
36			$this->conversationMapper = $this->container->query('ConversationMapper');
37			$this->userMapper = $this->container->query('UserMapper');
38			}
39
40			public function convProvider(){
41			$conv1 = new Conversation();
42			$conv1->setConversationId(md5(time()));
43
44			$conv2 = new Conversation();
45			$conv2->setConversationId(md5(time() - 3434));
46
47
48			$conv3 = new Conversation();
49			$conv3->setConversationId(md5(time() - 3432452345334));
50
51
52			$conv4 = new Conversation();
53			$conv4->setConversationId(md5(time() - 23455854634));
54
55			return array(
56			array(
57			$conv1,
58			$conv2,
59			$conv3,
60			$conv4
61			)
62			);
63			}
64
65			/**
66			* @dataProvider convProvider
67			* @param $conv1 \OCA\Chat\OCH\Db\Conversation;
68			* @param $conv2 \OCA\Chat\OCH\Db\Conversation
69			*/
70			public function testFindByConversationId($conv1, $conv2){
71			$this->conversationMapper->insert($conv1);
72			$this->conversationMapper->insert($conv2);
73
74			$result1 = $this->conversationMapper->findByConversationId($conv1->getConversationId());
75			$result2 = $this->conversationMapper->findByConversationId($conv2->getConversationId());
76
77			$this->assertEquals(
78			$conv1->getConversationId(),
79			$result1->getConversationId()
80			);
81			$this->assertEquals(
82			$conv1->getId(),
83			$result1->getId()
84			);
85			$this->assertEquals(
86			$conv2->getConversationId(),
87			$result2->getConversationId()
88			);
89			$this->assertEquals(
90			$conv2->getId(),
91			$result2->getId()
92			);
93			}
94			/**
95			* This also tests existsByConvId
96			* @dataProvider convProvider
97			* @param $conv1 \OCA\Chat\OCH\Db\Conversation
98			* @param $conv2 \OCA\Chat\OCH\Db\Conversation
99			* @param $conv3 \OCA\Chat\OCH\Db\Conversation
100			* @param $conv4 \OCA\Chat\OCH\Db\Conversation
101			*/
102			public function testDelete($conv1, $conv2, $conv3, $conv4){
103			$this->conversationMapper->insert($conv1);
104			$this->conversationMapper->insert($conv2);
105			$this->conversationMapper->insert($conv3);
106			$this->conversationMapper->insert($conv4);
107
108			// Delete 2 conversation
109			$this->conversationMapper->deleteConversation($conv1->getConversationId());
110			$this->conversationMapper->deleteConversation($conv4->getConversationId());
111
112			$this->assertEquals(
113			false,
114			$this->conversationMapper->existsByConvId($conv1->getConversationId())
115			);
116			$this->assertEquals(
117			false,
118			$this->conversationMapper->existsByConvId($conv4->getConversationId())
119			);
120			$this->assertEquals(
121			true,
122			$this->conversationMapper->existsByConvId($conv2->getConversationId())
123			);
124			$this->assertEquals(
125			true,
126			$this->conversationMapper->existsByConvId($conv3->getConversationId())
127			);
128			}
129
130			public function existsByUserProvider(){
131			$conv1Id = md5(time());
132			$conv1 = new Conversation();
133			$conv1->setConversationId($conv1Id);
134
135			$user1InConv1 = new User();
136			$user1InConv1->setConversationId($conv1Id);
137			$user1InConv1->setUser('foo');
138			$user1InConv1->setJoined(time() - 53353);
139
140			$user2InConv1 = new User();
141			$user2InConv1->setConversationId($conv1Id);
142			$user2InConv1->setUser('bar');
143			$user2InConv1->setJoined(time() - 53353);
144
145			$conv2Id = md5(time() - 3434);
146			$conv2 = new Conversation();
147			$conv2->setConversationId($conv2Id);
148
149			$user1InConv2 = new User();
150			$user1InConv2->setConversationId($conv2Id);
151			$user1InConv2->setUser('foo');
152			$user1InConv2->setJoined(time() - 53353);
153
154			$user2InConv2 = new User();
155			$user2InConv2->setConversationId($conv2Id);
156			$user2InConv2->setUser('bar');
157			$user2InConv2->setJoined(time() - 53353);
158
159			$user3InConv2 = new User();
160			$user3InConv2->setConversationId($conv2Id);
161			$user3InConv2->setUser('foobar');
162			$user3InConv2->setJoined(time() - 53353);
163
164			return array(
165			array(
166			$conv1,
167			$user1InConv1,
168			$user2InConv1,
169			$conv2,
170			$user1InConv2,
171			$user2InConv2,
172			$user3InConv2
173			)
174			);
175			}
176
177			/**
178			* @dataProvider existsByUserProvider
179			* @param $conv1 \OCA\Chat\OCH\Db\Conversation
180			* @param $user1InConv1 \OCA\Chat\OCH\Db\User
181			* @param $user2InConv1 \OCA\Chat\OCH\Db\User
182			* @param $conv2 \OCA\Chat\OCH\Db\Conversation
183			* @param $user1InConv2 \OCA\Chat\OCH\Db\User
184			* @param $user2InConv2 \OCA\Chat\OCH\Db\User
185			* @param $user3InConv2 \OCA\Chat\OCH\Db\User
186			*/
187			public function testExistsByUsers(
188			$conv1,
189			$user1InConv1,
190			$user2InConv1,
191			$conv2,
192			$user1InConv2,
193			$user2InConv2,
194			$user3InConv2
195			){
196			// Insert dummy data
197			$this->conversationMapper->insert($conv1);
198			$this->userMapper->insert($user1InConv1);
199			$this->userMapper->insert($user2InConv1);
200			$this->conversationMapper->insert($conv2);
201			$this->userMapper->insert($user1InConv2);
202			$this->userMapper->insert($user2InConv2);
203			$this->userMapper->insert($user3InConv2);
204
205			// Test if we can find $conv1, by providing $user1Inconv1 and $user2InConv1
206			$result1 = $this->conversationMapper->existsByUsers(array(
207			$user1InConv1->getUser(),
208			$user2InConv1->getUser()
209			));
210
211			$this->assertEquals($conv1->getConversationId(), $result1['conv_id']);
212
213			// Test if we can find $conv2, by providing $user1Inconv2 and $user2InConv2 $user3InConv2
214			$result2 = $this->conversationMapper->existsByUsers(array(
215			$user1InConv2->getUser(),
216			$user2InConv2->getUser(),
217			$user3InConv2->getUser(),
218			));
219
220			$this->assertEquals($conv2->getConversationId(), $result2['conv_id']);
221
222
223			}
224
225
226
227			/**
228			* Remove all records from the table so future test can run without problems
229			*/
230			public function tearDown(){
231			$query = \OCP\DB::prepare('DELETE FROM `' . $this->conversationMapper->getTableName() . '`');
232			$query->execute(array());
233
234			$query = \OCP\DB::prepare('DELETE FROM `' . $this->userMapper->getTableName() . '`');
235			$query->execute(array());
236			}
237
238
239
240			}

owncloud / chat

ConversationMapperTest::tearDown() A last analyzed 2016-04-23 05:25 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

ConversationMapperTest::tearDown() A
last analyzed 2016-04-23 05:25 UTC