NCI-Semantic-Infrastructure / shared-si-issues

Umbrella repo for Shared SI Service issues
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

modsec rule for ~ Q9 & Q15 #11

Open fragosog opened 11 months ago

fragosog commented 11 months ago

new modsec rule. for queries like Q9 and Q15. Q9:

prefix srro: <http://ncicb.nci.nih.gov/srro.owl#>
select distinct ?entity (str(?preferred_term) as ?PT) (str(?definition) as ?def) (group_concat( distinct str(?term); separator="\n") as ?terms)  (group_concat( distinct str(?name_value); separator="\n") as ?all_props) 
from <http://ncicb.nci.nih.gov/xml/owl/EVS/Thesaurus.rdf>
where {
  values ?identifier { "C113525"  "C113525"^^xsd:string }
  ?entity ?identifier_property ?identifier ;
             ?preferred_term_property ?preferred_term ;
             ?definition_property ?definition ;
             ?term_property ?ter ;
             ?property ?value .
   ?property  ?preferred_term_property ?property_name .
   ?term_property ?preferred_term_property ?term_prop_name .
  { ?property a owl:AnnotationProperty } union { ?property a owl:ObjectProperty } union { ?property a rdf:Property }
  bind (concat(str(?term_prop_name), ": ", str(?ter)) as ?term)
  bind (concat(str(?property_name), ": ", str(?value)) as ?name_value)

  {
    select ?identifier_property ?preferred_term_property ?term_property ?definition_property
    from <http://ncicb.nci.nih.gov/srro>
    where {
      values ?resource {  srro:NCIt }
      ?resource srro:hasIdentifier ?identifier_property .
      ?resource srro:hasPreferredTerm ?preferred_term_property .
      ?resource srro:hasTerm ?term_property .
      ?resource srro:hasDefinition ?definition_property .
    }
  }
} group by ?entity ?preferred_term ?definition order by ?entity