本文整理匯總了PHP中Magento\Framework\DB\Adapter\AdapterInterface::rawQuery方法的典型用法代碼示例。如果您正苦於以下問題:PHP AdapterInterface::rawQuery方法的具體用法?PHP AdapterInterface::rawQuery怎麽用?PHP AdapterInterface::rawQuery使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Magento\Framework\DB\Adapter\AdapterInterface
的用法示例。
在下文中一共展示了AdapterInterface::rawQuery方法的2個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: insertRecords
/**
* @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;
}
示例2: insertFromSelect
/**
* @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,'')");
}