/** * @since 2.2 * * @param Description $description * * @return QuerySegment */ public function interpretDescription(Description $description) { $query = new QuerySegment(); $cqid = QuerySegment::$qnum; $cquery = new QuerySegment(); $cquery->type = QuerySegment::Q_CLASS_HIERARCHY; $cquery->joinfield = array(); foreach ($description->getCategories() as $category) { $categoryId = $this->queryBuilder->getStore()->getObjectIds()->getSMWPageID($category->getDBkey(), NS_CATEGORY, $category->getInterwiki(), ''); if ($categoryId != 0) { $cquery->joinfield[] = $categoryId; } } if (count($cquery->joinfield) == 0) { // Empty result. $query->type = QuerySegment::Q_VALUE; $query->joinTable = ''; $query->joinfield = ''; } else { // Instance query with disjunction of classes (categories) $query->joinTable = $this->queryBuilder->getStore()->findPropertyTableID(new DIProperty('_INST')); $query->joinfield = "{$query->alias}.s_id"; $query->components[$cqid] = "{$query->alias}.o_id"; $this->queryBuilder->addQuerySegmentForId($cqid, $cquery); } return $query; }
/** * TODO: One instance of the SMW IDs table on s_id always suffices (swm_id is KEY)! Doable in execution ... (PERFORMANCE) * * @since 2.2 * * @param Description $description * * @return QuerySegment */ public function interpretDescription(Description $description) { $query = new QuerySegment(); $query->joinTable = SMWSql3SmwIds::tableName; $query->joinfield = "{$query->alias}.smw_id"; $query->where = "{$query->alias}.smw_namespace=" . $this->queryBuilder->getStore()->getConnection('mw.db')->addQuotes($description->getNamespace()); return $query; }
/** * Given an Description that is just a conjunction or disjunction of * ValueDescription objects, create and return a plain WHERE condition * string for it. * * @param $query * @param ValueDescription $description * @param DataItemHandler $diHandler for that table * @param string $operator SQL operator "AND" or "OR" */ private function mapValueDescription($query, ValueDescription $description, DataItemHandler $diHandler, $operator) { $where = ''; $dataItem = $description->getDataItem(); $db = $this->queryBuilder->getStore()->getConnection('mw.db'); // TODO Better get the handle from the property type // Some comparators (e.g. LIKE) could use DI values of // a different type; we care about the property table, not // about the value // Do not support smw_id joined data for now. $indexField = $diHandler->getIndexField(); //Hack to get to the field used as index $keys = $diHandler->getWhereConds($dataItem); $value = $keys[$indexField]; // See if the getSQLCondition method exists and call it if this is the case. // Invoked by SMAreaValueDescription, SMGeoCoordsValueDescription if (method_exists($description, 'getSQLCondition')) { $fields = $diHandler->getTableFields(); $where = $description->getSQLCondition($query->alias, array_keys($fields), $this->queryBuilder->getStore()->getConnection(DB_SLAVE)); } if ($where == '') { $comparator = $this->comparatorMapper->mapComparator($description, $value); $where = "{$query->alias}.{$indexField}{$comparator}" . $db->addQuotes($value); } if ($where !== '') { if ($query->where && substr($query->where, -1) != '(') { $query->where .= " {$operator} "; } $query->where .= "({$where})"; } }
/** * @since 2.2 * * @param Description $description * * @return QuerySegment */ public function interpretDescription(Description $description) { $query = new QuerySegment(); $query->type = $description instanceof Conjunction ? QuerySegment::Q_CONJUNCTION : QuerySegment::Q_DISJUNCTION; foreach ($description->getDescriptions() as $subDescription) { $subQueryId = $this->queryBuilder->buildQuerySegmentFor($subDescription); if ($subQueryId >= 0) { $query->components[$subQueryId] = true; } } // All subconditions failed, drop this as well. if (count($query->components) == 0) { $query->type = QuerySegment::Q_NOQUERY; } return $query; }
/** * Only type '_wpg' objects can appear on query level (essentially as nominal classes) * * @since 2.2 * * @param Description $description * * @return QuerySegment */ public function interpretDescription(Description $description) { $query = new QuerySegment(); if (!$description->getDataItem() instanceof DIWikiPage) { return $query; } if ($description->getComparator() === SMW_CMP_EQ) { $query->type = QuerySegment::Q_VALUE; $oid = $this->queryBuilder->getStore()->getObjectIds()->getSMWPageID($description->getDataItem()->getDBkey(), $description->getDataItem()->getNamespace(), $description->getDataItem()->getInterwiki(), $description->getDataItem()->getSubobjectName()); $query->joinfield = array($oid); } else { // Join with SMW IDs table needed for other comparators (apply to title string). $query->joinTable = SMWSql3SmwIds::tableName; $query->joinfield = "{$query->alias}.smw_id"; $value = $description->getDataItem()->getSortKey(); $comparator = $this->comparatorMapper->mapComparator($description, $value); $query->where = "{$query->alias}.smw_sortkey{$comparator}" . $this->queryBuilder->getStore()->getConnection('mw.db')->addQuotes($value); } return $query; }
private function compileAccordingConditionsAndHackThemIntoQobj(array $extraProperties, $qobj, $qid) { $this->queryBuilder->setSortKeys($this->sortKeys); $this->queryBuilder->buildQuerySegmentFor(new Conjunction($extraProperties)); $newQuerySegmentId = $this->queryBuilder->getLastQuerySegmentId(); $this->querySegments = $this->queryBuilder->getQuerySegments(); $this->errors = $this->queryBuilder->getErrors(); $newQuerySegment = $this->querySegments[$newQuerySegmentId]; // This is always an QuerySegment::Q_CONJUNCTION ... foreach ($newQuerySegment->components as $cid => $field) { // ... so just re-wire its dependencies $qobj->components[$cid] = $qobj->joinfield; $qobj->sortfields = array_merge($qobj->sortfields, $this->querySegments[$cid]->sortfields); } $this->querySegments[$qid] = $qobj; }
/** * @dataProvider descriptionProvider */ public function testinterpretDescription($description, $isFixedPropertyTable, $indexField, $sortKeys, $expected) { $dataItemHandler = $this->getMockBuilder('\\SMWDataItemHandler')->disableOriginalConstructor()->getMockForAbstractClass(); $dataItemHandler->expects($this->any())->method('getIndexField')->will($this->returnValue($indexField)); $dataItemHandler->expects($this->any())->method('getTableFields')->will($this->returnValue(array('one', 'two'))); $dataItemHandler->expects($this->any())->method('getWhereConds')->will($this->returnValue(array($indexField => 'fixedFooWhereCond'))); $objectIds = $this->getMockBuilder('\\stdClass')->setMethods(array('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(array('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)); $queryBuilder = new QueryBuilder($store); $queryBuilder->setSortKeys($sortKeys); $instance = new SomePropertyInterpreter($queryBuilder); $this->assertTrue($instance->canInterpretDescription($description)); $this->querySegmentValidator->assertThatContainerHasProperties($expected, $instance->interpretDescription($description)); }
/** * We bypass the storage interface here (which is legal as we control it, * and safe if we are careful with changes ...) * * This should be faster, but we must implement the unescaping that concepts * do on getWikiValue */ private function getConceptForId($id) { return $this->queryBuilder->getStore()->getConnection('mw.db')->selectRow('smw_fpt_conc', array('concept_txt', 'concept_features', 'concept_size', 'concept_depth', 'cache_date'), array('s_id' => $id), __METHOD__); }
public function testWhenSomeQuerySegments_getQuerySegmentsReturnsThemAll() { $instance = new QueryBuilder($this->store); $firstQuerySegment = new QuerySegment(); $secondQuerySegment = new QuerySegment(); $instance->addQuerySegmentForId(42, $firstQuerySegment); $instance->addQuerySegmentForId(23, $secondQuerySegment); $this->assertSame(array(42 => $firstQuerySegment, 23 => $secondQuerySegment), $instance->getQuerySegments()); }