summaryrefslogtreecommitdiff
path: root/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Unit/SQLStore/QueryEngine/DescriptionInterpreters/SomePropertyInterpreterTest.php
diff options
context:
space:
mode:
Diffstat (limited to 'www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Unit/SQLStore/QueryEngine/DescriptionInterpreters/SomePropertyInterpreterTest.php')
-rw-r--r--www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Unit/SQLStore/QueryEngine/DescriptionInterpreters/SomePropertyInterpreterTest.php511
1 files changed, 511 insertions, 0 deletions
diff --git a/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Unit/SQLStore/QueryEngine/DescriptionInterpreters/SomePropertyInterpreterTest.php b/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Unit/SQLStore/QueryEngine/DescriptionInterpreters/SomePropertyInterpreterTest.php
new file mode 100644
index 00000000..592265c1
--- /dev/null
+++ b/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Unit/SQLStore/QueryEngine/DescriptionInterpreters/SomePropertyInterpreterTest.php
@@ -0,0 +1,511 @@
+<?php
+
+namespace SMW\Tests\SQLStore\QueryEngine\DescriptionInterpreters;
+
+use SMW\DataItemFactory;
+use SMW\Query\DescriptionFactory;
+use SMW\SQLStore\QueryEngine\DescriptionInterpreters\SomePropertyInterpreter;
+use SMW\SQLStore\QueryEngineFactory;
+use SMW\Tests\TestEnvironment;
+
+/**
+ * @covers \SMW\SQLStore\QueryEngine\DescriptionInterpreters\SomePropertyInterpreter
+ * @group semantic-mediawiki
+ *
+ * @license GNU GPL v2+
+ * @since 2.2
+ *
+ * @author mwjames
+ */
+class SomePropertyInterpreterTest extends \PHPUnit_Framework_TestCase {
+
+ private $querySegmentValidator;
+ private $descriptionFactory;
+ private $dataItemFactory;
+
+ protected function setUp() {
+ parent::setUp();
+
+ $this->descriptionFactory = new DescriptionFactory();
+ $this->dataItemFactory = new DataItemFactory();
+
+ $testEnvironment = new TestEnvironment();
+ $this->querySegmentValidator = $testEnvironment->getUtilityFactory()->newValidatorFactory()->newQuerySegmentValidator();
+ }
+
+ public function testCanConstruct() {
+
+ $querySegmentListBuilder = $this->getMockBuilder( '\SMW\SQLStore\QueryEngine\QuerySegmentListBuilder' )
+ ->disableOriginalConstructor()
+ ->getMock();
+
+ $this->assertInstanceOf(
+ '\SMW\SQLStore\QueryEngine\DescriptionInterpreters\SomePropertyInterpreter',
+ new SomePropertyInterpreter( $querySegmentListBuilder )
+ );
+ }
+
+ public function testinterpretDescriptionForUnknownTablePropertyId() {
+
+ $store = $this->getMockBuilder( '\SMW\SQLStore\SQLStore' )
+ ->disableOriginalConstructor()
+ ->getMock();
+
+ $store->expects( $this->once() )
+ ->method( 'findPropertyTableID' )
+ ->will( $this->returnValue( '' ) );
+
+ $description = $this->descriptionFactory->newSomeProperty(
+ $this->dataItemFactory->newDIProperty( 'Foo' ),
+ $this->descriptionFactory->newThingDescription()
+ );
+
+ $expected = new \stdClass;
+ $expected->type = 0;
+
+ $queryEngineFactory = new QueryEngineFactory( $store );
+
+ $instance = new SomePropertyInterpreter(
+ $queryEngineFactory->newQuerySegmentListBuilder()
+ );
+
+ $this->assertTrue(
+ $instance->canInterpretDescription( $description )
+ );
+
+ $this->querySegmentValidator->assertThatContainerHasProperties(
+ $expected,
+ $instance->interpretDescription( $description )
+ );
+ }
+
+ public function testinterpretDescriptionForNonIdSubject() {
+
+ $proptable = $this->getMockBuilder( '\stdClass' )
+ ->setMethods( [ 'usesIdSubject' ] )
+ ->getMock();
+
+ $proptable->expects( $this->any() )
+ ->method( 'usesIdSubject' )
+ ->will( $this->returnValue( false ) );
+
+ $store = $this->getMockBuilder( '\SMW\SQLStore\SQLStore' )
+ ->disableOriginalConstructor()
+ ->getMock();
+
+ $store->expects( $this->once() )
+ ->method( 'findPropertyTableID' )
+ ->will( $this->returnValue( 'Foo' ) );
+
+ $store->expects( $this->once() )
+ ->method( 'getPropertyTables' )
+ ->will( $this->returnValue( [ 'Foo' => $proptable ] ) );
+
+ $description = $this->descriptionFactory->newSomeProperty(
+ $this->dataItemFactory->newDIProperty( 'Foo' ),
+ $this->descriptionFactory->newThingDescription()
+ );
+
+ $expected = new \stdClass;
+ $expected->type = 0;
+
+ $queryEngineFactory = new QueryEngineFactory( $store );
+
+ $instance = new SomePropertyInterpreter(
+ $queryEngineFactory->newQuerySegmentListBuilder()
+ );
+
+ $this->assertTrue(
+ $instance->canInterpretDescription( $description )
+ );
+
+ $this->querySegmentValidator->assertThatContainerHasProperties(
+ $expected,
+ $instance->interpretDescription( $description )
+ );
+ }
+
+ public function testinterpretDescriptionForNonWikiPageTypeInverseProperty() {
+
+ $property = $this->getMockBuilder( '\SMW\DIProperty' )
+ ->disableOriginalConstructor()
+ ->getMock();
+
+ $property->expects( $this->once() )
+ ->method( 'isInverse' )
+ ->will( $this->returnValue( true ) );
+
+ $property->expects( $this->once() )
+ ->method( 'findPropertyTypeID' )
+ ->will( $this->returnValue( '_txt' ) );
+
+ $proptable = $this->getMockBuilder( '\stdClass' )
+ ->setMethods( [ 'usesIdSubject' ] )
+ ->getMock();
+
+ $proptable->expects( $this->any() )
+ ->method( 'usesIdSubject' )
+ ->will( $this->returnValue( true ) );
+
+ $store = $this->getMockBuilder( '\SMW\SQLStore\SQLStore' )
+ ->disableOriginalConstructor()
+ ->getMock();
+
+ $store->expects( $this->once() )
+ ->method( 'findPropertyTableID' )
+ ->will( $this->returnValue( 'Foo' ) );
+
+ $store->expects( $this->once() )
+ ->method( 'getPropertyTables' )
+ ->will( $this->returnValue( [ 'Foo' => $proptable ] ) );
+
+ $description = $this->descriptionFactory->newSomeProperty(
+ $property,
+ $this->descriptionFactory->newThingDescription()
+ );
+ $expected = new \stdClass;
+ $expected->type = 0;
+
+ $queryEngineFactory = new QueryEngineFactory( $store );
+
+ $instance = new SomePropertyInterpreter(
+ $queryEngineFactory->newQuerySegmentListBuilder()
+ );
+
+ $this->assertTrue(
+ $instance->canInterpretDescription( $description )
+ );
+
+ $this->querySegmentValidator->assertThatContainerHasProperties(
+ $expected,
+ $instance->interpretDescription( $description )
+ );
+ }
+
+ /**
+ * @dataProvider descriptionProvider
+ */
+ public function testinterpretDescription( $description, $isFixedPropertyTable, $indexField, $sortKeys, $expected ) {
+
+ $dataItemHandler = $this->getMockBuilder( '\SMW\SQLStore\EntityStore\DataItemHandler' )
+ ->disableOriginalConstructor()
+ ->getMockForAbstractClass();
+
+ $dataItemHandler->expects( $this->any() )
+ ->method( 'getIndexField' )
+ ->will( $this->returnValue( $indexField ) );
+
+ $dataItemHandler->expects( $this->any() )
+ ->method( 'getTableFields' )
+ ->will( $this->returnValue( [ 'one', 'two' ] ) );
+
+ $dataItemHandler->expects( $this->any() )
+ ->method( 'getWhereConds' )
+ ->will( $this->returnValue( [ $indexField => 'fixedFooWhereCond' ] ) );
+
+ $objectIds = $this->getMockBuilder( '\stdClass' )
+ ->setMethods( [ 'getSMWPropertyID', 'getSMWPageID' ] )
+ ->getMock();
+
+ $objectIds->expects( $this->any() )
+ ->method( 'getSMWPropertyID' )
+ ->will( $this->returnValue( 42 ) );
+
+ $objectIds->expects( $this->any() )
+ ->method( 'getSMWPageID' )
+ ->will( $this->returnValue( 91 ) );
+
+ $connection = $this->getMockBuilder( '\SMW\MediaWiki\Database' )
+ ->disableOriginalConstructor()
+ ->getMock();
+
+ $connection->expects( $this->any() )
+ ->method( 'addQuotes' )
+ ->will( $this->returnArgument( 0 ) );
+
+ $store = $this->getMockBuilder( '\SMW\SQLStore\SQLStore' )
+ ->disableOriginalConstructor()
+ ->getMock();
+
+ $proptable = $this->getMockBuilder( '\SMWSQLStore3Table' )
+ ->disableOriginalConstructor()
+ ->getMock();
+
+ $proptable->expects( $this->any() )
+ ->method( 'usesIdSubject' )
+ ->will( $this->returnValue( true ) );
+
+ $proptable->expects( $this->any() )
+ ->method( 'getName' )
+ ->will( $this->returnValue( 'FooPropTable' ) );
+
+ $proptable->expects( $this->any() )
+ ->method( 'isFixedPropertyTable' )
+ ->will( $this->returnValue( $isFixedPropertyTable ) );
+
+ $store = $this->getMockBuilder( '\SMW\SQLStore\SQLStore' )
+ ->disableOriginalConstructor()
+ ->getMock();
+
+ $store->expects( $this->once() )
+ ->method( 'findPropertyTableID' )
+ ->will( $this->returnValue( 'Foo' ) );
+
+ $store->expects( $this->once() )
+ ->method( 'getPropertyTables' )
+ ->will( $this->returnValue( [ 'Foo' => $proptable ] ) );
+
+ $store->expects( $this->any() )
+ ->method( 'getConnection' )
+ ->will( $this->returnValue( $connection ) );
+
+ $store->expects( $this->any() )
+ ->method( 'getObjectIds' )
+ ->will( $this->returnValue( $objectIds ) );
+
+ $store->expects( $this->any() )
+ ->method( 'getDataItemHandlerForDIType' )
+ ->will( $this->returnValue( $dataItemHandler ) );
+
+ $queryEngineFactory = new QueryEngineFactory( $store );
+
+ $querySegmentListBuilder = $queryEngineFactory->newQuerySegmentListBuilder();
+ $querySegmentListBuilder->setSortKeys( $sortKeys );
+
+ $instance = new SomePropertyInterpreter(
+ $querySegmentListBuilder
+ );
+
+ $this->assertTrue(
+ $instance->canInterpretDescription( $description )
+ );
+
+ $this->querySegmentValidator->assertThatContainerHasProperties(
+ $expected,
+ $instance->interpretDescription( $description )
+ );
+ }
+
+ public function descriptionProvider() {
+
+ $descriptionFactory = new DescriptionFactory();
+ $dataItemFactory = new DataItemFactory();
+
+ #0 Blob + wildcard
+ $isFixedPropertyTable = false;
+ $indexField = '';
+ $sortKeys = [];
+ $property = $dataItemFactory->newDIProperty( 'Foo' );
+ $property->setPropertyTypeId( '_txt' );
+
+ $description = $descriptionFactory->newSomeProperty(
+ $property,
+ $descriptionFactory->newThingDescription()
+ );
+
+ $expected = new \stdClass;
+ $expected->type = 1;
+ $expected->joinTable = 'FooPropTable';
+ $expected->components = [ 1 => "t0.p_id" ];
+ $expected->sortfields = [];
+
+ $provider[] = [
+ $description,
+ $isFixedPropertyTable,
+ $indexField,
+ $sortKeys,
+ $expected
+ ];
+
+ #1 WikiPage + SMW_CMP_EQ
+ $isFixedPropertyTable = false;
+ $indexField = 'wikipageIndex';
+ $sortKeys = [];
+ $property = $dataItemFactory->newDIProperty( 'Foo' );
+ $property->setPropertyTypeId( '_wpg' );
+
+ $description = $descriptionFactory->newSomeProperty(
+ $property,
+ $descriptionFactory->newValueDescription( $dataItemFactory->newDIWikiPage( 'Bar', NS_MAIN ), null, SMW_CMP_EQ )
+ );
+
+ $expected = new \stdClass;
+ $expected->type = 1;
+ $expected->joinTable = 'FooPropTable';
+ $expected->components = [ 1 => "t0.p_id", 2 => "t0.wikipageIndex" ];
+ $expected->queryNumber = 0;
+ $expected->where = '';
+ $expected->sortfields = [];
+
+ $provider[] = [
+ $description,
+ $isFixedPropertyTable,
+ $indexField,
+ $sortKeys,
+ $expected
+ ];
+
+ #2 WikiPage + SMW_CMP_EQ + sort
+ $isFixedPropertyTable = false;
+ $indexField = 'wikipageIndex';
+ $sortKeys = [ 'Foo' => 'DESC' ];
+ $property = $dataItemFactory->newDIProperty( 'Foo' );
+ $property->setPropertyTypeId( '_wpg' );
+
+ $description = $descriptionFactory->newSomeProperty(
+ $property,
+ $descriptionFactory->newValueDescription( $dataItemFactory->newDIWikiPage( 'Bar', NS_MAIN ), null, SMW_CMP_EQ )
+ );
+
+ $expected = new \stdClass;
+ $expected->type = 1;
+ $expected->joinTable = 'FooPropTable';
+ $expected->components = [ 1 => "t0.p_id", 2 => "t0.wikipageIndex" ];
+ $expected->queryNumber = 0;
+ $expected->where = '';
+ $expected->sortfields = [ 'Foo' => 'idst0.smw_sort' ];
+ $expected->from = ' INNER JOIN AS idst0 ON idst0.smw_id=t0.wikipageIndex';
+
+ $provider[] = [
+ $description,
+ $isFixedPropertyTable,
+ $indexField,
+ $sortKeys,
+ $expected
+ ];
+
+ #3 Blob + SMW_CMP_EQ
+ $isFixedPropertyTable = false;
+ $indexField = 'blobIndex';
+ $sortKeys = [];
+ $property = $dataItemFactory->newDIProperty( 'Foo' );
+ $property->setPropertyTypeId( '_txt' );
+
+ $description = $descriptionFactory->newSomeProperty(
+ $property,
+ $descriptionFactory->newValueDescription( $dataItemFactory->newDIBlob( 'Bar' ), null, SMW_CMP_EQ )
+ );
+
+ $expected = new \stdClass;
+ $expected->type = 1;
+ $expected->joinTable = 'FooPropTable';
+ $expected->components = [ 1 => "t0.p_id" ];
+ $expected->queryNumber = 0;
+ $expected->where = '(t0.blobIndex=fixedFooWhereCond)';
+ $expected->sortfields = [];
+
+ $provider[] = [
+ $description,
+ $isFixedPropertyTable,
+ $indexField,
+ $sortKeys,
+ $expected
+ ];
+
+ #4 Blob + SMW_CMP_EQ + sort
+ $isFixedPropertyTable = false;
+ $indexField = 'blobIndex';
+ $sortKeys = [ 'Foo' => 'ASC' ];
+ $property = $dataItemFactory->newDIProperty( 'Foo' );
+ $property->setPropertyTypeId( '_txt' );
+
+ $description = $descriptionFactory->newSomeProperty(
+ $property,
+ $descriptionFactory->newValueDescription( $dataItemFactory->newDIBlob( 'Bar' ), null, SMW_CMP_EQ )
+ );
+
+ $expected = new \stdClass;
+ $expected->type = 1;
+ $expected->joinTable = 'FooPropTable';
+ $expected->components = [ 1 => "t0.p_id" ];
+ $expected->queryNumber = 0;
+ $expected->where = '(t0.blobIndex=fixedFooWhereCond)';
+ $expected->sortfields = [ 'Foo' => 't0.blobIndex' ];
+ $expected->from = '';
+
+ $provider[] = [
+ $description,
+ $isFixedPropertyTable,
+ $indexField,
+ $sortKeys,
+ $expected
+ ];
+
+ #5 Check SemanticMaps compatibility mode (invokes `getSQLCondition`)
+ $isFixedPropertyTable = false;
+ $indexField = 'blobIndex';
+ $sortKeys = [];
+ $property = $dataItemFactory->newDIProperty( 'Foo' );
+ $property->setPropertyTypeId( '_txt' );
+
+ $valueDescription = $this->getMockBuilder( '\SMW\Query\Language\ValueDescription' )
+ ->disableOriginalConstructor()
+ ->setMethods( [ 'getSQLCondition', 'getDataItem' ] )
+ ->getMock();
+
+ $valueDescription->expects( $this->any() )
+ ->method( 'getDataItem' )
+ ->will( $this->returnValue( $dataItemFactory->newDIBlob( '13,56' ) ) );
+
+ $valueDescription->expects( $this->once() )
+ ->method( 'getSQLCondition' )
+ ->will( $this->returnValue( 'foo AND bar' ) );
+
+ $description = $descriptionFactory->newSomeProperty(
+ $property,
+ $valueDescription
+ );
+
+ $expected = new \stdClass;
+ $expected->type = 1;
+ $expected->joinTable = 'FooPropTable';
+ $expected->components = [ 1 => "t0.p_id" ];
+ $expected->queryNumber = 0;
+ $expected->where = '(foo AND bar)';
+ $expected->sortfields = [];
+ $expected->from = '';
+
+ $provider[] = [
+ $description,
+ $isFixedPropertyTable,
+ $indexField,
+ $sortKeys,
+ $expected
+ ];
+
+ #6, see 556
+ $isFixedPropertyTable = false;
+ $indexField = '';
+ $sortKeys = [];
+ $property = $dataItemFactory->newDIProperty( 'Foo' );
+ $property->setPropertyTypeId( '_txt' );
+
+ $description = $descriptionFactory->newSomeProperty(
+ $property,
+ $descriptionFactory->newDisjunction( [
+ $descriptionFactory->newValueDescription( $dataItemFactory->newDIBlob( 'Bar' ) ),
+ $descriptionFactory->newValueDescription( $dataItemFactory->newDIBlob( 'Baz' ) )
+ ] )
+ );
+
+ $expected = new \stdClass;
+ $expected->type = 1;
+ $expected->joinTable = 'FooPropTable';
+ $expected->components = [ 1 => "t0.p_id" ];
+ $expected->queryNumber = 0;
+ $expected->where = '((t0.=fixedFooWhereCond) OR (t0.=fixedFooWhereCond))';
+ $expected->sortfields = [];
+ $expected->from = '';
+
+ $provider[] = [
+ $description,
+ $isFixedPropertyTable,
+ $indexField,
+ $sortKeys,
+ $expected
+ ];
+
+ return $provider;
+ }
+
+}
generated by cgit v1.2.1 (git 2.18.0) at 2024-05-04 19:51:57 +0000