migrations/Version20230327133101.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\DBAL\Types\Types;
  9. use Doctrine\Migrations\AbstractMigration;
  11. /** Renaming column additional_line to street_line2 in two migrations */
  12. final class Version20230327133101 extends AbstractMigration
  13. {
  14.     public function getDescription(): string
  15.     {
  16.         return 'Update additionalLine field to streetLine2 the address table';
  17.     }
  19.     public function up(Schema $schema): void
  20.     {
  21.         $this->skipIf(
  22.             false === $schema->getTable('address')->hasColumn('additional_line'),
  23.             'The street is already removed from the address table!'
  24.         );
  26.         $schema->getTable('address')->dropColumn('additional_line');
  27.     }
  29.     public function down(Schema $schema): void
  30.     {
  31.         $this->skipIf(
  32.             true === $schema->getTable('address')->hasColumn('additional_line'),
  33.             'The additional_line is already set in the address table!'
  34.         );
  35.         $schema->getTable('address')
  36.             ->addColumn('additional_line', Types::STRING, [
  37.                 'length' => 255,
  38.             ])->setNotnull(false);
  39.     }
  41.     public function postDown(Schema $schema): void
  42.     {
  43.         $this->connection->executeQuery('UPDATE address SET additional_line=street_line2');
  44.     }
  45. }