Exemple #1
0
 /**
  * The query class always frees the result so you don't have to worry
  * about use and store result flags from the prespective of having to
  * free results
  *
  * @return	null
  */
 public function testUnBufferedSendQuery()
 {
     $driver = $this->conn->getDriver();
     $sql = 'SELECT query_id, result FROM test_queries WHERE query_id=1';
     $result = $this->query->execute($driver, $sql, MYSQLI_USE_RESULT);
     $expected = array(array('query_id' => 1, 'result' => 'query issued'));
     $this->assertEquals($expected, $result);
     $sql = 'SELECT query_id, result FROM test_queries WHERE query_id=2';
     $result = $this->query->execute($driver, $sql);
     $expected = array(array('query_id' => 2, 'result' => 'query 2 issued'));
     $this->assertEquals($expected, $result);
 }
Exemple #2
0
 /**
  * @return null
  */
 public function testMutlipleQueriesSqlErrorFirstQuery()
 {
     $sql = 'SELECT query_id, result FROM test_queries WHERE uery_id=3;';
     $sql .= 'SELECT query_id, result FROM test_queries WHERE query_id=1;';
     $sql .= 'SELECT query_id, result FROM test_queries WHERE query_id=2;';
     $options = array(0 => array('result-key' => 'first-query'), 1 => array('result-key' => 'second-query'), 2 => array('result-key' => 'third-query'));
     $result = $this->query->execute($this->driver, $sql, $this->responseCallback, $options);
     $this->assertInstanceOf('Appfuel\\Db\\DbResponse', $result);
     $this->assertTrue($result->isError());
     $error = $result->getError();
     $this->assertInstanceOf('Appfuel\\Db\\Mysql\\Mysqli\\MultiQuery\\Error', $error);
     /* indicates the error happened before the result loop */
     $this->assertEquals(-1, $error->getIndex());
 }
Exemple #3
0
 /**
  * @return null
  */
 public function testMutlipleQueriesSqlErrorFirstQuery()
 {
     $sql = 'SELECT query_id, result FROM test_queries WHERE uery_id=3;';
     $sql .= 'SELECT query_id, result FROM test_queries WHERE query_id=1;';
     $sql .= 'SELECT query_id, result FROM test_queries WHERE query_id=2;';
     $options = array(0 => array('result-key' => 'first-query'), 1 => array('result-key' => 'second-query'), 2 => array('result-key' => 'third-query'));
     $request = new MultiQueryRequest('read');
     $request->setSql($sql)->setResultOptions($options);
     $response = $this->adapter->execute($request);
     $this->assertInstanceOf($this->responseClass, $response);
     $this->assertFalse($response->isSuccess());
     $this->assertFalse($response->getStatus());
     $this->assertTrue($response->isError());
     $this->assertEquals(0, $response->getRowCount());
     $error = $response->getError();
     $this->assertInstanceOf('Appfuel\\Db\\Mysql\\Mysqli\\MultiQuery\\Error', $error);
     /* indicates the error happened before the result loop */
     $this->assertEquals(-1, $error->getIndex());
 }