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