The startSetup() and endSetup() methods are used in setup scripts. They are often at the beginning and the end of an upgrade/install method, like in “upgrade()” method of Magento/Catalog/Setup/UpgradeData.php
The question is “do you really need them?” Or does it just “look necessary”? This blog post explores what these functions do and then explains when you do and do not need to use these methods.
Let’s see what these methods are doing.
First, startSetup():
1: public function startSetup()
2: {
3: $this->rawQuery("SET SQL_MODE=''");
4: $this->rawQuery("SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0");
5: $this->rawQuery("SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'");
6:
7: return $this;
8: }
Then, endSetup() just rolls back both foreign keys check and auto-increment behavior to the previous state:
1: public function endSetup() 2: { 3: $this->rawQuery("SET SQL_MODE=IFNULL(@OLD_SQL_MODE,'')"); 4: $this->rawQuery("SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS=0, 0, 1)"); 5: 6: return $this; 7: }
Do you really need this for every install/upgrade? Probably not. Use startSetup() and endSetup() selectively, only for the cases where you really have some data or schema changes that are impossible without modifying default MySQL behavior.
I would recommend using these methods only when you really need such functionality during your upgrade. It would keep the foreign keys validation in place, as it may help discover potential data corruption issues.
To summarize:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.