src/Core/Framework/DataAbstractionLayer/Version/Cleanup/CleanupVersionTaskHandler.php line 36

  1. <?php declare(strict_types=1);
  3. namespace Shopware\Core\Framework\DataAbstractionLayer\Version\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: CleanupVersionTask::class)]
  16. #[Package('core')]
  17. final class CleanupVersionTaskHandler extends ScheduledTaskHandler
  18. {
  19.     /**
  20.      * @internal
  21.      */
  22.     public function __construct(
  23.         EntityRepository $repository,
  24.         private readonly Connection $connection,
  25.         private readonly int $days
  26.     ) {
  27.         parent::__construct($repository);
  28.     }
  30.     public function run(): void
  31.     {
  32.         $time = new \DateTime();
  33.         $time->modify(sprintf('-%s day', $this->days));
  35.         do {
  36.             $result = $this->connection->executeStatement(
  37.                 'DELETE FROM version WHERE created_at <= :timestamp LIMIT 1000',
  38.                 ['timestamp' => $time->format(Defaults::STORAGE_DATE_TIME_FORMAT)]
  39.             );
  40.         } while ($result > 0);
  42.         do {
  43.             $result = $this->connection->executeStatement(
  44.                 'DELETE FROM version_commit WHERE created_at <= :timestamp LIMIT 1000',
  45.                 ['timestamp' => $time->format(Defaults::STORAGE_DATE_TIME_FORMAT)]
  46.             );
  47.         } while ($result > 0);
  48.     }
  49. }