public function addUser($data) { $queryBuilder = new QueryBuilder($this->db); $queryBuilder->insert('users')->values(['email' => '?', 'password' => '?', 'key_activation' => '?'])->setParameter(0, $data['email'])->setParameter(1, $this->_hashPassword($data['password']))->setParameter(2, bin2hex(openssl_random_pseudo_bytes(10))); return $queryBuilder->execute(); }
/** * @test */ public function insertQuotesIdentifierAndDelegatesToConcreteQueryBuilder() { $this->connection->quoteIdentifier('aTable')->shouldBeCalled()->willReturnArgument(0); $this->concreteQueryBuilder->insert(Argument::exact('aTable'))->shouldBeCalled()->willReturn($this->subject); $this->subject->insert('aTable'); }
public function addNumber($data) { $queryBuilder = new QueryBuilder($this->db); $queryBuilder->insert('numbers')->values(['user_id' => '?', 'number' => '?'])->setParameter(0, $this->id_user)->setParameter(1, $data['number']); return $queryBuilder->execute(); }
public function testEmptyInsert() { $qb = new QueryBuilder($this->conn); $qb2 = $qb->insert(); $this->assertEquals(QueryBuilder::INSERT, $qb->getType()); $this->assertSame($qb2, $qb); }
/** * Turns the query being built into an insert query that inserts into * a certain table * * <code> * $qb = $conn->getQueryBuilder() * ->insert('users') * ->values( * array( * 'name' => '?', * 'password' => '?' * ) * ); * </code> * * @param string $insert The table into which the rows should be inserted. * * @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance. */ public function insert($insert = null) { $this->queryBuilder->insert($this->getTableName($insert)); $this->lastInsertedTable = $insert; return $this; }
/** * Turns the query being built into an insert query that inserts into * a certain table * * @param string $insert The table into which the rows should be inserted. * * @return QueryBuilder This QueryBuilder instance. */ public function insert(string $insert) : QueryBuilder { $this->concreteQueryBuilder->insert($this->quoteIdentifier($insert)); return $this; }
public function addCommande($data) { $queryBuilder = new QueryBuilder($this->db); $queryBuilder->insert('commandes')->values(['id_etat' => '?', 'user_id' => '?', 'prix' => '?', 'date_achat' => '?'])->setParameter(0, 0)->setParameter(1, $data['id'])->setParameter(2, 23.99)->setParameter(3, date('Y-m-d')); return $queryBuilder->execute(); }
/** * Turns the query being built into an insert query that inserts into * a certain table * * <code> * $qb = $conn->getQueryBuilder() * ->insert('users') * ->values( * array( * 'name' => '?', * 'password' => '?' * ) * ); * </code> * * @param string $insert The table into which the rows should be inserted. * * @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance. */ public function insert($insert = null) { $this->queryBuilder->insert($this->helper->quoteColumnName($insert)); return $this; }