Example #1
0
 public function testIsSelect()
 {
     $this->assertTrue(\r8\DB\Link::isSelect("SELECT * FROM table"));
     $this->assertTrue(\r8\DB\Link::isSelect("    SELECT * FROM table"));
     $this->assertTrue(\r8\DB\Link::isSelect(" \r \n \t  SELECT * FROM table"));
     $this->assertTrue(\r8\DB\Link::isSelect("  (  SELECT * FROM table )"));
     $this->assertTrue(\r8\DB\Link::isSelect("(((SELECT * FROM table)))"));
     $this->assertTrue(\r8\DB\Link::isSelect(" (  ( ( SELECT * FROM table)))"));
     $this->assertTrue(\r8\DB\Link::isSelect("EXPLAIN SELECT * FROM table"));
     $this->assertTrue(\r8\DB\Link::isSelect("( (EXPLAIN SELECT * FROM table))"));
     $this->assertTrue(\r8\DB\Link::isSelect("( ( EXPLAIN   \n \t SELECT * FROM table))"));
     $this->assertFalse(\r8\DB\Link::isSelect("UPDATE table SET field = 1"));
     $this->assertFalse(\r8\DB\Link::isSelect("INSERT INTO table SET field = 1"));
 }
Example #2
0
 /**
  * Execute a query and return a result object
  *
  * @param String $query The query to execute
  * @return \r8\iface\DB\Adapter\Result
  */
 public function query($query)
 {
     if (!isset($this->link)) {
         $this->connect();
     }
     $result = $this->link->query($query);
     if ($result === FALSE) {
         throw new \r8\Exception\DB\Query($query, $this->link->error, $this->link->errno);
     }
     if (\r8\DB\Link::isSelect($query)) {
         return new \r8\DB\Result\Read(new \r8\DB\MySQLi\Result($result), $query);
     } else {
         return new \r8\DB\Result\Write($this->link->affected_rows, $this->link->insert_id, $query);
     }
 }
Example #3
0
 /**
  * Runs a query and returns the result
  *
  * @param String $query The query to run
  * @param Integer $flags Any boolean flags to set
  * @returns \r8\iface\DB\Result Returns a result object
  */
 public function query($query, $flags = 0)
 {
     $query = (string) $query;
     if (\r8\DB\Link::isSelect($query)) {
         if (empty($this->queue)) {
             $result = new \r8\DB\BlackHole\Result();
         } else {
             $result = array_shift($this->queue);
         }
         return new \r8\DB\Result\Read($result, $query);
     } else {
         if (\r8\DB\Link::isInsert($query)) {
             return new \r8\DB\Result\Write(1, ++$this->insertID, $query);
         } else {
             return new \r8\DB\Result\Write(0, null, $query);
         }
     }
 }
Example #4
0
 /**
  * Execute a query and return a result object
  *
  * @param String $query The query to execute
  * @return \r8\iface\DB\Adapter\Result
  */
 public function query($query)
 {
     if (!isset($this->link)) {
         $this->connect();
     }
     $error = null;
     $result = @sqlite_query($this->link, $query, SQLITE_ASSOC, $error);
     if ($result === FALSE) {
         $code = sqlite_last_error($this->link);
         throw new \r8\Exception\DB\Query($query, sqlite_error_string($code) . ": " . $error, $code);
     }
     if (\r8\DB\Link::isSelect($query)) {
         return new \r8\DB\Result\Read(new \r8\DB\SQLite\Result($result), $query);
     } else {
         return new \r8\DB\Result\Write(sqlite_changes($this->link), sqlite_last_insert_rowid($this->link), $query);
     }
 }