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():
public function startSetup() {
$this->rawQuery("SET SQL_MODE=''");
$this->rawQuery("SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0");
$this->rawQuery("SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'");
return $this;
}
1. Disable foreign keys check. It may be necessary in some rare cases (for example, in a case of cyclic references between tables), but itās not needed in common situations. It even may lead to hiding real problems with the upgrade script, like if inserted values really break the integrity of the database.
2. Disable generation of auto-increment values when ā0ā is inserted. It may also be useful in some cases, such as when you are certain that youāre going to insert ā0ā values and you want them to be treated as ā0ās, instead of defaulting to auto-incrementing. This type of scenario is not necessary for common install/upgrade scripts.
Then, endSetup() just rolls back both foreign keys check and auto-increment behavior to the previous state:
public function endSetup() {
$this->rawQuery("SET SQL_MODE=IFNULL(@OLD_SQL_MODE,'')");
$this->rawQuery("SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS=0, 0, 1)");
return $this;
}
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.
conclusion:
==============
1:By default, donāt use startSetup() and endSetup() combination in your setup scripts. Most likely, you donāt need them.
2:The startSetup() and endSetup() may be helpful and you should use them if you want to:
1:disable foreign key checks, or
2:disable auto-increment for ā0ā values.
Comments
Post a Comment