public function testCanConstructSomeProperty() { $property = $this->getMockBuilder('\\SMW\\DIProperty')->disableOriginalConstructor()->getMock(); $description = $this->getMockBuilder('\\SMW\\Query\\Language\\Description')->disableOriginalConstructor()->getMockForAbstractClass(); $instance = new DescriptionFactory(); $this->assertInstanceOf('SMW\\Query\\Language\\SomeProperty', $instance->newSomeProperty($property, $description)); }
/** * Returns all results that have a value near to the searched for value * on the property, ordered, and sorted by ending with the smallest * one. * * @param QueryOptions $pageRequestOptions * @param integer $count How many entities have the exact same value on the property? * @param integer $greater Should the values be bigger? Set false for smaller values. * * @return array of array of SMWWikiPageValue, SMWDataValue with the * first being the entity, and the second the value */ public function doQueryForNearbyResults(PageRequestOptions $pageRequestOptions, $count, $greater = true) { $comparator = $greater ? SMW_CMP_GRTR : SMW_CMP_LESS; $sortOrder = $greater ? 'ASC' : 'DESC'; if ($pageRequestOptions->value !== null && $pageRequestOptions->value->getTypeID() === '_txt' && strlen($pageRequestOptions->valueString) > 72) { $comparator = SMW_CMP_LIKE; } $descriptionFactory = new DescriptionFactory(); if ($pageRequestOptions->valueString === '' || $pageRequestOptions->valueString === null) { $description = $descriptionFactory->newThingDescription(); } else { $description = $descriptionFactory->newValueDescription($pageRequestOptions->value->getDataItem(), $pageRequestOptions->property->getDataItem(), $comparator); $description = $descriptionFactory->newSomeProperty($pageRequestOptions->property->getDataItem(), $description); } $query = new Query($description); $query->setLimit($pageRequestOptions->limit); $query->setOffset($pageRequestOptions->offset); $query->sort = true; $query->sortkeys = array($pageRequestOptions->property->getDataItem()->getKey() => $sortOrder); // Note: printrequests change the caption of properties they // get (they expect properties to be given to them). // Since we want to continue using the property for our // purposes, we give a clone to the print request. $printouts = array(new PrintRequest(PrintRequest::PRINT_THIS, ''), new PrintRequest(PrintRequest::PRINT_PROP, '', clone $pageRequestOptions->property)); $query->setExtraPrintouts($printouts); $queryResults = $this->store->getQueryResult($query); $result = array(); while ($resultArrays = $queryResults->getNext()) { $r = array(); foreach ($resultArrays as $resultArray) { $r[] = $resultArray->getNextDataValue(); } // Note: if results have multiple values for the property // then this code just pick the first, which may not be // the reason why the result is shown here, i.e., it could // be out of order. $result[] = $r; } if (!$greater) { $result = array_reverse($result); } return $result; }
/** * @since 2.4 * * @param string $displayTitle * * @return DIProperty|false */ public function getPropertyFromDisplayTitle($displayTitle) { $descriptionFactory = new DescriptionFactory(); $description = $descriptionFactory->newSomeProperty(new DIProperty('_DTITLE'), $descriptionFactory->newValueDescription(new DIBlob($displayTitle))); $query = new Query($description); $query->setLimit(1); $dataItems = $this->cachedPropertyValuesPrefetcher->queryPropertyValuesFor($query); if (is_array($dataItems) && $dataItems !== array()) { $dataItem = end($dataItems); // Cache results as a linked list attached to // the property so that it can be purged all together return new DIProperty($dataItem->getDBKey()); } return false; }
public function descriptionProvider() { $descriptionFactory = new DescriptionFactory(); $dataItemFactory = new DataItemFactory(); #0 Blob + wildcard $isFixedPropertyTable = false; $indexField = ''; $sortKeys = array(); $property = $dataItemFactory->newDIProperty('Foo'); $property->setPropertyTypeId('_txt'); $description = $descriptionFactory->newSomeProperty($property, $descriptionFactory->newThingDescription()); $expected = new \stdClass(); $expected->type = 1; $expected->joinTable = 'FooPropTable'; $expected->components = array(1 => "t0.p_id"); $expected->sortfields = array(); $provider[] = array($description, $isFixedPropertyTable, $indexField, $sortKeys, $expected); #1 WikiPage + SMW_CMP_EQ $isFixedPropertyTable = false; $indexField = 'wikipageIndex'; $sortKeys = array(); $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 = array(1 => "t0.p_id", 2 => "t0.wikipageIndex"); $expected->queryNumber = 0; $expected->where = ''; $expected->sortfields = array(); $provider[] = array($description, $isFixedPropertyTable, $indexField, $sortKeys, $expected); #2 WikiPage + SMW_CMP_EQ + sort $isFixedPropertyTable = false; $indexField = 'wikipageIndex'; $sortKeys = array('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 = array(1 => "t0.p_id", 2 => "t0.wikipageIndex"); $expected->queryNumber = 0; $expected->where = ''; $expected->sortfields = array('Foo' => 'idst0.smw_sortkey'); $expected->from = ' INNER JOIN AS idst0 ON idst0.smw_id=t0.wikipageIndex'; $provider[] = array($description, $isFixedPropertyTable, $indexField, $sortKeys, $expected); #3 Blob + SMW_CMP_EQ $isFixedPropertyTable = false; $indexField = 'blobIndex'; $sortKeys = array(); $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 = array(1 => "t0.p_id"); $expected->queryNumber = 0; $expected->where = '(t0.blobIndex=fixedFooWhereCond)'; $expected->sortfields = array(); $provider[] = array($description, $isFixedPropertyTable, $indexField, $sortKeys, $expected); #4 Blob + SMW_CMP_EQ + sort $isFixedPropertyTable = false; $indexField = 'blobIndex'; $sortKeys = array('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 = array(1 => "t0.p_id"); $expected->queryNumber = 0; $expected->where = '(t0.blobIndex=fixedFooWhereCond)'; $expected->sortfields = array('Foo' => 't0.blobIndex'); $expected->from = ''; $provider[] = array($description, $isFixedPropertyTable, $indexField, $sortKeys, $expected); #5 Check SemanticMaps compatibility mode (invokes `getSQLCondition`) $isFixedPropertyTable = false; $indexField = 'blobIndex'; $sortKeys = array(); $property = $dataItemFactory->newDIProperty('Foo'); $property->setPropertyTypeId('_txt'); $valueDescription = $this->getMockBuilder('\\SMW\\Query\\Language\\ValueDescription')->disableOriginalConstructor()->setMethods(array('getSQLCondition', 'getDataItem'))->getMock(); $valueDescription->expects($this->any())->method('getProperty')->will($this->returnValue($property)); $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 = array(1 => "t0.p_id"); $expected->queryNumber = 0; $expected->where = '(foo AND bar)'; $expected->sortfields = array(); $expected->from = ''; $provider[] = array($description, $isFixedPropertyTable, $indexField, $sortKeys, $expected); #6, see 556 $isFixedPropertyTable = false; $indexField = ''; $sortKeys = array(); $property = $dataItemFactory->newDIProperty('Foo'); $property->setPropertyTypeId('_txt'); $description = $descriptionFactory->newSomeProperty($property, $descriptionFactory->newDisjunction(array($descriptionFactory->newValueDescription($dataItemFactory->newDIBlob('Bar')), $descriptionFactory->newValueDescription($dataItemFactory->newDIBlob('Baz'))))); $expected = new \stdClass(); $expected->type = 1; $expected->joinTable = 'FooPropTable'; $expected->components = array(1 => "t0.p_id"); $expected->queryNumber = 0; $expected->where = '((t0.=fixedFooWhereCond) OR (t0.=fixedFooWhereCond))'; $expected->sortfields = array(); $expected->from = ''; $provider[] = array($description, $isFixedPropertyTable, $indexField, $sortKeys, $expected); return $provider; }