resourceConnection = $resourceConnection; $this->defaultSourceProvider = $defaultSourceProvider; } /** * @param ModuleDataSetupInterface $setup * @return void */ public function execute(ModuleDataSetupInterface $setup) { $defaultSourceCode = $this->defaultSourceProvider->getCode(); $sourceShipmentTable = $setup->getTable('inventory_shipment_source'); $salesShipmentTable = $setup->getTable('sales_shipment'); $selectForInsert = $this->resourceConnection->getConnection() ->select() ->from( $salesShipmentTable, [ 'entity_id', 'source_code' => new \Zend_Db_Expr('\'' .$defaultSourceCode . '\'') ] ); $sql = $this->resourceConnection->getConnection()->insertFromSelect( $selectForInsert, $sourceShipmentTable, [ self::SHIPMENT_ID, self::SOURCE_CODE, ], Mysql::INSERT_ON_DUPLICATE ); $this->resourceConnection->getConnection()->query($sql); } }