/** * @inheritdoc */ public function insertRecords($documentName, $records, $updateOnDuplicate = false) { $this->resourceAdapter->rawQuery("SET @OLD_INSERT_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'"); if ($updateOnDuplicate) { $result = $this->resourceAdapter->insertOnDuplicate($documentName, $records); } else { $result = $this->resourceAdapter->insertMultiple($documentName, $records); } $this->resourceAdapter->rawQuery("SET SQL_MODE=IFNULL(@OLD_INSERT_SQL_MODE,'')"); return $result; }
/** * @inheritdoc */ public function insertFromSelect(\Magento\Framework\DB\Select $select, $table, array $fields = [], $mode = false) { $this->resourceAdapter->rawQuery("SET @OLD_INSERT_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'"); $query = $this->resourceAdapter->insertFromSelect($select, $table, $fields, $mode); $this->resourceAdapter->query($query); $this->resourceAdapter->rawQuery("SET SQL_MODE=IFNULL(@OLD_INSERT_SQL_MODE,'')"); }