migrations/Version20230310094900.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\Type;
  9. use Doctrine\DBAL\Types\Types;
  10. use Doctrine\Migrations\AbstractMigration;
  11. use PaperKite\Common\DataFixtures\HealthInsuranceFixtures;
  13. final class Version20230310094900 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return 'update short_code to integer for health_insurance table';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->skipIf(
  23.             Type::getType(Types::INTEGER) === $schema->getTable('health_insurance')->getColumn('export_id')->getType(),
  24.             'The export_id field is already integer in the health_insurance table!'
  25.         );
  27.         foreach (HealthInsuranceFixtures::getList() as $insurance) {
  28.             $query = $this->connection->prepare(
  29.                 'UPDATE health_insurance SET name=:name, short_code=:short_code, export_id=:export_id, is_default=:is_default WHERE name=:name;'
  30.             );
  31.             $query->bindValue('name', $insurance['name']);
  32.             $query->bindValue('short_code', $insurance['shortCode']);
  33.             $query->bindValue('export_id', $insurance['exportId']);
  34.             $query->bindValue('is_default', (int) $insurance['isDefault']);
  35.             $query->executeQuery();
  36.         }
  38.         $schema->getTable('health_insurance')
  39.             ->getColumn('export_id')
  40.             ->setType(Type::getType(Types::INTEGER));
  41.     }
  43.     public function down(Schema $schema): void
  44.     {
  45.         $this->skipIf(
  46.             Type::getType(Types::STRING) === $schema->getTable('health_insurance')->getColumn('export_id')->getType(),
  47.             'The export_id field is already string in the health_insurance table!'
  48.         );
  50.         $schema->getTable('health_insurance')
  51.             ->getColumn('export_id')
  52.             ->setType(Type::getType(Types::STRING));
  53.     }
  54. }