PHP Driver::query方法代碼示例

 /**
  * 事務查詢
  * @param string $sql
  */
 protected function query($sql)
 {
     try {
         if ($this->driver->query($sql, null, true)) {
             $status = true;
         } else {
             $status = false;
         }
     } catch (\Exception $e) {
         $status = false;
     }
     return $status;
 }

 /**
  * @param mixed $link
  */
 private function free($link)
 {
     $query = $this->controller->getQuery($this->driver, $link);
     if ($query) {
         try {
             $this->driver->query($link, $query->getExpression());
             $this->active->attach($link, $query);
         } catch (\Exception $err) {
             $this->active->detach($link);
             $query->reject($err);
         }
     } else {
         $this->active->detach($link);
     }
 }

 /**
  * @param Driver $driver
  * @param Table $table
  * @param Query $query
  * @param bool $asArray
  */
 public function __construct(Driver $driver, Table $table, Query $query, $asArray = false)
 {
     $this->asArray = $asArray;
     $this->table = $table;
     $params = [];
     $this->tableName = $table->getName();
     if (!$this->asArray) {
         $this->recordClasses = [$this->tableName => $table->getDatabase()->getClassMapper()->getClassForRecord($this->tableName)];
     }
     $sql = $query->getRawSql();
     if ($sql === null) {
         $sql = $driver->buildSQL($table, $query, $params);
         $this->fetchStyle = \PDO::FETCH_NUM;
         foreach ($table->getColumns() as $column) {
             if ($column->isPrimaryKey()) {
                 $this->primaryKeyOrdinals[$this->tableName][$column->getOrdinal()] = true;
             }
             $this->columnOrdinalMap[$this->tableName][$column->getOrdinal()] = $column->getName();
         }
         $offset = count($table->getColumns());
         foreach ($query->getJoins() as $join) {
             if (isset($join['cardinality'])) {
                 $joinedTableName = $join['table'];
                 $joinedTable = $table->getDatabase()->getTable($joinedTableName);
                 $this->joinedTables[$joinedTableName] = $joinedTable;
                 if (!$this->asArray) {
                     $this->recordClasses[$joinedTableName] = $joinedTable->getDatabase()->getClassMapper()->getClassForRecord($joinedTableName);
                 }
                 foreach ($joinedTable->getColumns() as $column) {
                     if ($column->isPrimaryKey()) {
                         $this->primaryKeyOrdinals[$joinedTableName][$offset + $column->getOrdinal()] = true;
                     }
                     $this->columnOrdinalMap[$joinedTableName][$offset + $column->getOrdinal()] = $column->getName();
                 }
                 $this->cardinalities[$joinedTableName] = $join['cardinality'];
                 if ($join['cardinality'] === Query::CARDINALITY_ONE_TO_MANY) {
                     $this->properties[$joinedTableName] = $joinedTableName;
                 } else {
                     $this->properties[$joinedTableName] = array_keys($join['on']);
                 }
                 $offset += count($joinedTable->getColumns());
             }
         }
     } else {
         $this->fetchStyle = \PDO::FETCH_ASSOC;
         $this->rawSql = true;
     }
     $this->result = $driver->query($sql, $params);
     $this->fetchNextRow();
 }

 /**
  * @param int $timeout
  * @param string $statement query statement
  * @param array $vars [optional]
  * @return Statement object
  * @throws ConnectionException
  */
 protected function cacheQuery($timeout, $statement, array $vars = null)
 {
     if ($this->cache !== null) {
         $queryId = $this->cache->getQueryId($statement, $vars);
         $st = $this->cache->read($queryId, $timeout);
         if (!$st) {
             // Cache miss
             $this->debug("Cache miss!");
             $tmpSt = $this->connection->query($statement, $vars);
             $st = Cache::createCacheableEstatement($tmpSt);
             $this->cache->write($queryId, $st, $timeout);
         }
         return $st;
     } else {
         user_error('No cache engine found!', E_USER_WARNING);
         return $this->query($statement, $vars);
     }
 }

 /**
  * Tests Result->affectedRows()
  */
 public function testAffectedRows()
 {
     $res = $this->driver->query("SELECT 1, 2");
     $this->assertEquals(1, $res->affectedRows());
 }

 public function query(array $parameters = [])
 {
     return $this->driver->query($this->get(), $parameters + $this->parameters);
 }