update() public method

$qb = $conn->createQueryBuilder() ->update('users', 'u') ->set('u.password', md5('password')) ->where('u.id = ?');
public update ( string $update = null, string $alias = null )
$update string The table whose rows are subject to the update.
$alias string The table alias used in the constructed query.
Exemplo n.º 1
1
 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');
 }
Exemplo n.º 3
0
 /**
  * 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;
 }
Exemplo n.º 4
0
 /**
  * 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();
 }
Exemplo n.º 6
0
 /**
  * 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;
 }
Exemplo n.º 7
0
 /**
  * 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();
 }