/**
* @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());
}
