本文整理匯總了PHP中Doctrine\DBAL\Query\QueryBuilder::setValue方法的典型用法代碼示例。如果您正苦於以下問題:PHP QueryBuilder::setValue方法的具體用法?PHP QueryBuilder::setValue怎麽用?PHP QueryBuilder::setValue使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Doctrine\DBAL\Query\QueryBuilder
的用法示例。
在下文中一共展示了QueryBuilder::setValue方法的4個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: setAddValues
private function setAddValues(array $serialized, QueryBuilder $qb)
{
$i = 0;
foreach ($serialized as $column => $value) {
$qb->setValue($column, '?');
$qb->setParameter($i, $value);
++$i;
}
}
示例2: setValuesAndParameters
/**
* Sets the values and parameters of the upcoming given query according
* to the entity.
*
* @param CRUDEntity $entity
* the entity with its fields and values
* @param QueryBuilder $queryBuilder
* the upcoming query
* @param boolean $setValue
* whether to use QueryBuilder::setValue (true) or QueryBuilder::set (false)
*/
protected function setValuesAndParameters(CRUDEntity $entity, QueryBuilder $queryBuilder, $setValue)
{
$formFields = $this->definition->getEditableFieldNames();
$count = count($formFields);
for ($i = 0; $i < $count; ++$i) {
$value = $entity->get($formFields[$i]);
$type = $this->definition->getType($formFields[$i]);
if ($type == 'bool') {
$value = $value ? 1 : 0;
}
if ($type == 'date' || $type == 'datetime' || $type == 'reference') {
$value = $value == '' ? null : $value;
}
if ($setValue) {
$queryBuilder->setValue('`' . $formFields[$i] . '`', '?');
} else {
$queryBuilder->set('`' . $formFields[$i] . '`', '?');
}
$queryBuilder->setParameter($i, $value);
}
}
示例3: setValueWithoudNamedParameterQuotesIdentifierAndDelegatesToConcreteQueryBuilder
/**
* @test
*/
public function setValueWithoudNamedParameterQuotesIdentifierAndDelegatesToConcreteQueryBuilder()
{
$this->connection->quoteIdentifier('aField')->shouldBeCalled()->willReturnArgument(0);
$this->concreteQueryBuilder->setValue('aField', 'aValue')->shouldBeCalled()->willReturn($this->subject);
$this->subject->setValue('aField', 'aValue', false);
}
示例4: setValue
/**
* Sets a value for a column in an insert query.
*
* <code>
* $qb = $conn->getQueryBuilder()
* ->insert('users')
* ->values(
* array(
* 'name' => '?'
* )
* )
* ->setValue('password', '?');
* </code>
*
* @param string $column The column into which the value should be inserted.
* @param string $value The value that should be inserted into the column.
*
* @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance.
*/
public function setValue($column, $value)
{
$this->queryBuilder->setValue($this->helper->quoteColumnName($column), $value);
return $this;
}