| Server IP : 167.235.224.122 / Your IP : 216.73.216.110 Web Server : Apache/2.4.58 (Ubuntu) System : Linux newplayground 6.8.0-136-generic #136-Ubuntu SMP PREEMPT_DYNAMIC Wed Jul 1 21:33:11 UTC 2026 aarch64 User : deploy ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/wiki/extensions/SemanticMediaWiki/src/SQLStore/Lookup/ |
Upload File : |
<?php
namespace SMW\SQLStore\Lookup;
use MediaWiki\Message\Message;
use RuntimeException;
use SMW\DIProperty;
use SMW\Exception\PropertyLabelNotResolvedException;
use SMW\RequestOptions;
use SMW\SQLStore\PropertyStatisticsStore;
use SMW\SQLStore\SQLStore;
use SMW\Store;
use SMWDIError as DIError;
/**
* @license GPL-2.0-or-later
* @since 2.2
*
* @author mwjames
*/
class PropertyUsageListLookup implements ListLookup {
/**
* @var Store
*/
private $store;
/**
* @var PropertyStatisticsStore
*/
private $propertyStatisticsStore;
/**
* @var RequestOptions
*/
private $requestOptions;
/**
* @since 2.2
*
* @param Store $store
* @param PropertyStatisticsStore $propertyStatisticsStore
* @param RequestOptions|null $requestOptions
*/
public function __construct( Store $store, PropertyStatisticsStore $propertyStatisticsStore, ?RequestOptions $requestOptions = null ) {
$this->store = $store;
$this->propertyStatisticsStore = $propertyStatisticsStore;
$this->requestOptions = $requestOptions;
}
/**
* @since 2.2
*
* @return DIProperty[]
* @throws RuntimeException
*/
public function fetchList() {
if ( $this->requestOptions === null ) {
throw new RuntimeException( "Missing requestOptions" );
}
return $this->getPropertyList( $this->doQueryPropertyTable() );
}
/**
* @since 2.2
*
* @return bool
*/
public function isFromCache() {
return false;
}
/**
* @since 2.2
*
* @return int
*/
public function getTimestamp() {
return wfTimestamp( TS_UNIX );
}
/**
* @since 2.2
*
* @return string
*/
public function getHash() {
return __METHOD__ . '#' . ( $this->requestOptions !== null ? $this->requestOptions->getHash() : '' );
}
private function doQueryPropertyTable() {
// the query needs to do the filtering of internal properties, else LIMIT is wrong
$options = [ 'ORDER BY' => 'smw_sort' ];
$search_field = 'smw_sortkey';
$conditions = [
'smw_namespace' => SMW_NS_PROPERTY,
'smw_iw' => '',
'smw_subobject' => ''
];
if ( $this->requestOptions->limit > 0 ) {
$options['LIMIT'] = $this->requestOptions->limit;
$options['OFFSET'] = max( $this->requestOptions->offset, 0 );
}
if ( $this->requestOptions->getOption( RequestOptions::SEARCH_FIELD ) ) {
$search_field = $this->requestOptions->getOption( RequestOptions::SEARCH_FIELD );
}
if ( $this->requestOptions->getStringConditions() ) {
$conditions[] = $this->store->getSQLConditions( $this->requestOptions, '', $search_field, false );
}
$db = $this->store->getConnection( 'mw.db' );
$res = $db->select(
[ SQLStore::ID_TABLE, SQLStore::PROPERTY_STATISTICS_TABLE ],
[ 'smw_id', 'smw_title', 'usage_count' ],
$conditions,
__METHOD__,
$options,
[ SQLStore::ID_TABLE => [ 'INNER JOIN', [ 'smw_id=p_id' ] ] ]
);
return $res;
}
private function getPropertyList( $res ) {
$result = [];
foreach ( $res as $row ) {
try {
$property = new DIProperty( str_replace( ' ', '_', $row->smw_title ) );
} catch ( PropertyLabelNotResolvedException $e ) {
$property = new DIError( new Message( 'smw_noproperty', [ $row->smw_title ] ) );
}
$property->id = isset( $row->smw_id ) ? $row->smw_id : -1;
$result[] = [ $property, (int)$row->usage_count ];
}
return $result;
}
}