mirror of
https://github.com/nextcloud/server.git
synced 2025-05-03 13:30:32 +00:00
1f0241fdfe
to improve performance by using the db index Signed-off-by: Marcel Klehr <mklehr@gmx.net>
83 lines
2.1 KiB
PHP
83 lines
2.1 KiB
PHP
<?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;
|
|
|
|
use OCP\AppFramework\Utility\ITimeFactory;
|
|
use OCP\BackgroundJob\TimedJob;
|
|
use OCP\DB\QueryBuilder\IQueryBuilder;
|
|
use OCP\IDBConnection;
|
|
use OCP\Share\Exceptions\ShareNotFound;
|
|
use OCP\Share\IManager;
|
|
use OCP\Share\IShare;
|
|
|
|
/**
|
|
* Delete all shares that are expired
|
|
*/
|
|
class ExpireSharesJob extends TimedJob {
|
|
|
|
/** @var IManager */
|
|
private $shareManager;
|
|
|
|
/** @var IDBConnection */
|
|
private $db;
|
|
|
|
public function __construct(ITimeFactory $time, IManager $shareManager, IDBConnection $db) {
|
|
$this->shareManager = $shareManager;
|
|
$this->db = $db;
|
|
|
|
parent::__construct($time);
|
|
|
|
// Run once a day
|
|
$this->setInterval(24 * 60 * 60);
|
|
$this->setTimeSensitivity(self::TIME_INSENSITIVE);
|
|
}
|
|
|
|
|
|
/**
|
|
* Makes the background job do its work
|
|
*
|
|
* @param array $argument unused argument
|
|
*/
|
|
public function run($argument) {
|
|
//Current time
|
|
$now = new \DateTime();
|
|
$now = $now->format('Y-m-d H:i:s');
|
|
|
|
/*
|
|
* Expire file link shares only (for now)
|
|
*/
|
|
$qb = $this->db->getQueryBuilder();
|
|
$qb->select('id', 'share_type')
|
|
->from('share')
|
|
->where(
|
|
$qb->expr()->andX(
|
|
$qb->expr()->in('share_type', $qb->createNamedParameter([IShare::TYPE_LINK, IShare::TYPE_EMAIL], IQueryBuilder::PARAM_INT_ARRAY)),
|
|
$qb->expr()->lte('expiration', $qb->expr()->literal($now)),
|
|
$qb->expr()->in('item_type', $qb->createNamedParameter(['file', 'folder'], IQueryBuilder::PARAM_STR_ARRAY))
|
|
)
|
|
);
|
|
|
|
$shares = $qb->executeQuery();
|
|
while ($share = $shares->fetch()) {
|
|
if ((int)$share['share_type'] === IShare::TYPE_LINK) {
|
|
$id = 'ocinternal';
|
|
} elseif ((int)$share['share_type'] === IShare::TYPE_EMAIL) {
|
|
$id = 'ocMailShare';
|
|
}
|
|
|
|
$id .= ':' . $share['id'];
|
|
|
|
try {
|
|
$share = $this->shareManager->getShareById($id);
|
|
$this->shareManager->deleteShare($share);
|
|
} catch (ShareNotFound $e) {
|
|
// Normally the share gets automatically expired on fetching it
|
|
}
|
|
}
|
|
$shares->closeCursor();
|
|
}
|
|
}
|