migrations/Version20230327115100.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 street to street_line in two migrations */
  12. final class Version20230327115100 extends AbstractMigration
  13. {
  14.     public function getDescription(): string
  15.     {
  16.         return 'Update street field to streetLine the address table';
  17.     }
  19.     public function up(Schema $schema): void
  20.     {
  21.         $this->skipIf(
  22.             true === $schema->getTable('address')->hasColumn('street_line'),
  23.             'The street_line field already set in the address table!'
  24.         );
  26.         $schema->getTable('address')
  27.             ->addColumn('street_line', Types::STRING, [
  28.                 'length' => 255,
  29.             ])->setNotnull(false);
  30.     }
  32.     public function postUp(Schema $schema): void
  33.     {
  34.         $this->connection->executeQuery('UPDATE address SET street_line=street');
  35.     }
  37.     public function down(Schema $schema): void
  38.     {
  39.         $this->skipIf(
  40.             true === $schema->getTable('address')->getColumn('street')->getNotnull(),
  41.             'The street is already not null in the address table!'
  42.         );
  44.         $schema->getTable('address')->dropColumn('street_line');
  45.     }
  46. }