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;
}
