migrations/Version20230327115101.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 Version20230327115101 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')->getColumn('street_line')->getNotnull(),
  23.             'The street_line is already not null in the address table!'
  24.         );
  26.         $schema->getTable('address')->dropColumn('street');
  27.     }
  29.     public function down(Schema $schema): void
  30.     {
  31.         $this->skipIf(
  32.             true === $schema->getTable('address')->hasColumn('street'),
  33.             'The street is already set in the address table!'
  34.         );
  35.         $schema->getTable('address')
  36.             ->addColumn('street', Types::STRING, [
  37.                 'length' => 255,
  38.             ])->setNotnull(false);
  39.     }
  41.     public function postDown(Schema $schema): void
  42.     {
  43.         $this->connection->executeQuery('UPDATE address SET street=street_line');
  44.     }
  45. }