1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
<?php
use JsonApi\Routes\Messages\MessageDelete;
class MessagesDeleteTest extends \Codeception\Test\Unit
{
/**
* @var \UnitTester
*/
protected $tester;
protected function _before()
{
\DBManager::getInstance()->setConnection('studip', $this->getModule('\\Helper\\StudipDb')->dbh);
}
protected function _after()
{
}
// tests
public function testDeleteMessage()
{
$credentials = $this->tester->getCredentialsForTestAutor();
$recipients = [$this->tester->getCredentialsForTestDozent()['username']];
$this->tester->assertSame(0, $this->countMessages($credentials['id'], false));
$message = \Message::send($credentials['id'], $recipients, 'empty subject', 'empty message');
$this->tester->assertSame(1, $this->countMessages($credentials['id'], false));
$response = $this->deleteMessage($credentials, $message);
$this->tester->assertSame(204, $response->getStatusCode());
$this->tester->assertSame(0, $this->countMessages($credentials['id'], false));
}
//helpers
private function countMessages($userId, $received)
{
$query = 'SELECT COUNT(*)
FROM message_user
WHERE snd_rec = ? AND user_id = ? AND deleted = 0
ORDER BY mkdate DESC';
$statement = \DBManager::get()->prepare($query);
$statement->execute([$received ? 'rec' : 'snd', $userId]);
return (int) $statement->fetch(\PDO::FETCH_COLUMN, 0);
}
private function deleteMessage($credentials, \Message $message)
{
return $this->tester->sendMockRequest(
$this->tester->createApp($credentials, 'delete', '/messages/{id}', MessageDelete::class),
$this->tester->createRequestBuilder($credentials)
->setUri('/messages/'.($message->id))
->delete()
->getRequest()
);
}
}
|
