migrations/Version20251023174013.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 Version20251023174013 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql('
  23.             UPDATE tourapp.email_template
  24.             SET variables = COALESCE(variables::jsonb, \'{}\'::jsonb) || 
  25.                 \'{"text_1_agreement": {"description": "Dodatkowa treść umowy", "value": null, "type": "variable"}}\'::jsonb
  26.             WHERE email_template_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 13);
  27.         ');
  30.         $this->addSql('
  31.             UPDATE tourapp.email_template
  32.             SET variables = (
  33.                 SELECT (
  34.                     (SELECT json_object_agg(key, val ORDER BY sort_order, key)
  35.                      FROM (
  36.                          SELECT 
  37.                              key,
  38.                              CASE 
  39.                                  WHEN jsonb_exists(value, \'type\') THEN value
  40.                                  ELSE jsonb_set(value, \'{type}\', \'"variable"\'::jsonb)
  41.                              END AS val,
  42.                              CASE 
  43.                                  WHEN (value->>\'type\') = \'variable\' OR NOT jsonb_exists(value, \'type\') THEN 1
  44.                                  WHEN (value->>\'type\') = \'condition\' THEN 3
  45.                                  ELSE 2
  46.                              END AS sort_order
  47.                          FROM jsonb_each(variables::jsonb)
  48.                      ) s
  49.                     )::json
  50.                 )
  51.             )
  52.             WHERE variables IS NOT NULL
  53.               AND jsonb_typeof(variables::jsonb) = \'object\'
  54.               AND variables::jsonb != \'{}\'::jsonb;
  55.         ');
  56.     }
  58.     public function down(Schema $schema): void
  59.     {
  61.     }
  62. }