$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(); }