From b72706b450dd483bc25b0fd95266a8ac6c635ae6 Mon Sep 17 00:00:00 2001 From: Joas Schilling Date: Tue, 17 May 2016 10:44:49 +0200 Subject: Move background job to PSR-4 --- apps/files_sharing/lib/DeleteOrphanedSharesJob.php | 64 ++++++++++++++++++++++ 1 file changed, 64 insertions(+) create mode 100644 apps/files_sharing/lib/DeleteOrphanedSharesJob.php (limited to 'apps/files_sharing/lib/DeleteOrphanedSharesJob.php') diff --git a/apps/files_sharing/lib/DeleteOrphanedSharesJob.php b/apps/files_sharing/lib/DeleteOrphanedSharesJob.php new file mode 100644 index 00000000000..2678d46661d --- /dev/null +++ b/apps/files_sharing/lib/DeleteOrphanedSharesJob.php @@ -0,0 +1,64 @@ + + * @author Vincent Petry + * + * @copyright Copyright (c) 2016, ownCloud, Inc. + * @license AGPL-3.0 + * + * This code is free software: you can redistribute it and/or modify + * it under the terms of the GNU Affero General Public License, version 3, + * as published by the Free Software Foundation. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Affero General Public License for more details. + * + * You should have received a copy of the GNU Affero General Public License, version 3, + * along with this program. If not, see + * + */ + +namespace OCA\Files_Sharing; + +use OC\BackgroundJob\TimedJob; + +/** + * Delete all share entries that have no matching entries in the file cache table. + */ +class DeleteOrphanedSharesJob extends TimedJob { + + /** + * Default interval in minutes + * + * @var int $defaultIntervalMin + **/ + protected $defaultIntervalMin = 15; + + /** + * sets the correct interval for this timed job + */ + public function __construct(){ + $this->interval = $this->defaultIntervalMin * 60; + } + + /** + * Makes the background job do its work + * + * @param array $argument unused argument + */ + public function run($argument) { + $connection = \OC::$server->getDatabaseConnection(); + $logger = \OC::$server->getLogger(); + + $sql = + 'DELETE FROM `*PREFIX*share` ' . + 'WHERE `item_type` in (\'file\', \'folder\') ' . + 'AND NOT EXISTS (SELECT `fileid` FROM `*PREFIX*filecache` WHERE `file_source` = `fileid`)'; + + $deletedEntries = $connection->executeUpdate($sql); + $logger->debug("$deletedEntries orphaned share(s) deleted", ['app' => 'DeleteOrphanedSharesJob']); + } + +} -- cgit v1.2.3