source: TI07-MOLES/trunk/MDIP/XQueries/NDG-MDIP.xquery @ 2236

import module namespace voclib='http://ndg.nerc.ac.uk/xquery/lib/vocab' at 'xmldb:exist:///db/xqueryLib/Vocabs/vocab_xquery_lib.xquery';
import module namespace utillib='http://ndg.nerc.ac.uk/xquery/lib/utilities' at 'xmldb:exist:///db/xqueryLib/Utilities/utility_xquery_lib.xquery';
declare default element namespace 'http://www.oceannet.org/mdip/xml';
declare namespace moles='http://ndg.nerc.ac.uk/moles';
declare namespace gco='http://www.isotc211.org/2005/gco';
declare namespace xsi='http://www.w3.org/2001/XMLSchema-instance'; 
declare variable $targetCollection as xs:string {'TargetCollection'};
declare variable $repositoryIdentifier as xs:string {'RepositoryID'};
declare variable $localIdentifier as xs:string {'LocalID'};

declare variable $ISO_639-2_ns as xs:string{$voclib:ISO_639-2_ns};
declare variable $ISO_3166_ns as xs:string{$voclib:ISO_3166_ns};

for $DE in collection($targetCollection)/moles:dgMetadata/moles:dgMetadataRecord[
        exists('moles:dgDataEntity') 
        and moles:dgMetadataID/moles:schemeIdentifier='NDG-B0' 
        and moles:dgMetadataID/moles:repositoryIdentifier=$repositoryIdentifier
        and moles:dgMetadataID/moles:localIdentifier=$localIdentifier]
return
element Metadata {
        element Title {data($DE/moles:name)},
        if (exists($DE/moles:dgDataEntity/moles:dgDataSummary/moles:dgDatasetLanguage)) then
                for $lang in $DE/moles:dgDataEntity/moles:dgDataSummary/moles:dgDatasetLanguage
                return
                        element Language{
                                element LanguageName {data($lang/dgValidTerm)},
                                element LanguageVocab {data($lang/dgValidTermID/ParentListID)},
                                element LanguageCode {data($lang/dgValidTermID/TermID)}
                        }
                                
        else (),

        element Abstract {},
        for $isoTopic in $DE/moles:dgStructuredKeyword[moles:dgValidTermID/moles:ParentListID=''] 
        return element TopicCategory {},
        for $subject in distinct-values($DE/dgDataEntity/dgDataSummary/dgParameterSummary/dgStdParameterMeasured[
        voclib:spot-vocab($voclib:gcmd_science_valids, dgValidTermID/ParentListID) 
        or voclib:spot-vocab($voclib:gcmd_project_valids, dgValidTermID/ParentListID)
        or voclib:spot-vocab($voclib:bodc_parameter_usage_vocab, dgValidTermID/ParentListID)
        or voclib:spot-vocab($voclib:bodc_parameter_discovery_vocab, dgValidTermID/ParentListID)
        ]/dgValidTerm) 
        return element Subject {$subject},
        element Date {
                element DatasetStartDate {},
                element DatasetEndDate {}
        }
}