migrations/Version20220902142443.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20220902142443 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // this up() migration is auto-generated, please modify it to your needs
  23.         $this->addSql('ALTER TABLE scans ADD needs_retry TINYINT(1) DEFAULT 0 NOT NULL');
  24.         $this->addSql('ALTER TABLE targets ADD retry_count INT DEFAULT 0 NOT NULL');
  25.         $this->addSql('
  26.             UPDATE scans us, (
  27.                 SELECT
  28.                     t.version,
  29.                     sq.id,
  30.                     sq.status
  31.                 FROM
  32.                     targets t
  33.                 JOIN (  
  34.                     SELECT
  35.                         s.id,
  36.                         s.target_id,
  37.                         s.status
  38.                     FROM
  39.                         scans s
  40.                     WHERE
  41.                         s.updated = (
  42.                             SELECT
  43.                                 MAX(updated)
  44.                             FROM
  45.                                 scans ss
  46.                             WHERE
  47.                                 ss.target_id = s.target_id
  48.                         )
  49.                     GROUP BY
  50.                         s.target_id
  51.                 ) sq
  52.                 ON sq.target_id = t.id
  53.             ) uq
  54.             SET us.target_version = uq.version, us.needs_retry = IF(uq.status = 2, 1, 0)
  55.             WHERE us.id = uq.id
  56.         ');
  57.     }
  59.     public function down(Schema $schema): void
  60.     {
  61.         // this down() migration is auto-generated, please modify it to your needs
  62.         $this->addSql('ALTER TABLE scans DROP needs_retry');
  63.         $this->addSql('ALTER TABLE targets DROP retry_count');
  64.     }
  65. }