Queryr\TermStore\IdLookup

Complexity

Total Complexity

15

Size/Duplication

Total Lines	165
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Test Coverage

Coverage

90.24%

Importance

Changes

0

10 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	getIdByLabel()	0	3	1
A	getItemIdByLabel()	0	3	1
A	getPropertyIdByLabel()	0	3	1
A	getIdByText()	0	3	1
A	getItemIdByText()	0	3	1
A	getPropertyIdByText()	0	3	1
A	getEntityIdByText()	0	9	2
A	getEntityIdByLabel()	0	20	3
A	getIdByAlias()	0	20	3

<?php

namespace Queryr\TermStore;

use Doctrine\DBAL\DBALException;

/**
 * Package private.
 *
 * @licence GNU GPL v2+
 * @author Jeroen De Dauw < jeroendedauw@gmail.com >
 */
class IdLookup implements EntityIdLookup {

	private $labelTable;
	private $aliasesTable;

	public function __construct( TableQueryExecutor $labelTable, TableQueryExecutor $aliasesTable ) {
		$this->labelTable = $labelTable;
		$this->aliasesTable = $aliasesTable;
	}

	/**
	 * Returns the first matching entity id. Case insensitive.
	 *
	 * @param string $labelLanguageCode
	 * @param string $labelText
	 *
	 * @return string|null
	 * @throws TermStoreException
	 */
	public function getIdByLabel( $labelLanguageCode, $labelText ) {
		return $this->getEntityIdByLabel( $labelLanguageCode, $labelText );
	}

	/**
	 * Returns the first matching item id. Case insensitive.
	 *
	 * @param string $labelLanguageCode
	 * @param string $labelText
	 *
	 * @return string|null
	 * @throws TermStoreException
	 */
	public function getItemIdByLabel( $labelLanguageCode, $labelText ) {
		return $this->getEntityIdByLabel( $labelLanguageCode, $labelText, 'item' );
	}

	/**
	 * Returns the first matching property id. Case insensitive.
	 *
	 * @param string $labelLanguageCode
	 * @param string $labelText
	 *
	 * @return string|null
	 * @throws TermStoreException
	 */
	public function getPropertyIdByLabel( $labelLanguageCode, $labelText ) {
		return $this->getEntityIdByLabel( $labelLanguageCode, $labelText, 'property' );
	}

	/**
	 * @param string $labelLanguageCode
	 * @param string $labelText
	 * @param string|null $entityTypeFilter
	 *
	 * @return string|null
	 * @throws TermStoreException
	 */
	private function getEntityIdByLabel( $labelLanguageCode, $labelText, $entityTypeFilter = null ) {
		$conditions = [
			'text_lowercase' => strtolower( $labelText ),
			'language' => $labelLanguageCode,
		];

		if ( $entityTypeFilter !== null ) {
			$conditions['entity_type'] = $entityTypeFilter;
		}

		try {
			return $this->labelTable->selectOneField(
				'entity_id',
				$conditions
			);
		}
		catch ( DBALException $ex ) {
			throw new TermStoreException( $ex->getMessage(), $ex );
		}
	}

	/**
	 * Returns the first matching entity id. Case insensitive.
	 *
	 * @param string $languageCode
	 * @param string $termText
	 *
	 * @return string|null
	 * @throws TermStoreException
	 */
	public function getIdByText( $languageCode, $termText ) {
		return $this->getEntityIdByText( $languageCode, $termText );
	}

	/**
	 * Returns the first matching item id. Case insensitive.
	 *
	 * @param string $languageCode
	 * @param string $termText
	 *
	 * @return string|null
	 * @throws TermStoreException
	 */
	public function getItemIdByText( $languageCode, $termText ) {
		return $this->getEntityIdByText( $languageCode, $termText, 'item' );
	}

	/**
	 * Returns the first matching property id. Case insensitive.
	 *
	 * @param string $languageCode
	 * @param string $termText
	 *
	 * @return string|null
	 * @throws TermStoreException
	 */
	public function getPropertyIdByText( $languageCode, $termText ) {
		return $this->getEntityIdByText( $languageCode, $termText, 'property' );
	}

	/**
	 * @param string $languageCode
	 * @param string $termText
	 * @param string|null $entityTypeFilter
	 *
	 * @return string|null
	 * @throws TermStoreException
	 */
	private function getEntityIdByText( $languageCode, $termText, $entityTypeFilter = null ) {
		$labelMatch = $this->getEntityIdByLabel( $languageCode, $termText, $entityTypeFilter );

		if ( $labelMatch !== null ) {
			return $labelMatch;
		}

		return $this->getIdByAlias( $languageCode, $termText, $entityTypeFilter );
	}

	/**
	 * @param string $aliasLanguageCode
	 * @param string $aliasText
	 * @param string|null $entityTypeFilter
	 *
	 * @return string|null
	 * @throws TermStoreException
	 */
	private function getIdByAlias( $aliasLanguageCode, $aliasText, $entityTypeFilter = null ) {
		$conditions = [
			'text_lowercase' => strtolower( $aliasText ),
			'language' => $aliasLanguageCode
		];

		if ( $entityTypeFilter !== null ) {
			$conditions['entity_type'] = $entityTypeFilter;
		}

		try {
			return $this->aliasesTable->selectOneField(
				'entity_id',
				$conditions
			);
		}
		catch ( DBALException $ex ) {
			throw new TermStoreException( $ex->getMessage(), $ex );
		}
	}

}