Class: WikidataPositionHistory::SPARQL::MandatesQuery

Inherits:
ItemQuery
  • Object
show all
Defined in:
lib/sparql/mandates_query.rb

Overview

SPARQL for fetching all officeholdings of a position

Instance Method Summary collapse

Methods inherited from ItemQuery

#initialize, #results_as, #wdqs_url

Constructor Details

This class inherits a constructor from WikidataPositionHistory::SPARQL::ItemQuery

Instance Method Details

#raw_sparql ⇒ Object 



7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 
# File 'lib/sparql/mandates_query.rb', line 7

def raw_sparql
  <<~SPARQL
    # position-mandates

    SELECT DISTINCT ?ordinal ?item ?start_date ?start_precision ?end_date ?end_precision ?prev ?next ?nature
    WHERE {
      ?item wdt:P31 wd:Q5 ; p:P39 ?posn .
      ?posn ps:P39 wd:%s .
      FILTER NOT EXISTS { ?posn wikibase:rank wikibase:DeprecatedRank }

      OPTIONAL { ?posn pqv:P580 [ wikibase:timeValue ?start_date; wikibase:timePrecision ?start_precision ] }
      OPTIONAL { ?posn pqv:P582 [ wikibase:timeValue ?end_date; wikibase:timePrecision ?end_precision ] }
      OPTIONAL { ?posn pq:P1365|pq:P155 ?prev }
      OPTIONAL { ?posn pq:P1366|pq:P156 ?next }
      OPTIONAL { ?posn pq:P1545 ?ordinal }
      OPTIONAL { ?posn pq:P5102 ?nature }
    }
    ORDER BY DESC(?start_date) ?item
  SPARQL
end