custom/plugins/NenoHeroSlider/src/NenoHeroSlider.php line 10

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace Neno\HeroSlider;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Framework\Plugin;
  7. use Shopware\Core\Framework\Plugin\Context\InstallContext;
  8. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  10. class NenoHeroSlider extends Plugin
  11. {
  12.     public function install(InstallContext $installContext): void
  13.     {
  14.         if ($this->isCategorySlideColumnExisting()) {
  15.             // This fixes a cross-compatibility bug with ConfiguratorTheme
  17.             /**
  18.              * @var Connection $connection
  19.              */
  20.             $connection = $this->container->get(Connection::class);
  21.             $connection->executeUpdate('ALTER TABLE `category` DROP COLUMN `heroSliderSlides`');
  22.         }
  24.         parent::install($installContext);
  25.     }
  27.     public function postInstall(InstallContext $installContext): void
  28.     {
  29.         parent::postInstall($installContext);
  31.         if (!$this->isCategorySlideColumnExisting()) {
  32.             // See install method:
  33.             // we are not sure if we only partially migrated,
  34.             // so we need to monkey patch category.heroSliderSlides back in
  35.             // if it does not exist
  37.             /**
  38.              * @var Connection $connection
  39.              */
  40.             $connection = $this->container->get(Connection::class);
  41.             $connection->executeUpdate('ALTER TABLE `category` ADD COLUMN `heroSliderSlides` binary(16) NULL');
  42.         }
  43.     }
  45.     public function uninstall(UninstallContext $context): void
  46.     {
  47.         parent::uninstall($context);
  49.         $connection = $this->container->get(Connection::class);
  51.         if ($this->isCategorySlideColumnExisting()) {
  52.             $connection->executeUpdate('ALTER TABLE `category` DROP COLUMN `heroSliderSlides`');
  53.         }
  55.         if ($context->keepUserData()) {
  56.             return;
  57.         }
  59.         $connection->executeUpdate('DROP TABLE IF EXISTS `neno_hero_slider_slide_category`');
  60.         $connection->executeUpdate('DROP TABLE IF EXISTS `neno_hero_slider_slide_translation`');
  61.         $connection->executeUpdate('DROP TABLE IF EXISTS `neno_hero_slider_slide`');
  62.     }
  64.     private function isCategorySlideColumnExisting() {
  65.         /**
  66.          * @var Connection $connection
  67.          */
  68.         $connection = $this->container->get(Connection::class);
  69.         $sm = $connection->getSchemaManager();
  71.         $categoryColumns = $sm->listTableColumns('category');
  72.         $exists = false;
  74.         foreach ($categoryColumns as $column) {
  75.             if ($column->getName() === 'heroSliderSlides') {
  76.                 $exists = true;
  77.                 break;
  78.             }
  79.         }
  81.         return $exists;
  82.     }
  83. }