PHP DatabaseBase::freeResult方法代码示例

	/**
	 * Get the interwiki list
	 * @todo Needs to respect interwiki cache!
	 * @return array
	 */
	private function getInterwikiList() {
		$result = $this->db->select( 'interwiki', array( 'iw_prefix' ) );
		$prefixes = array();
		foreach( $result as $row ) {
			$prefixes[] = $row->iw_prefix;
		}
		$this->db->freeResult( $result );
		return $prefixes;
	}

 private static function __getResults()
 {
     global $wgLang;
     wfProfileIn(__METHOD__);
     /* main query */
     $aResult = array();
     $aFields = array('/* BLOGS */ rev_page as page_id', 'page_namespace', 'page_title', 'min(rev_timestamp) as create_timestamp', 'unix_timestamp(rev_timestamp) as timestamp', 'rev_timestamp', 'min(rev_id) as rev_id', 'rev_user');
     $res = self::$dbr->select(array_map(array(self::$dbr, 'tableName'), self::$aTables), $aFields, self::$aWhere, __METHOD__, self::__makeDBOrder());
     while ($oRow = self::$dbr->fetchObject($res)) {
         if (class_exists('ArticleCommentList')) {
             $oComments = ArticleCommentList::newFromText($oRow->page_title, $oRow->page_namespace);
             $iCount = $oComments ? $oComments->getCountAllNested() : 0;
         } else {
             $iCount = 0;
         }
         /* username */
         $oTitle = Title::newFromText($oRow->page_title, $oRow->page_namespace);
         $sUsername = "";
         if (!$oTitle instanceof Title) {
             continue;
         }
         $username = BlogArticle::getOwner($oTitle);
         $oRevision = Revision::newFromTitle($oTitle);
         $aResult[$oRow->page_id] = array("page" => $oRow->page_id, "namespace" => $oRow->page_namespace, "title" => $oRow->page_title, "page_touched" => !is_null($oRevision) ? $oRevision->getTimestamp() : $oTitle->getTouched(), "rev_timestamp" => $oRow->rev_timestamp, "timestamp" => $oRow->timestamp, "username" => isset($username) ? $username : "", "text" => self::__getRevisionText($oRow->page_id, $oRevision), "revision" => $oRow->rev_id, "comments" => $iCount, "votes" => '', "props" => BlogArticle::getProps($oRow->page_id));
         // Sort by comment count for popular blog posts module
         if (isset(self::$aOptions['order']) && self::$aOptions['order'] == 'page_id') {
             uasort($aResult, array("BlogTemplateClass", "__sortByCommentCount"));
         }
         // We may need to query for 50 results but display 5
         if (isset(self::$aOptions['displaycount']) && self::$aOptions['displaycount'] != self::$aOptions['count']) {
             $aResult = array_slice($aResult, 0, self::$aOptions['displaycount']);
         }
     }
     // macbre: change for Oasis to add avatars and comments / likes data
     wfRunHooks('BlogTemplateGetResults', array(&$aResult));
     self::$dbr->freeResult($res);
     wfProfileOut(__METHOD__);
     return $aResult;
 }

 /**
  * Free a result object
  */
 function free()
 {
     $this->db->freeResult($this);
     unset($this->result);
     unset($this->db);
 }

 /**
  * Get the current data stored for the given ID in the given database
  * table. The result is an array of updates, formatted like the one of
  * the table insertion arrays created by preparePropertyTableInserts().
  *
  * @note Tables without IDs as subject are not supported. They will
  * hopefully vanish soon anyway.
  *
  * @since 1.8
  * @param integer $sid
  * @param SMWSQLStore3Table $tableDeclaration
  * @param DatabaseBase $dbr used for reading only
  * @return array
  */
 protected function getCurrentPropertyTableContents($sid, SMWSQLStore3Table $propertyTable, DatabaseBase $dbr)
 {
     if (!$propertyTable->usesIdSubject()) {
         // does not occur, but let's be strict
         throw new InvalidArgumentException('Operation not supported for tables without subject IDs.');
     }
     $contents = array();
     $results = $dbr->select($propertyTable->getName(), '*', array('s_id' => $sid), __METHOD__);
     foreach ($results as $result) {
         $rowArray = (array) $result;
         $rowKey = self::makeDatabaseRowKey($rowArray);
         $contents[$rowKey] = $rowArray;
     }
     $dbr->freeResult($results);
     return $contents;
 }

 /**
  * Update the usage count in the property statistics table for all
  * properties. This function also initialises the required entry for
  * all properties that have IDs in the SMW IDs table.
  *
  * @since 1.8
  * @param boolean $verbose
  * @param DatabaseBase $dbw used for writing
  */
 protected function refreshPropertyStatistics($verbose, $dbw)
 {
     $this->reportProgress("Updating property statistics. This may take a while.\n", $verbose);
     $res = $dbw->select(SMWSql3SmwIds::tableName, array('smw_id', 'smw_title'), array('smw_namespace' => SMW_NS_PROPERTY), __METHOD__);
     $propertyTables = SMWSQLStore3::getPropertyTables();
     foreach ($res as $row) {
         $this->reportProgress('.', $verbose);
         $usageCount = 0;
         foreach ($propertyTables as $propertyTable) {
             if ($propertyTable->isFixedPropertyTable() && $propertyTable->getFixedProperty() != $row->smw_title) {
                 // This table cannot store values for this property
                 continue;
             }
             $propRow = $dbw->selectRow($propertyTable->getName(), 'Count(*) as count', $propertyTable->isFixedPropertyTable() ? array() : array('p_id' => $row->smw_id), __METHOD__);
             $usageCount += $propRow->count;
         }
         $dbw->replace(SMWSQLStore3::PROPERTY_STATISTICS_TABLE, 'p_id', array('p_id' => $row->smw_id, 'usage_count' => $usageCount), __METHOD__);
     }
     $this->reportProgress("\nUpdated statistics for {$res->numRows()} Properties.\n", $verbose);
     $dbw->freeResult($res);
 }