Ticket #72 (closed defect: fixed)

Opened 12 years ago

Last modified 12 years ago

bmap_repo has incorrect FMA Terms

Reported by: joshuadf Owned by: joshuadf
Priority: minor Milestone:
Component: systems Version:
Keywords: Cc:

Description

The FMA terms in the bmap_repo do not have the first letter capitalized, which causes distributed XQueries to fail (or requires some crazy query). The FMA terms can be listed by running this with mysql bmap_repo on sphenoid:

SELECT fullname FROM Term WHERE authority = 'FMA';

Change History

comment:1 Changed 12 years ago by joshuadf

  • Status changed from new to closed
  • Resolution set to fixed

Todd gave me this info:

The convention in the FMA is that the first word is capitalized as well as proper names and certain abbreviations (i.e. rDNA). Hopefully there aren't any eponyms or abbreviations in bmap_repo.

I ran the list of terms from bmap_repo through the following perl code:

if (/^[a-z].*/) {
        $orig = $_;
#opercular part of inferior frontal gyrus
        s/^(.)(.*)/\U$1\E$2/g;
#Opercular part of inferior frontal gyrus
        $outstmt = "UPDATE Term set fullname = \'";
        $outstmt .= $_;
        $outstmt .= "\' WHERE authority = 'FMA' AND fullname = \'";
        $outstmt .= $orig;
        $outstmt .= "\';\n";
        print $outstmt;
# UPDATE Term set fullname = 'Opercular part of inferior frontal gyrus' 
# WHERE authority = 'FMA' 
# AND fullname = 'opercular part of inferior frontal gyrus';
        }

Distributed queries should work as soon as the updates trickle into the SaxonWebService XML.

Note: See TracTickets for help on using tickets.