custom/static-plugins/AlphaplanEntityConnector/src/AlphaplanEntityConnector.php line 10

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace AlphaplanEntityConnector;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Framework\Plugin;
  7. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  8. use Shopware\Core\Framework\Plugin\Context\InstallContext;
  10. class AlphaplanEntityConnector extends Plugin
  11. {
  13.     public function install(InstallContext $context): void
  14.     {
  15.         $this->cleanUpTables();
  16.         parent::install($context);
  17.     }
  19.     public function uninstall(UninstallContext $context): void
  20.     {
  21.         parent::uninstall($context);
  23.         if ($context->keepUserData()) {
  24.             return;
  25.         }
  27.         $this->cleanUpTables();
  28.     }
  30.     private function cleanUpTables(){
  32.         //Clean up the DB Structure
  33.         $connection = $this->container->get(Connection::class);
  35.         $connection->executeStatement('DROP FUNCTION IF EXISTS `UuidToBin`;');
  36.         $connection->executeStatement('DROP PROCEDURE IF EXISTS `ap_calcpreis_shopware`;');
  37.         $connection->executeStatement('DROP PROCEDURE IF EXISTS `ap_vkpreis_shopware`;');
  38.         $connection->executeStatement('DROP PROCEDURE IF EXISTS `ap_rabatt_shopware`;');
  40.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_einheiten`;');
  41.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_verkaufs_preis_gruppen_preise`;');
  42.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_verkaufspreis_ergebnisse`;');
  43.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_verkaufspreis_prioritaeten`;');
  44.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_verkaufs_preise`;');
  45.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_einheiten_sets`;');
  46.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_kalkulations_arten`;');
  47.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_rabatt_prioritaeten`;');
  48.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_rabatt_zielfelder`;');
  49.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_rabatt_ergebnisse`;');
  50.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_rabatte`;');
  51.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_artikel_zuschlaege`;');
  52.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_konfiguration`;');
  53.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_artikeleumehrwertsteuern`;');
  54.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_warengruppeneumehrwertsteuern`;');
  56.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_product`;');
  57.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_tax`;');
  58.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_currency`;');
  59.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_customer_group`;');
  60.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_language`;');
  61.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_product_manufacturer`;');
  62.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_country`;');
  63.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_category`;');
  64.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_unit`;');
  65.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_payment_method`;');
  66.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_customer`;');
  67.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_customer_address`;');
  68.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_product_price`;');
  69.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_salutation`;');
  70.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_media`;');
  71.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_property_group`;');
  72.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_property_group_option`;');
  73.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_shipping_method`;');
  74.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_order_line_item`;');
  76.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_belege`;');
  77.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_einheiten_texte`;');
  78.         $connection->executeStatement('DROP TABLE IF EXISTS `cvs_sales_channel`;');
  79.     }
  80. }