migrations/Version20251216160119.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. final class Version20251216160119 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return "Adds missing translations for categories based on the franchise's Locales.";
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         $this->addSql('
  20.                 INSERT INTO category_translation (
  21.                     category_id,
  22.                     locale_id,
  23.                     name,
  24.                     description,
  25.                     created_at,
  26.                     updated_at
  27.                 )
  28.                 SELECT
  29.                     c.id AS category_id,
  30.                     fl.locale_id,
  31.                     CONCAT("cat_", c.id) AS name,
  32.                     NULL AS description,
  33.                     c.created_at,
  34.                     c.updated_at
  35.                 FROM category c
  36.                 INNER JOIN shop s ON s.id = c.shop_id
  37.                 INNER JOIN franchise f ON f.id = s.franchise_id
  38.                 INNER JOIN franchise_locale fl ON fl.franchise_id = f.id
  39.                 LEFT JOIN category_translation ct
  40.                     ON ct.category_id = c.id
  41.                 WHERE ct.id IS NULL;
  42.         ');
  43.     }
  44. }