Code Duplication - webmatch/WbmQueryManager - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 5-6 lines in 2 locations

WbmQueryManager.php 2 locations


     */
    public function update(UpdateContext $context)
    {
        if(version_compare($context->getCurrentVersion(), '2.0.0', '<')) {
            $sql = "ALTER TABLE `wbm_query_manager` CHANGE `interval` `interval_int` INT(11) NULL DEFAULT '0';
                    ALTER TABLE `wbm_query_manager` CHANGE `sql` `sql_string` LONGTEXT NOT NULL;";

            $this->container->get('shopware.db')->query($sql);
        }

        if(version_compare($context->getCurrentVersion(), '2.0.3', '<')) {
            $sql = "ALTER TABLE `wbm_query_manager` ADD `mail_recipient` VARCHAR (255) NULL DEFAULT NULL AFTER `last_run`;";

            $this->container->get('shopware.db')->query($sql);
        }

        if(version_compare($context->getCurrentVersion(), '2.0.3', '<')) {
            $sql = "ALTER TABLE `wbm_query_manager` ADD `mail_recipient` VARCHAR (255) NULL DEFAULT NULL AFTER `last_run`;";

            $this->container->get('shopware.db')->query($sql);
        }

        $context->scheduleClearCache(InstallContext::CACHE_LIST_ALL);
    }

		@@ 63-68 (lines=6) @@
60		*/
61		public function update(UpdateContext $context)
62		{
63		if(version_compare($context->getCurrentVersion(), '2.0.0', '<')) {
64		$sql = "ALTER TABLE `wbm_query_manager` CHANGE `interval` `interval_int` INT(11) NULL DEFAULT '0';
65		ALTER TABLE `wbm_query_manager` CHANGE `sql` `sql_string` LONGTEXT NOT NULL;";
66
67		$this->container->get('shopware.db')->query($sql);
68		}
69
70		if(version_compare($context->getCurrentVersion(), '2.0.3', '<')) {
71		$sql = "ALTER TABLE `wbm_query_manager` ADD `mail_recipient` VARCHAR (255) NULL DEFAULT NULL AFTER `last_run`;";
		@@ 70-74 (lines=5) @@
67		$this->container->get('shopware.db')->query($sql);
68		}
69
70		if(version_compare($context->getCurrentVersion(), '2.0.3', '<')) {
71		$sql = "ALTER TABLE `wbm_query_manager` ADD `mail_recipient` VARCHAR (255) NULL DEFAULT NULL AFTER `last_run`;";
72
73		$this->container->get('shopware.db')->query($sql);
74		}
75
76		$context->scheduleClearCache(InstallContext::CACHE_LIST_ALL);
77		}

webmatch / WbmQueryManager

Code Duplication Length = 5-6 lines in 2 locations

WbmQueryManager.php 2 locations