function queryRecordSet( $recordSetStructureId, QueryTransactionInformation $transactionInformation, Attribute $keyAttribute, TableColumnsToAttributesMapping $tableColumnsToAttributeMapping, Table $table, array $restrictions, array $orderBy = array(), $count = - 1, $offset = 0 ) { $dbr = wfGetDB( DB_SLAVE ); $selectFields = $tableColumnsToAttributeMapping->getSelectColumns(); $attributes = $tableColumnsToAttributeMapping->getAttributes(); if ( $table->isVersioned ) { $allAttributes = array_merge( $attributes, $transactionInformation->versioningAttributes() ); } else { $allAttributes = $attributes; } $query = getTransactedSQL( $transactionInformation, $selectFields, $table, $restrictions, $orderBy, $count, $offset ); $queryResult = $dbr->query( $query ); if ( !is_null( $recordSetStructureId ) ) { $structure = new Structure( $recordSetStructureId, $allAttributes ); } else { $structure = new Structure( $allAttributes ); } $recordSet = new ArrayRecordSet( $structure, new Structure( $keyAttribute ) ); while ( $row = $dbr->fetchRow( $queryResult ) ) { $record = new ArrayRecord( $structure ); $columnIndex = 0; for ( $i = 0; $i < $tableColumnsToAttributeMapping->getCount(); $i++ ) { $mapping = $tableColumnsToAttributeMapping->getMapping( $i ); $attribute = $mapping->getAttribute(); $tableColumns = $mapping->getTableColumns(); if ( count( $tableColumns ) == 1 ) { $value = $row[$columnIndex]; } else { $value = getRecordFromRow( $row, $columnIndex, $attribute->type ); } $record->setAttributeValue( $attribute, $value ); $columnIndex += count( $tableColumns ); } $transactionInformation->setVersioningAttributes( $record, $row ); $recordSet->add( $record ); } return $recordSet; }
function splitRecordSet( $recordSet, $groupAttribute ) { $result = array(); $structure = $recordSet->getStructure(); $key = $recordSet->getKey(); for ( $i = 0; $i < $recordSet->getRecordCount(); $i++ ) { $record = $recordSet->getRecord( $i ); $groupAttributeValue = $record->getAttributeValue( $groupAttribute ); @$groupRecordSet = $result[$groupAttributeValue]; # FIXME - check existence in array if ( $groupRecordSet == null ) { $groupRecordSet = new ArrayRecordSet( $structure, $key ); $result[$groupAttributeValue] = $groupRecordSet; } $groupRecordSet->add( $record ); } return $result; }
function getUpdatedTranslatedTextRecordSet( $transactionId ) { $o = OmegaWikiAttributes::getInstance(); $dc = wdGetDataSetContext(); $dbr = wfGetDB( DB_SLAVE ); $queryResult = $dbr->query( "SELECT value_id, object_id, attribute_mid, translated_content_id, language_id, text_text, " . getOperationSelectColumn( "{$dc}_translated_content", $transactionId ) . ', ' . getIsLatestSelectColumn( "{$dc}_translated_content", array( 'translated_content_id', 'language_id' ), $transactionId ) . " FROM {$dc}_translated_content_attribute_values, {$dc}_translated_content, {$dc}_text " . " WHERE {$dc}_translated_content_attribute_values.value_tcid={$dc}_translated_content.translated_content_id " . " AND {$dc}_translated_content.text_id={$dc}_text.text_id " . " AND " . getInTransactionRestriction( "{$dc}_translated_content", $transactionId ) . " AND " . getAtTransactionRestriction( "{$dc}_translated_content_attribute_values", $transactionId ) ); $recordSet = new ArrayRecordSet( $o->updatedTranslatedTextStructure, new Structure( $o->valueId, $o->language ) ); while ( $row = $dbr->fetchObject( $queryResult ) ) { $record = new ArrayRecord( $o->updatedTranslatedTextStructure ); $record->valueId = $row->value_id; $record->objectId = $row->object_id; $record->attribute = getDefinedMeaningReferenceRecord( $row->attribute_mid ); $record->translatedContentId = $row->translated_content_id; $record->language = $row->language_id; $record->text = $row->text_text; $record->operation = $row->operation; $record->isLatest = $row->is_latest; $record->rollBackTranslatedContent = simpleRecord( $o->rollBackTranslatedContentStructure, array( $row->is_latest, $row->operation, getTranslatedContentHistory( $row->translated_content_id, $row->language_id, $row->is_latest ) ) ); $recordSet->add( $record ); } return $recordSet; }
function getExternalIdentifiersSearchResultAsRecordSet($queryResult) { $dbr = wfGetDB(DB_SLAVE); $externalIdentifierMatchStructure = new Structure($this->externalIdentifierAttribute, $this->collectionAttribute, $this->collectionMemberAttribute); $recordSet = new ArrayRecordSet($externalIdentifierMatchStructure, new Structure($this->externalIdentifierAttribute)); while ($row = $dbr->fetchObject($queryResult)) { $record = new ArrayRecord($this->externalIdentifierMatchStructure); $record->setAttributeValue($this->externalIdentifierAttribute, $row->external_identifier); $record->setAttributeValue($this->collectionAttribute, $row->collection_mid); $record->setAttributeValue($this->collectionMemberAttribute, $row->member_mid); $recordSet->add($record); } expandDefinedMeaningReferencesInRecordSet($recordSet, array($this->collectionAttribute, $this->collectionMemberAttribute)); return $recordSet; }
function filterAttributeValues( RecordSet $sourceRecordSet, Attribute $attributeAttribute, array &$attributeIds ) { $result = new ArrayRecordSet( $sourceRecordSet->getStructure(), $sourceRecordSet->getKey() ); $i = 0; while ( $i < $sourceRecordSet->getRecordCount() ) { $record = $sourceRecordSet->getRecord( $i ); if ( in_array( $record->getAttributeValue( $attributeAttribute )->definedMeaningId, $attributeIds ) ) { $result->add( $record ); $sourceRecordSet->remove( $i ); } else $i++; } return $result; }