migrations/Version20230411053213.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 Version20230411053213 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         //MANUFACTURER ADDRESS
  23.         $this->addSql("CREATE PROCEDURE ProcessManufacturerAddresses()
  24.            BEGIN
  25.                DECLARE done INT DEFAULT 0;
  26.                DECLARE manufacturerAddressId INT;
  27.                DECLARE line1 TEXT;
  28.                DECLARE addressCity VARCHAR(255);
  29.                DECLARE addressZip VARCHAR(40);
  30.                DECLARE addressCountry VARCHAR(10);
  31.                DECLARE details VARCHAR(255);
  32.                DECLARE addressType VARCHAR(255);
  33.                DECLARE newUuid CHAR(36);
  34.                DECLARE newAddressId INT;
  35.                 DECLARE updatedAddressType VARCHAR(40);
  37.                DECLARE cur CURSOR FOR
  38.                    SELECT
  39.                        id,
  40.                        address_old as line1,
  41.                        city as addressCity,
  42.                        zip as addressZip,
  43.                        COALESCE(country, 'Unknown') as addressCountry,
  44.                        district as details,
  45.                        type as addressType,
  46.                        UUID() AS new_uuid
  47.                    FROM manufacturer_address;
  49.                DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
  51.                OPEN cur;
  53.                read_loop: LOOP
  54.                    FETCH cur INTO manufacturerAddressId, line1, addressCity, addressZip, addressCountry, details, addressType, newUuid;
  56.                    IF done THEN
  57.                        LEAVE read_loop;
  58.                    END IF;
  59.                    
  60.                            -- Convert manufacturer address type to address type
  61.                     CASE addressType
  62.                         WHEN 'manufacturing' THEN
  63.                             SET updatedAddressType = 'address_type.manufacturing';
  64.                         WHEN 'office' THEN
  65.                             SET updatedAddressType = 'address_type.legal';
  66.                         WHEN 'warehouse' THEN
  67.                             SET updatedAddressType = 'address_type.warehouse';
  68.                         ELSE
  69.                             SET updatedAddressType = NULL;
  70.                     END CASE;
  72.                    INSERT INTO address (line1, city, zip, country, details, type, uuid)
  73.                    VALUES (
  74.                        line1,
  75.                        addressCity,
  76.                        addressZip,
  77.                        addressCountry,
  78.                        details,
  79.                        updatedAddressType,
  80.                        newUuid
  81.                    );
  83.                    SET newAddressId = LAST_INSERT_ID();
  85.                    UPDATE manufacturer_address
  86.                    SET address_id = newAddressId
  87.                    WHERE id = manufacturerAddressId;
  88.                END LOOP;
  90.                CLOSE cur;
  91.            END;");
  92.         $this->addSql("CALL ProcessManufacturerAddresses();");
  93.         $this->addSql("DROP PROCEDURE ProcessManufacturerAddresses");
  94.     }
  96.     public function down(Schema $schema): void
  97.     {
  98.         // this down() migration is auto-generated, please modify it to your needs
  99.     }
  100. }