migrations/Version20250326145546.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 Version20250326145546 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Prefix deleted users email with delete-timestamp';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         $this->addSql("
  20.             UPDATE user
  21.             SET
  22.                 email = CONCAT('deleted-', UNIX_TIMESTAMP(deleted_at), '-', email),
  23.                 username = CONCAT('deleted-', UNIX_TIMESTAMP(deleted_at), '-', username)
  24.             WHERE deleted_at IS NOT NULL
  25.             AND email NOT LIKE 'deleted-%'
  26.             AND username NOT LIKE 'deleted-%'
  27.             AND discr = 'shopmanager';
  28.         ");
  29.     }
  31.     public function down(Schema $schema): void
  32.     {
  33.         $this->addSql("
  34.             UPDATE user
  35.             SET 
  36.                 email = SUBSTRING(email, LOCATE('-', email, 9) + 1),
  37.                 username = SUBSTRING(username, LOCATE('-', username, 9) + 1)
  38.             WHERE deleted_at IS NOT NULL
  39.             AND email LIKE 'deleted-%'
  40.             AND username LIKE 'deleted-%'
  41.             AND discr = 'shopmanager';
  42.         ");
  43.     }
  44. }