function getInternalIdentifier( $dc, $definedMeaningId, $languageId ) {
$collectionName = "uw";
$dbr = wfGetDB( DB_SLAVE );
$query = "SELECT collection_id, internal_member_id FROM {$dc}_collection_contents where member_mid = $definedMeaningId";
$queryResult = $dbr->query( "SELECT collection_id, internal_member_id FROM {$dc}_collection_contents where member_mid = $definedMeaningId" );
if ( $row = $dbr->fetchObject( $queryResult ) ) {
$internalMemberId = $row->internal_member_id;
$collectionDefinedMeaningId = getCollectionMeaningId( $row->collection_id );
$queryResult = $dbr->query( "SELECT meaning_text_tcid FROM {$dc}_defined_meaning where defined_meaning_id = $collectionDefinedMeaningId" );
if ( $row = $dbr->fetchObject( $queryResult ) ) {
$queryResult = $dbr->query( "SELECT text_id FROM {$dc}_translated_content where translated_content_id = $row->meaning_text_tcid" );
if ( $row = $dbr->fetchObject( $queryResult ) ) {
$queryResult = $dbr->query( "SELECT text_text FROM {$dc}_text where text_id = $row->text_id" );
if ( $row = $dbr->fetchObject( $queryResult ) ) {
if ( $row->text_text == "Swiss-Prot" ) {
$collectionName = "uniprot";
}
}
}
}
return $collectionName . '/' . $internalMemberId;
}
else {
return "";
}
}
function getDefinedMeaningCollectionMembershipRecordSet( $definedMeaningId, ViewInformation $viewInformation ) {
global
$dataSet;
$o = OmegaWikiAttributes::getInstance();
$recordSet = queryRecordSet(
$o->collectionMembershipStructure->getStructureType(),
$viewInformation->queryTransactionInformation,
$o->collectionId,
new TableColumnsToAttributesMapping(
new TableColumnsToAttribute( array( 'collection_id' ), $o->collectionId ),
new TableColumnsToAttribute( array( 'internal_member_id' ), $o->sourceIdentifier )
),
$dataSet->collectionMemberships,
array( "member_mid=$definedMeaningId" )
);
$structure = $recordSet->getStructure();
$structure->addAttribute( $o->collectionMeaning );
$structure->addAttribute( $o->gotoSource );
for ( $i = 0; $i < $recordSet->getRecordCount(); $i++ ) {
$record = $recordSet->getRecord( $i );
$record->collectionMeaning = getCollectionMeaningId( $record->collectionId );
$record->gotoSource = getGotoSourceRecord( $record );
}
expandDefinedMeaningReferencesInRecordSet( $recordSet, array( $o->collectionMeaning ) );
return $recordSet;
}
function collectionAsLink( $collectionId ) {
return definedMeaningAsLink( getCollectionMeaningId( $collectionId ) );
}
function importUMLSDefinitions( $sab, $umlsCollectionId, $sourceCollectionId, $languageId ) {
global
$db;
$queryResult = mysql_query( "select def, cui from MRDEF where sab = '$sab'", $db );
$progressBar = new ProgressBar( mysql_num_rows( $queryResult ), 100 );
$collectionMeaningId = getCollectionMeaningId( $sourceCollectionId );
while ( $definition = mysql_fetch_object( $queryResult ) ) {
$definedMeaningId = getDefinedMeaningFromCollection( $umlsCollectionId, $definition->cui );
if ( $definedMeaningId ) {
if ( !getDefinedMeaningDefinitionId( $definedMeaningId ) )
addDefinedMeaningDefiningDefinition( $definedMeaningId, $languageId, $definition->def );
addDefinedMeaningAlternativeDefinition( $definedMeaningId, $languageId, $definition->def, $collectionMeaningId );
}
$progressBar->advance( 1 );
}
mysql_free_result( $queryResult );
$progressBar->clear();
}
