migrations/Common/Version20220825104121_Observation.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Common;
  7. use App\Doctrine\Type\Common\ObservationStatus;
  8. use App\Doctrine\Type\Common\ObservationType;
  9. use Doctrine\DBAL\Schema\Schema;
  10. use Doctrine\Migrations\AbstractMigration;
  12. /**
  13.  * Auto-generated Migration: Please modify to your needs!
  14.  */
  15. final class Version20220825104121_Observation extends AbstractMigration
  16. {
  17.     public function getDescription(): string
  18.     {
  19.         return 'Add observation table';
  20.     }
  22.     public function up(Schema $schema): void
  23.     {
  24.         $this->addSql(ObservationType::getRegistrationSQL());
  25.         $this->addSql(ObservationStatus::getRegistrationSQL());
  26.         $observationTypeType = ObservationType::getName();
  27.         $observationStatusType = ObservationStatus::getName();
  29.         $this->addSql("CREATE TABLE observation (
  30.             id                              SERIAL PRIMARY KEY,
  31.             work_order_id                   INTEGER                              REFERENCES public.work_order (id),
  32.             bill_id                         INTEGER                              REFERENCES public.finance_bill (id),
  33.             withdrawal_id                   INTEGER,
  34.             type                            {$observationTypeType}      NOT NULL,
  35.             status                          {$observationStatusType}    NOT NULL,
  36.             comment                         CHARACTER VARYING           NOT NULL,
  37.             resolved_on                     DATE,
  39.             created_by                      INTEGER                     NOT NULL REFERENCES public.user (id),
  40.             updated_by                      INTEGER                              REFERENCES public.user (id),
  41.             created_at                      TIMESTAMP(0) WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
  42.             updated_at                      TIMESTAMP(0) WITH TIME ZONE,
  43.             deleted_at                      TIMESTAMP(0) WITH TIME ZONE,
  45.             CONSTRAINT observation_xor_observable CHECK (
  46.                 (work_order_id IS NOT NULL AND bill_id IS     NULL AND withdrawal_id IS     NULL) OR
  47.                 (work_order_id IS     NULL AND bill_id IS NOT NULL AND withdrawal_id IS     NULL) OR
  48.                 (work_order_id IS     NULL AND bill_id IS     NULL AND withdrawal_id IS NOT NULL)
  49.             )
  50.         )");
  52.         $this->addSql("CREATE INDEX observation_work_order_id_idx ON observation (work_order_id)");
  53.         $this->addSql("CREATE INDEX observation_created_by_idx ON observation (created_by)");
  54.         $this->addSql("CREATE INDEX observation_updated_by_idx ON observation (updated_by)");
  55.     }
  57.     public function down(Schema $schema): void
  58.     {
  59.         $this->addSql("DROP TABLE IF EXISTS observation");
  60.         $this->addSql(ObservationStatus::getDeletionSQL());
  61.         $this->addSql(ObservationType::getDeletionSQL());
  62.     }
  63. }