1 files changed, 148 insertions, 0 deletions
diff --git a/apps/files_sharing/tests/DeleteOrphanedSharesJobTest.php b/apps/files_sharing/tests/DeleteOrphanedSharesJobTest.php
new file mode 100644
index 00000000000..c245d157151
--- /dev/null
+++ b/apps/files_sharing/tests/DeleteOrphanedSharesJobTest.php
@@ -0,0 +1,148 @@
+<?php
+
+/**
+ * SPDX-FileCopyrightText: 2017-2024 Nextcloud GmbH and Nextcloud contributors
+ * SPDX-FileCopyrightText: 2016 ownCloud, Inc.
+ * SPDX-License-Identifier: AGPL-3.0-only
+ */
+namespace OCA\Files_Sharing\Tests;
+
+use OC\Files\Filesystem;
+use OC\SystemConfig;
+use OCA\Files_Sharing\DeleteOrphanedSharesJob;
+use OCP\App\IAppManager;
+use OCP\Constants;
+use OCP\IDBConnection;
+use OCP\IUserManager;
+use OCP\Server;
+use OCP\Share\IShare;
+
+/**
+ * Class DeleteOrphanedSharesJobTest
+ *
+ * @group DB
+ *
+ * @package OCA\Files_Sharing\Tests
+ */
+class DeleteOrphanedSharesJobTest extends \Test\TestCase {
+	/**
+	 * @var bool
+	 */
+	private static $trashBinStatus;
+
+	/**
+	 * @var DeleteOrphanedSharesJob
+	 */
+	private $job;
+
+	/**
+	 * @var IDBConnection
+	 */
+	private $connection;
+
+	/**
+	 * @var string
+	 */
+	private $user1;
+
+	/**
+	 * @var string
+	 */
+	private $user2;
+
+	public static function setUpBeforeClass(): void {
+		$appManager = Server::get(IAppManager::class);
+		self::$trashBinStatus = $appManager->isEnabledForUser('files_trashbin');
+		$appManager->disableApp('files_trashbin');
+
+		// just in case...
+		Filesystem::getLoader()->removeStorageWrapper('oc_trashbin');
+	}
+
+	public static function tearDownAfterClass(): void {
+		if (self::$trashBinStatus) {
+			Server::get(IAppManager::class)->enableApp('files_trashbin');
+		}
+	}
+
+	protected function setUp(): void {
+		parent::setUp();
+
+		$this->connection = Server::get(IDBConnection::class);
+		// clear occasional leftover shares from other tests
+		$this->connection->executeUpdate('DELETE FROM `*PREFIX*share`');
+
+		$this->user1 = $this->getUniqueID('user1_');
+		$this->user2 = $this->getUniqueID('user2_');
+
+		$userManager = Server::get(IUserManager::class);
+		$userManager->createUser($this->user1, 'pass');
+		$userManager->createUser($this->user2, 'pass');
+
+		\OC::registerShareHooks(Server::get(SystemConfig::class));
+
+		$this->job = Server::get(DeleteOrphanedSharesJob::class);
+	}
+
+	protected function tearDown(): void {
+		$this->connection->executeUpdate('DELETE FROM `*PREFIX*share`');
+
+		$userManager = Server::get(IUserManager::class);
+		$user1 = $userManager->get($this->user1);
+		if ($user1) {
+			$user1->delete();
+		}
+		$user2 = $userManager->get($this->user2);
+		if ($user2) {
+			$user2->delete();
+		}
+
+		$this->logout();
+
+		parent::tearDown();
+	}
+
+	private function getShares() {
+		$shares = [];
+		$result = $this->connection->executeQuery('SELECT * FROM `*PREFIX*share`');
+		while ($row = $result->fetch()) {
+			$shares[] = $row;
+		}
+		$result->closeCursor();
+		return $shares;
+	}
+
+	/**
+	 * Test clearing orphaned shares
+	 */
+	public function testClearShares(): void {
+		$this->loginAsUser($this->user1);
+
+		$user1Folder = \OC::$server->getUserFolder($this->user1);
+		$testFolder = $user1Folder->newFolder('test');
+		$testSubFolder = $testFolder->newFolder('sub');
+
+		$shareManager = Server::get(\OCP\Share\IManager::class);
+		$share = $shareManager->newShare();
+
+		$share->setNode($testSubFolder)
+			->setShareType(IShare::TYPE_USER)
+			->setPermissions(Constants::PERMISSION_READ)
+			->setSharedWith($this->user2)
+			->setSharedBy($this->user1);
+
+		$shareManager->createShare($share);
+
+		$this->assertCount(1, $this->getShares());
+
+		$this->job->run([]);
+
+		$this->assertCount(1, $this->getShares(), 'Linked shares not deleted');
+
+		$testFolder->delete();
+
+		$this->job->run([]);
+
+		$this->assertCount(0, $this->getShares(), 'Orphaned shares deleted');
+	}
+}