Code Duplication - symphonycms/symphony-2 - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 14-15 lines in 2 locations

install/migrations/2.2.0.php 1 location



            $field_ids = array_merge($author, $checkbox, $date, $input, $textarea, $upload);

            foreach ($field_ids as $id) {
                $table = '`tbl_entries_data_' . $id . '`';

                try {
                    Symphony::Database()->query("ALTER TABLE " . $table . " DROP INDEX `entry_id`");
                } catch (Exception $ex) {
                }

                try {
                    Symphony::Database()->query("CREATE UNIQUE INDEX `entry_id` ON " . $table . " (`entry_id`)");
                    Symphony::Database()->query("OPTIMIZE TABLE " . $table);
                } catch (Exception $ex) {
                }
            }
        }

        // Update the version information

install/migrations/2.3.0.php 1 location


                "SELECT `field_id` FROM `tbl_fields_author`"
            );

            foreach ($author_fields as $id) {
                $table = 'tbl_entries_data_' . $id;

                // MySQL doesn't support DROP IF EXISTS, so we'll try and catch.
                try {
                    Symphony::Database()->query("ALTER TABLE `" . $table . "` DROP INDEX `entry_id`");
                } catch (Exception $ex) {
                }

                try {
                    Symphony::Database()->query("CREATE UNIQUE INDEX `author` ON `" . $table . "` (`entry_id`, `author_id`)");
                    Symphony::Database()->query("OPTIMIZE TABLE " . $table);
                } catch (Exception $ex) {
                }
            }

            // Move section sorting data from the database to the filesystem. #977
            if (Symphony::Database()->tableContainsField('tbl_sections', 'entry_order')) {

		@@ 61-74 (lines=14) @@
58
59		$field_ids = array_merge($author, $checkbox, $date, $input, $textarea, $upload);
60
61		foreach ($field_ids as $id) {
62		$table = '`tbl_entries_data_' . $id . '`';
63
64		try {
65		Symphony::Database()->query("ALTER TABLE " . $table . " DROP INDEX `entry_id`");
66		} catch (Exception $ex) {
67		}
68
69		try {
70		Symphony::Database()->query("CREATE UNIQUE INDEX `entry_id` ON " . $table . " (`entry_id`)");
71		Symphony::Database()->query("OPTIMIZE TABLE " . $table);
72		} catch (Exception $ex) {
73		}
74		}
75		}
76
77		// Update the version information

		@@ 143-157 (lines=15) @@
140		"SELECT `field_id` FROM `tbl_fields_author`"
141		);
142
143		foreach ($author_fields as $id) {
144		$table = 'tbl_entries_data_' . $id;
145
146		// MySQL doesn't support DROP IF EXISTS, so we'll try and catch.
147		try {
148		Symphony::Database()->query("ALTER TABLE `" . $table . "` DROP INDEX `entry_id`");
149		} catch (Exception $ex) {
150		}
151
152		try {
153		Symphony::Database()->query("CREATE UNIQUE INDEX `author` ON `" . $table . "` (`entry_id`, `author_id`)");
154		Symphony::Database()->query("OPTIMIZE TABLE " . $table);
155		} catch (Exception $ex) {
156		}
157		}
158
159		// Move section sorting data from the database to the filesystem. #977
160		if (Symphony::Database()->tableContainsField('tbl_sections', 'entry_order')) {

symphonycms / symphony-2

GitHub Access Token became invalid

Code Duplication Length = 14-15 lines in 2 locations

install/migrations/2.2.0.php 1 location

install/migrations/2.3.0.php 1 location