migrations/Version20251023010406.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 Version20251023010406 extends AbstractMigration
  14. {
  15.     public const WIDGET_ID_1 = 44; // shared-unread-messages
  16.     public const WIDGET_ID_2 = 45; // shared-unread-feeds
  17.     public const WIDGET_ID_3 = 46; // shared-unread-streams
  18.     public const WIDGET_ID_4 = 47; // shared-unread-projects
  19.     public const WIDGET_ID_5 = 48; // shared-open-issues
  21.     public function getDescription(): string
  22.     {
  23.         return '';
  24.     }
  26.     public function up(Schema $schema): void
  27.     {
  28.         // this up() migration is auto-generated, please modify it to your needs
  29.         $this->addSql('
  30.             UPDATE widget
  31.              SET category = "Cards",
  32.                  token = REPLACE(token, "shared-", "cards-")
  33.              WHERE category = "Shared"
  34.         ');
  36.         /** @var string $idList */
  37.         $idList = $this->idListSql();
  39.         $this->addSql(sprintf(
  40.             '
  41.                 UPDATE widget
  42.                 SET name = REPLACE(name, "Sales ", "")
  43.                 WHERE id IN (%s)
  44.             ',
  45.             $idList
  46.         ));
  48.         $this->addSql(sprintf('UPDATE widget SET name = REPLACE(name, "Feeds", "Buzz") WHERE id = %d', WIDGET_ID_2));
  49.     }
  51.     public function down(Schema $schema): void
  52.     {
  53.         // this down() migration is auto-generated, please modify it to your needs
  54.         $this->addSql('
  55.             UPDATE widget
  56.              SET category = "Shared",
  57.                  token = REPLACE(token, "cards-", "shared-")
  58.              WHERE category = "Cards"
  59.         ');
  61.         /** @var string $idList */
  62.         $idList = $this->idListSql();
  64.         $this->addSql(sprintf(
  65.             '
  66.                 UPDATE widget
  67.                 SET name = CONCAT("Sales ", name)
  68.                 WHERE id IN (%s)
  69.             ',
  70.             $idList
  71.         ));
  73.         $this->addSql(sprintf('UPDATE widget SET name = REPLACE(name, "Buzz", "Feeds") WHERE id = %d', WIDGET_ID_2));
  74.     }
  76.     /**
  77.      * @return string
  78.      */
  79.     private function idListSql(): string
  80.     {
  81.         return implode(',', array_map('intval', [
  82.             self::WIDGET_ID_1,
  83.             self::WIDGET_ID_2,
  84.             self::WIDGET_ID_3,
  85.             self::WIDGET_ID_4,
  86.             self::WIDGET_ID_5,
  87.         ]));
  88.     }
  89. }