$qb = $conn->createQueryBuilder()
->update('users', 'u')
->set('u.password', md5('password'))
->where('u.id = ?');
public function testEmptyUpdate()
{
$qb = new QueryBuilder($this->conn);
$qb2 = $qb->update();
$this->assertEquals(QueryBuilder::UPDATE, $qb->getType());
$this->assertSame($qb2, $qb);
}
/**
* @test
* @todo: Test with alias
*/
public function updateQuotesIdentifierAndDelegatesToConcreteQueryBuilder()
{
$this->connection->quoteIdentifier('aTable')->shouldBeCalled()->willReturnArgument(0);
$this->concreteQueryBuilder->update(Argument::exact('aTable'), Argument::cetera())->shouldBeCalled()->willReturn($this->subject);
$this->subject->update('aTable');
}
/**
* Turns the query being built into a bulk update query that ranges over
* a certain table
*
* @param string $update The table whose rows are subject to the update.
* @param string $alias The table alias used in the constructed query.
*
* @return QueryBuilder This QueryBuilder instance.
*/
public function update(string $update, string $alias = null) : QueryBuilder
{
$this->concreteQueryBuilder->update($this->quoteIdentifier($update), empty($alias) ? $alias : $this->quoteIdentifier($alias));
return $this;
}
/**
* Turns the query being built into a bulk update query that ranges over
* a certain table
*
* <code>
* $qb = $conn->getQueryBuilder()
* ->update('users', 'u')
* ->set('u.password', md5('password'))
* ->where('u.id = ?');
* </code>
*
* @param string $update The table whose rows are subject to the update.
* @param string $alias The table alias used in the constructed query.
*
* @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance.
*/
public function update($update = null, $alias = null)
{
$this->queryBuilder->update($this->getTableName($update), $alias);
return $this;
}
public function expedierCommande($id)
{
$queryBuilder = new QueryBuilder($this->db);
$queryBuilder->update('commandes', 'c')->set('c.id_etat', ':etat')->set('c.date_expedition', ':date_expedition')->where('c.id = :id')->setParameter(':etat', 1)->setParameter(':date_expedition', date('Y-m-d'))->setParameter(':id', $id);
return $queryBuilder->execute();
}
/**
* Turns the query being built into a bulk update query that ranges over
* a certain table
*
* @param string $update The table whose rows are subject to the update.
* @param string $alias The table alias used in the constructed query.
*
* @return self
*/
public function update($update = null, $alias = null)
{
$this->qb->update($update, $alias);
return $this;
}
/**
* Turns the query being built into a bulk update query that ranges over
* a certain table
*
* <code>
* $qb = $conn->getQueryBuilder()
* ->update('users', 'u')
* ->set('u.password', md5('password'))
* ->where('u.id = ?');
* </code>
*
* @param string $update The table whose rows are subject to the update.
* @param string $alias The table alias used in the constructed query.
*
* @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance.
*/
public function update($update = null, $alias = null)
{
$this->queryBuilder->update($this->helper->quoteColumnName($update), $alias);
return $this;
}
public function removeToken($id)
{
$queryBuilder = new QueryBuilder($this->db);
$queryBuilder->update('users', 'u')->set('u.token', ':token')->where('u.id = :id')->setParameter(':token', NULL)->setParameter(':id', $id);
$queryBuilder->execute();
}
public function editNumber($id, $data)
{
$queryBuilder = new QueryBuilder($this->db);
$queryBuilder->update('numbers', 'n')->set('n.number', ':number')->where('n.id = :id')->andWhere('n.user_id = :id_user')->setParameter(':number', $data['number'])->setParameter(':id', $id)->setParameter(':id_user', $this->id_user);
return $queryBuilder->execute();
}
