本文整理汇总了PHP中Doctrine\DBAL\Connection::convertToDatabaseValue方法的典型用法代码示例。如果您正苦于以下问题:PHP Connection::convertToDatabaseValue方法的具体用法?PHP Connection::convertToDatabaseValue怎么用?PHP Connection::convertToDatabaseValue使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Doctrine\DBAL\Connection
的用法示例。
在下文中一共展示了Connection::convertToDatabaseValue方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: execute
/**
* {@inheritdoc}
*/
public function execute(LoggerInterface $logger)
{
// update field itself
$sql = "UPDATE oro_entity_config_index_value\n SET value = ?\n WHERE\n entity_id = (SELECT id FROM oro_entity_config WHERE class_name = ? LIMIT 1) AND\n field_id IS NULL AND\n scope = ? AND\n code = ?\n ";
$parameters = [$this->value, $this->entityName, $this->scope, $this->code];
$statement = $this->connection->prepare($sql);
$statement->execute($parameters);
$this->logQuery($logger, $sql, $parameters);
$logger->debug($sql);
// update entity config cached data
$sql = 'SELECT data FROM oro_entity_config WHERE class_name = ? LIMIT 1';
$parameters = [$this->entityName];
$data = $this->connection->fetchColumn($sql, $parameters);
$this->logQuery($logger, $sql, $parameters);
$data = $data ? $this->connection->convertToPHPValue($data, Type::TARRAY) : [];
$data[$this->scope][$this->code] = $this->value;
$data = $this->connection->convertToDatabaseValue($data, Type::TARRAY);
$sql = 'UPDATE oro_entity_config SET data = ? WHERE class_name = ?';
$parameters = [$data, $this->entityName];
$statement = $this->connection->prepare($sql);
$statement->execute($parameters);
$this->logQuery($logger, $sql, $parameters);
}