vendor/bluue/stocks-bundle/migrations/Version20230113104452.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace StocksBundleMigrations;
  7. use DateTime;
  8. use Doctrine\DBAL\Schema\Schema;
  9. use App\Services\ObjectSerialize;
  10. use Symfony\Component\Uid\UuidV6;
  11. use Doctrine\Migrations\AbstractMigration;
  13. final class Version20230113104452 extends AbstractMigration
  14. {
  15.     private ObjectSerialize $objectSerialize;
  17.     public function setObjectSerialize(ObjectSerialize $objectSerialize)
  18.     {
  19.         $this->objectSerialize = $objectSerialize;
  20.     }
  22.     public function up(Schema $schema): void
  23.     {
  24.         $this->addSql('ALTER TABLE stocks_bundle__stock_product_root ADD out_of_stock_limit INT DEFAULT NULL, ADD not_send_oos_alert TINYINT(1) DEFAULT 0 NOT NULL');
  25.         $this->addSql('CREATE INDEX out_of_stock_limit ON stocks_bundle__stock_product_root (out_of_stock_limit)');
  26.         $this->addSql('CREATE INDEX not_send_oos_alert ON stocks_bundle__stock_product_root (not_send_oos_alert)');
  27.     }
  29.     public function postUp(Schema $schema): void
  30.     {
  31.         parent::postUp($schema);
  33.         $this->connection->insert('configuration', [
  34.             'id' => (new UuidV6())->toBinary(),
  35.             'name' => 'stocks_bundle__out_of_stock_limit',
  36.             'context_id' => null,
  37.             'value' => $this->objectSerialize->add((object) ['value' => 0]),
  38.             'created_at' => (new DateTime())->format('Y-m-d H:i:s'),
  39.             'updated_at' => (new DateTime())->format('Y-m-d H:i:s')
  40.         ]);
  41.     }
  43.     public function down(Schema $schema): void
  44.     {
  45.         $this->addSql('DROP INDEX out_of_stock_limit ON stocks_bundle__stock_product_root');
  46.         $this->addSql('DROP INDEX not_send_oos_alert ON stocks_bundle__stock_product_root');
  47.         $this->addSql('ALTER TABLE stocks_bundle__stock_product_root DROP out_of_stock_limit, DROP not_send_oos_alert');
  48.     }
  49. }