typo3/sysext/workspaces/Classes/Task/CleanupPreviewLinkTask.php

   1 <?php
   2 namespace TYPO3\CMS\Workspaces\Task;
   3
   4 /*
   5  * This file is part of the TYPO3 CMS project.
   6  *
   7  * It is free software; you can redistribute it and/or modify it under
   8  * the terms of the GNU General Public License, either version 2
   9  * of the License, or any later version.
  10  *
  11  * For the full copyright and license information, please read the
  12  * LICENSE.txt file that was distributed with this source code.
  13  *
  14  * The TYPO3 project - inspiring people to share!
  15  */
  16 use TYPO3\CMS\Core\Database\ConnectionPool;
  17 use TYPO3\CMS\Core\Utility\GeneralUtility;
  18
  19 /**
  20  * This class provides a task to cleanup ol preview links.
  21  * @deprecated since TYPO3 v9, will be removed in TYPO3 v10.0.
  22  */
  23 class CleanupPreviewLinkTask extends \TYPO3\CMS\Scheduler\Task\AbstractTask
  24 {
  25     /**
  26      * Cleanup old preview links.
  27      * endtime < $GLOBALS['EXEC_TIME']
  28      *
  29      * @return bool
  30      */
  31     public function execute()
  32     {
  33         trigger_error('This scheduler task is not in use anymore, please re-create the task within TYPO3 Scheduler by using the symfony command "Cleanup Preview Links".', E_USER_DEPRECATED);
  34         $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('sys_preview');
  35         $queryBuilder
  36             ->delete('sys_preview')
  37             ->where(
  38                 $queryBuilder->expr()->lt(
  39                     'endtime',
  40                     $queryBuilder->createNamedParameter($GLOBALS['EXEC_TIME'], \PDO::PARAM_INT)
  41                 )
  42             )
  43             ->execute();
  44
  45         return true;
  46     }
  47 }