Code Duplication - shopware/SwagConnect - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 24-24 lines in 6 locations

Components/TriggerService.php 6 locations


        ');
    }

    private function createArticleDetailsTrigger()
    {
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_details_update_trigger
            AFTER UPDATE
            ON s_articles_details
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_details_insert_trigger
            AFTER INSERT
            ON s_articles_details
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_details_delete_trigger
            AFTER DELETE
            ON s_articles_details
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_DELETE . '\' WHERE article_id = OLD.articleID
        ');
    }

    private function createArticleAttributesTrigger()
    {

        ');
    }

    private function createArticleAttributesTrigger()
    {
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_attributes_update_trigger
            AFTER UPDATE
            ON s_articles_attributes
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_attributes_insert_trigger
            AFTER INSERT
            ON s_articles_attributes
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_attributes_delete_trigger
            AFTER DELETE
            ON s_articles_attributes
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = OLD.articleID
        ');
    }

    private function createArticleImagesTrigger()
    {

        ');
    }

    private function createArticleImagesTrigger()
    {
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_images_update_trigger
            AFTER UPDATE
            ON s_articles_img
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_images_insert_trigger
            AFTER INSERT
            ON s_articles_img
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_images_delete_trigger
            AFTER DELETE
            ON s_articles_img
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = OLD.articleID
        ');
    }

    private function createArticleCategoriesTrigger()
    {

        ');
    }

    private function createArticleCategoriesTrigger()
    {
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_categories_update_trigger
            AFTER UPDATE
            ON s_articles_categories
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_categories_insert_trigger
            AFTER INSERT
            ON s_articles_categories
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_categories_delete_trigger
            AFTER DELETE
            ON s_articles_categories
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = OLD.articleID
        ');
    }

    private function createArticlePricesTrigger()
    {

        ');
    }

    private function createArticlePricesTrigger()
    {
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_prices_update_trigger
            AFTER UPDATE
            ON s_articles_prices
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_prices_insert_trigger
            AFTER INSERT
            ON s_articles_prices
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_prices_delete_trigger
            AFTER DELETE
            ON s_articles_prices
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = OLD.articleID
        ');
    }

    private function createArticleTranslationsTrigger()
    {

        ');
    }

    private function createArticleTranslationsTrigger()
    {
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_translations_update_trigger
            AFTER UPDATE
            ON s_articles_translations
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_translations_insert_trigger
            AFTER INSERT
            ON s_articles_translations
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
        ');
        $this->connection->executeQuery('
            CREATE TRIGGER connect_article_translations_delete_trigger
            AFTER DELETE
            ON s_articles_translations
            FOR EACH ROW
                UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = OLD.articleID
        ');
    }

    private function createSupplierTrigger()
    {

		@@ 81-104 (lines=24) @@
78		');
79		}
80
81		private function createArticleDetailsTrigger()
82		{
83		$this->connection->executeQuery('
84		CREATE TRIGGER connect_article_details_update_trigger
85		AFTER UPDATE
86		ON s_articles_details
87		FOR EACH ROW
88		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
89		');
90		$this->connection->executeQuery('
91		CREATE TRIGGER connect_article_details_insert_trigger
92		AFTER INSERT
93		ON s_articles_details
94		FOR EACH ROW
95		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
96		');
97		$this->connection->executeQuery('
98		CREATE TRIGGER connect_article_details_delete_trigger
99		AFTER DELETE
100		ON s_articles_details
101		FOR EACH ROW
102		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_DELETE . '\' WHERE article_id = OLD.articleID
103		');
104		}
105
106		private function createArticleAttributesTrigger()
107		{
		@@ 106-129 (lines=24) @@
103		');
104		}
105
106		private function createArticleAttributesTrigger()
107		{
108		$this->connection->executeQuery('
109		CREATE TRIGGER connect_article_attributes_update_trigger
110		AFTER UPDATE
111		ON s_articles_attributes
112		FOR EACH ROW
113		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
114		');
115		$this->connection->executeQuery('
116		CREATE TRIGGER connect_article_attributes_insert_trigger
117		AFTER INSERT
118		ON s_articles_attributes
119		FOR EACH ROW
120		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
121		');
122		$this->connection->executeQuery('
123		CREATE TRIGGER connect_article_attributes_delete_trigger
124		AFTER DELETE
125		ON s_articles_attributes
126		FOR EACH ROW
127		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = OLD.articleID
128		');
129		}
130
131		private function createArticleImagesTrigger()
132		{
		@@ 131-154 (lines=24) @@
128		');
129		}
130
131		private function createArticleImagesTrigger()
132		{
133		$this->connection->executeQuery('
134		CREATE TRIGGER connect_article_images_update_trigger
135		AFTER UPDATE
136		ON s_articles_img
137		FOR EACH ROW
138		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
139		');
140		$this->connection->executeQuery('
141		CREATE TRIGGER connect_article_images_insert_trigger
142		AFTER INSERT
143		ON s_articles_img
144		FOR EACH ROW
145		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
146		');
147		$this->connection->executeQuery('
148		CREATE TRIGGER connect_article_images_delete_trigger
149		AFTER DELETE
150		ON s_articles_img
151		FOR EACH ROW
152		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = OLD.articleID
153		');
154		}
155
156		private function createArticleCategoriesTrigger()
157		{
		@@ 156-179 (lines=24) @@
153		');
154		}
155
156		private function createArticleCategoriesTrigger()
157		{
158		$this->connection->executeQuery('
159		CREATE TRIGGER connect_article_categories_update_trigger
160		AFTER UPDATE
161		ON s_articles_categories
162		FOR EACH ROW
163		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
164		');
165		$this->connection->executeQuery('
166		CREATE TRIGGER connect_article_categories_insert_trigger
167		AFTER INSERT
168		ON s_articles_categories
169		FOR EACH ROW
170		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
171		');
172		$this->connection->executeQuery('
173		CREATE TRIGGER connect_article_categories_delete_trigger
174		AFTER DELETE
175		ON s_articles_categories
176		FOR EACH ROW
177		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = OLD.articleID
178		');
179		}
180
181		private function createArticlePricesTrigger()
182		{
		@@ 181-204 (lines=24) @@
178		');
179		}
180
181		private function createArticlePricesTrigger()
182		{
183		$this->connection->executeQuery('
184		CREATE TRIGGER connect_article_prices_update_trigger
185		AFTER UPDATE
186		ON s_articles_prices
187		FOR EACH ROW
188		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
189		');
190		$this->connection->executeQuery('
191		CREATE TRIGGER connect_article_prices_insert_trigger
192		AFTER INSERT
193		ON s_articles_prices
194		FOR EACH ROW
195		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
196		');
197		$this->connection->executeQuery('
198		CREATE TRIGGER connect_article_prices_delete_trigger
199		AFTER DELETE
200		ON s_articles_prices
201		FOR EACH ROW
202		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = OLD.articleID
203		');
204		}
205
206		private function createArticleTranslationsTrigger()
207		{
		@@ 206-229 (lines=24) @@
203		');
204		}
205
206		private function createArticleTranslationsTrigger()
207		{
208		$this->connection->executeQuery('
209		CREATE TRIGGER connect_article_translations_update_trigger
210		AFTER UPDATE
211		ON s_articles_translations
212		FOR EACH ROW
213		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
214		');
215		$this->connection->executeQuery('
216		CREATE TRIGGER connect_article_translations_insert_trigger
217		AFTER INSERT
218		ON s_articles_translations
219		FOR EACH ROW
220		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = NEW.articleID
221		');
222		$this->connection->executeQuery('
223		CREATE TRIGGER connect_article_translations_delete_trigger
224		AFTER DELETE
225		ON s_articles_translations
226		FOR EACH ROW
227		UPDATE s_plugin_connect_items SET cron_update = 1, export_status = \'' . Attribute::STATUS_UPDATE . '\' WHERE article_id = OLD.articleID
228		');
229		}
230
231		private function createSupplierTrigger()
232		{

shopware / SwagConnect

Code Duplication Length = 24-24 lines in 6 locations

Components/TriggerService.php 6 locations