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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
|
<?php
/**
* SPDX-FileCopyrightText: 2017-2024 Nextcloud GmbH and Nextcloud contributors
* SPDX-FileCopyrightText: 2017 ownCloud, Inc.
* SPDX-License-Identifier: AGPL-3.0-only
*/
namespace OCA\Files_Sharing\Tests\Migration;
use OCA\Files_Sharing\Migration\SetPasswordColumn;
use OCA\Files_Sharing\Tests\TestCase;
use OCP\IConfig;
use OCP\IDBConnection;
use OCP\Migration\IOutput;
use OCP\Share\IShare;
/**
* Class SetPasswordColumnTest
*
* @group DB
*/
class SetPasswordColumnTest extends TestCase {
/** @var IDBConnection */
private $connection;
/** @var IConfig|\PHPUnit\Framework\MockObject\MockObject */
private $config;
/** @var SetPasswordColumn */
private $migration;
private $table = 'share';
protected function setUp(): void {
parent::setUp();
$this->connection = \OC::$server->getDatabaseConnection();
$this->config = $this->createMock(IConfig::class);
$this->migration = new SetPasswordColumn($this->connection, $this->config);
$this->cleanDB();
}
protected function tearDown(): void {
parent::tearDown();
$this->cleanDB();
}
private function cleanDB() {
$query = $this->connection->getQueryBuilder();
$query->delete($this->table)->execute();
}
public function testAddPasswordColumn(): void {
$this->config->expects($this->once())
->method('getAppValue')
->with('files_sharing', 'installed_version', '0.0.0')
->willReturn('1.3.0');
$shareTypes = [IShare::TYPE_USER, IShare::TYPE_GROUP, IShare::TYPE_REMOTE, IShare::TYPE_EMAIL, IShare::TYPE_LINK];
foreach ($shareTypes as $shareType) {
for ($i = 0; $i < 5; $i++) {
$query = $this->connection->getQueryBuilder();
$query->insert($this->table)
->values([
'share_type' => $query->createNamedParameter($shareType),
'share_with' => $query->createNamedParameter('shareWith'),
'uid_owner' => $query->createNamedParameter('user' . $i),
'uid_initiator' => $query->createNamedParameter(null),
'parent' => $query->createNamedParameter(0),
'item_type' => $query->createNamedParameter('file'),
'item_source' => $query->createNamedParameter('2'),
'item_target' => $query->createNamedParameter('/2'),
'file_source' => $query->createNamedParameter(2),
'file_target' => $query->createNamedParameter('/foobar'),
'permissions' => $query->createNamedParameter(31),
'stime' => $query->createNamedParameter(time()),
]);
$this->assertSame(1, $query->execute());
}
}
/** @var IOutput $output */
$output = $this->createMock(IOutput::class);
$this->migration->run($output);
$query = $this->connection->getQueryBuilder();
$query->select('*')
->from('share');
$result = $query->execute();
$allShares = $result->fetchAll();
$result->closeCursor();
foreach ($allShares as $share) {
if ((int)$share['share_type'] === IShare::TYPE_LINK) {
$this->assertNull($share['share_with']);
$this->assertSame('shareWith', $share['password']);
} else {
$this->assertSame('shareWith', $share['share_with']);
$this->assertNull($share['password']);
}
}
}
}
|
