src/Core/System/SalesChannel/Context/Cleanup/CleanupSalesChannelContextTaskHandler.php line 36

  1. <?php declare(strict_types=1);
  3. namespace Shopware\Core\System\SalesChannel\Context\Cleanup;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Defaults;
  7. use Shopware\Core\Framework\DataAbstractionLayer\EntityRepository;
  8. use Shopware\Core\Framework\Log\Package;
  9. use Shopware\Core\Framework\MessageQueue\ScheduledTask\ScheduledTaskHandler;
  10. use Symfony\Component\Messenger\Attribute\AsMessageHandler;
  12. /**
  13.  * @internal
  14.  */
  15. #[AsMessageHandler(handles: CleanupSalesChannelContextTask::class)]
  16. #[Package('sales-channel')]
  18. final class CleanupSalesChannelContextTaskHandler extends ScheduledTaskHandler
  19. {
  20.     /**
  21.      * @internal
  22.      */
  23.     public function __construct(
  24.         EntityRepository $repository,
  25.         private readonly Connection $connection,
  26.         private readonly int $days
  27.     ) {
  28.         parent::__construct($repository);
  29.     }
  31.     public function run(): void
  32.     {
  33.         $time = new \DateTime();
  34.         $time->modify(sprintf('-%s day', $this->days));
  36.         $this->connection->executeStatement(
  37.             'DELETE FROM sales_channel_api_context WHERE updated_at <= :timestamp',
  38.             ['timestamp' => $time->format(Defaults::STORAGE_DATE_TIME_FORMAT)]
  39.         );
  40.     }
  41. }