1 files changed, 150 insertions, 0 deletions
diff --git a/www/wiki/extensions/SemanticMediaWiki/src/SQLStore/Lookup/PropertyUsageListLookup.php b/www/wiki/extensions/SemanticMediaWiki/src/SQLStore/Lookup/PropertyUsageListLookup.php
new file mode 100644
index 00000000..819d92e6
--- /dev/null
+++ b/www/wiki/extensions/SemanticMediaWiki/src/SQLStore/Lookup/PropertyUsageListLookup.php
@@ -0,0 +1,150 @@
+<?php
+
+namespace SMW\SQLStore\Lookup;
+
+use RuntimeException;
+use SMW\DIProperty;
+use SMW\Exception\PropertyLabelNotResolvedException;
+use SMW\SQLStore\PropertyStatisticsStore;
+use SMW\SQLStore\SQLStore;
+use SMW\Store;
+use SMWDIError as DIError;
+use SMWRequestOptions as RequestOptions;
+
+/**
+ * @license GNU GPL v2+
+ * @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 $requestOptions|null
+	 */
+	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 boolean
+	 */
+	public function isFromCache() {
+		return false;
+	}
+
+	/**
+	 * @since 2.2
+	 *
+	 * @return integer
+	 */
+	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(
+			[ $db->tableName( SQLStore::ID_TABLE ), $db->tableName( SQLStore::PROPERTY_STATISTICS_TABLE ) ],
+			[ 'smw_id', 'smw_title', 'usage_count' ],
+			$conditions,
+			__METHOD__,
+			$options,
+			[ $db->tableName( 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;
+	}
+
+}