/operations/indicateur/{id}

[ChristopheYon]

Ajout d'un endpoint renvoyant la description d'un indicateur (y compris le lien vers son rapport qualité)

Edit : ajout d'une proposition de requête et de réponse json

# Requête Magma-fusion pour le service /operations/indicateur/{id}

SELECT ?indicatorId  ?indicator 
?indicatorLabelLg1 ?indicatorLabelLg2 ?indicatorAltLabelLg1 ?indicatorAltLabelLg2 
?indicatorAbstractLg1 ?indicatorAbstractLg2 ?indicatorHistoryNoteLg1 ?indicatorHistoryNoteLg2 
?periodicity ?periodicityId ?periodicityLabelLg1 ?periodicityLabelLg2 
?wasGeneratedBySeries
?seeAlsoSeries ?seeAlsoIndicators
?sims ?simsId 
?created ?modified 
?creators ?publishers ?contributors
?validationState
WHERE {
	BIND('${indicatorId}' AS ?indicatorId)
	# NB: pour l'instant, les variables de langue ne sont pas reportées dans les sous-requêtes
	BIND('${LG1}' AS ?lg1)
	BIND('${LG2}' AS ?lg2)
	
	# Un indicateur est un StatisticalIndicator
	?indicator a insee:StatisticalIndicator .
	FILTER(STRAFTER(STR(?indicator),'/produits/indicateur/') = ?indicatorId ) .
	
	#Infos sur l'indicateur lui-même (tout en OPTIONAL pour éviter les problèmes)
	#Labels
	OPTIONAL {?indicator skos:prefLabel ?indicatorLabelLg1 . FILTER (lang(?indicatorLabelLg1) = ?lg1)}
	OPTIONAL {?indicator skos:prefLabel ?indicatorLabelLg2 . FILTER (lang(?indicatorLabelLg2) = ?lg2)}
	#Alt labels
	OPTIONAL {?indicator skos:altLabel ?indicatorAltLabelLg1 . FILTER (lang(?indicatorAltLabelLg1) = ?lg1)}
	OPTIONAL {?indicator skos:altLabel ?indicatorAltLabelLg2 . FILTER (lang(?indicatorAltLabelLg2) = ?lg2)}
	#Abstract
	OPTIONAL {?indicator dcterms:abstract ?indicatorAbstractLg1 . FILTER (lang(?indicatorAbstractLg1) = ?lg1)}
	OPTIONAL {?indicator dcterms:abstract ?indicatorAbstractLg2 . FILTER (lang(?indicatorAbstractLg2) = ?lg2)}
	#HistoryNote
	OPTIONAL {?indicator skos:historyNote ?indicatorHistoryNoteLg1 . FILTER (lang(?indicatorHistoryNoteLg1) = ?lg1)}
	OPTIONAL {?indicator skos:historyNote ?indicatorHistoryNoteLg2 . FILTER (lang(?indicatorHistoryNoteLg2) = ?lg2)}
	#Periodicity
	OPTIONAL { 
		?indicator dcterms:accrualPeriodicity ?periodicity . 
		OPTIONAL {?periodicity skos:notation ?periodicityId}
		OPTIONAL{?periodicity skos:prefLabel ?periodicityLabelLg1 . FILTER (lang(?periodicityLabelLg1) = ?lg1)}
		OPTIONAL{?periodicity skos:prefLabel ?periodicityLabelLg2 . FILTER (lang(?periodicityLabelLg2) = ?lg2)}
	}
	
	#Séries mères (il peut y en avoir plusieurs)
	OPTIONAL {
		SELECT ?indicator (GROUP_CONCAT(DISTINCT CONCAT(STR(?wasGeneratedBySerieId), '$', STR(?wasGeneratedBySerie), '$', COALESCE(?wasGeneratedBySerieLabelLg1, ''), '$', COALESCE(?wasGeneratedBySerieLabelLg2, '')) ; SEPARATOR='|') AS ?wasGeneratedBySeries)
		WHERE {
			?wasGeneratedBySerie a insee:StatisticalOperationSeries ; (^prov:wasGeneratedBy) ?indicator .
			BIND(STRAFTER(STR(?wasGeneratedBySerie),'/operations/serie/') AS ?wasGeneratedBySerieId ) .
			OPTIONAL {?wasGeneratedBySerie skos:prefLabel ?wasGeneratedBySerieLabelLg1 . FILTER (lang(?wasGeneratedBySerieLabelLg1) = '${LG1}')}
			OPTIONAL {?wasGeneratedBySerie skos:prefLabel ?wasGeneratedBySerieLabelLg2 . FILTER (lang(?wasGeneratedBySerieLabelLg2) = '${LG2}')}
		}
		GROUP BY ?indicator
	}
	
	# Autres objets liés à l'indicateur
	#Séries voir aussi
	OPTIONAL {
		SELECT ?indicator (GROUP_CONCAT(DISTINCT CONCAT(STR(?seeAlsoSerieId), '$', STR(?seeAlsoSerie), '$', COALESCE(?seeAlsoSerieLabelLg1, ''), '$', COALESCE(?seeAlsoSerieLabelLg2, '')) ; SEPARATOR='|') AS ?seeAlsoSeries)
		WHERE {
			?seeAlsoSerie a insee:StatisticalOperationSeries ; (^rdfs:seeAlso|rdfs:seeAlso) ?indicator .
			BIND(STRAFTER(STR(?seeAlsoSerie),'/operations/serie/') AS ?seeAlsoSerieId ) .
			OPTIONAL {?seeAlsoSerie skos:prefLabel ?seeAlsoSerieLabelLg1 . FILTER (lang(?seeAlsoSerieLabelLg1) = '${LG1}')}
			OPTIONAL {?seeAlsoSerie skos:prefLabel ?seeAlsoSerieLabelLg2 . FILTER (lang(?seeAlsoSerieLabelLg2) = '${LG2}')}
		}
		GROUP BY ?indicator
	}
	#Indicateurs voir aussi
	OPTIONAL {
		SELECT ?indicator (GROUP_CONCAT(DISTINCT CONCAT(STR(?seeAlsoIndicatorId), '$', STR(?seeAlsoIndicator), '$', COALESCE(?seeAlsoIndicatorLabelLg1, ''), '$', COALESCE(?seeAlsoIndicatorLabelLg2, '')) ; SEPARATOR='|') AS ?seeAlsoIndicators)
		WHERE {
			?seeAlsoIndicator a insee:StatisticalIndicator ; (^rdfs:seeAlso|rdfs:seeAlso) ?indicator .
			BIND(STRAFTER(STR(?seeAlsoIndicator),'/produits/indicateur/') AS ?seeAlsoIndicatorId ) .
			OPTIONAL {?seeAlsoIndicator skos:prefLabel ?seeAlsoIndicatorLabelLg1 . FILTER (lang(?seeAlsoIndicatorLabelLg1) = '${LG1}')}
			OPTIONAL {?seeAlsoIndicator skos:prefLabel ?seeAlsoIndicatorLabelLg2 . FILTER (lang(?seeAlsoIndicatorLabelLg2) = '${LG2}')}
		}
		GROUP BY ?indicator
	}
	#Sims
	OPTIONAL {
		?sims a sdmx-mm:MetadataReport; sdmx-mm:target ?indicator .
		BIND(STRAFTER(STR(?sims),'/qualite/rapport/') AS ?simsId)
	}
	
	# Informations de gestion
	# Dates
	OPTIONAL {?indicator dcterms:created ?created}
	OPTIONAL {?indicator dcterms:modified ?modified}
	
	# Agents
	# Creator
	OPTIONAL {
		SELECT ?indicator (GROUP_CONCAT(DISTINCT CONCAT(COALESCE(?creatorId, ''), '$', STR(?creator), '$', COALESCE(?creatorLabelLg1, ''), '$', COALESCE(?creatorLabelLg2, '')) ; SEPARATOR='|') AS ?creators)
		WHERE {
			?creator a org:Organization ; ^dc:creator ?indicator .
			OPTIONAL{?creator dct:identifier ?creatorId}
			OPTIONAL {?creator skos:prefLabel ?creatorLabelLg1 . FILTER (lang(?creatorLabelLg1) = '${LG1}')}
			OPTIONAL {?creator skos:prefLabel ?creatorLabelLg2 . FILTER (lang(?creatorLabelLg2) = '${LG2}')}
		}
		GROUP BY ?indicator
	}
	# Publisher
	OPTIONAL {
		SELECT ?indicator (GROUP_CONCAT(DISTINCT CONCAT(COALESCE(?publisherId, ''), '$', STR(?publisher), '$', COALESCE(?publisherLabelLg1, ''), '$', COALESCE(?publisherLabelLg2, '')) ; SEPARATOR='|') AS ?publishers)
		WHERE {
			?publisher a org:Organization ; ^dcterms:publisher ?indicator .
			OPTIONAL{?publisher dct:identifier ?publisherId}
			OPTIONAL {?publisher skos:prefLabel ?publisherLabelLg1 . FILTER (lang(?publisherLabelLg1) = '${LG1}')}
			OPTIONAL {?publisher skos:prefLabel ?publisherLabelLg2 . FILTER (lang(?publisherLabelLg2) = '${LG2}')}
		}
		GROUP BY ?indicator
	}
	# Contributor
	OPTIONAL {
		SELECT ?indicator (GROUP_CONCAT(DISTINCT CONCAT(COALESCE(?contributorId, ''), '$', STR(?contributor), '$', COALESCE(?contributorLabelLg1, ''), '$', COALESCE(?contributorLabelLg2, '')) ; SEPARATOR='|') AS ?contributors)
		WHERE {
			?contributor a org:Organization ; ^dcterms:contributor ?indicator .
			OPTIONAL{?contributor dct:identifier ?contributorId}
			OPTIONAL {?contributor skos:prefLabel ?contributorLabelLg1 . FILTER (lang(?contributorLabelLg1) = '${LG1}')}
			OPTIONAL {?contributor skos:prefLabel ?contributorLabelLg2 . FILTER (lang(?contributorLabelLg2) = '${LG2}')}
		}
		GROUP BY ?indicator
	}
	
	# Statut
	OPTIONAL {?indicator insee:validationState ?validationState}
}

Qui donnerait comme résultat :

{
  "id": "?indicatorId",
  "uri": "?indicator",
  "label": [
    {
      "contenu": ".indicatorLabelLg1",
      "langue": "?lg1"
    },
    {
      "contenu": "?indicatorLabelLg2",
      "langue": "?lg2"
    }
  ],
  "altLabel": [
    {
      "contenu": "?indicatorAltLabelLg1",
      "langue": "?lg1"
    },
    {
      "contenu": "?indicatorAltLabelLg2",
      "langue": "?lg2"
    }
  ],
  "resume": [
    {
      "contenu": "?indicatorAbstractLg1",
      "langue": "?lg1"
    },
    {
      "contenu": "?indicatorAbstractLg2",
      "langue": "?lg2"
    }
  ],
  "noteHistorique": [
    {
      "contenu": "?indicatorHistoryNoteLg1",
      "langue": "?lg1"
    },
    {
      "contenu": "?indicatorHistoryNoteLg2",
      "langue": "?lg2"
    }
  ],
  "frequenceCollecte": {
    "id": "?periodicityId",
    "uri": "?periodicity",
    "label": [
      {
        "contenu": "?periodicityLabelLg1",
        "langue": "?lg1"
      },
      {
        "contenu": "?periodicityLabelLg2",
        "langue": "?lg2"
      }
    ]
  },
  "rapportQualite": {
    "id": "?simsId",
    "uri": "?sims"
  },
  "seriesContributrices": [
    {
      "id": "wasGeneratedBySeries[1]",
      "uri": "wasGeneratedBySeries[2]",
      "label": [
        {
          "contenu": "wasGeneratedBySeries[3]",
          "langue": "?lg1"
        },
        {
          "contenu": "wasGeneratedBySeries[4]",
          "langue": "?lg2"
        }
      ]
    }
  ],
  "seriesLiees": [
    {
      "id": "?seeAlsoSeries[1]",
      "uri": "?seeAlsoSeries[2]", 
      "label": [
        {
          "contenu": "?seeAlsoSeriesseeAlsoSeries[3]",
          "langue": "?lg1"
        },
        {
          "contenu": "?seeAlsoSeries[4]",
          "langue": "?lg2"
        }
      ]
    }
  ],
  "indicateursLies": [
    {
      "id": "?indicators[1]",
      "uri": "?indicators[2]", 
      "label": [
        {
          "contenu": "?indicators[3]",
          "langue": "?lg1"
        },
        {
          "contenu": "?indicators[4]",
          "langue": "?lg2"
        }
      ]
    }
  ],
  "dateCreation": "?created", 
  "dateMiseAJour": "?modified",
  "proprietaires": [
    {
      "id": "?creators[1]",
      "uri": "?creators[2]",
      "label": [
        {
          "contenu": "?creators[3]",
          "langue": "?lg1"
        },
        {
          "contenu": "?creators[4]",
          "langue": "?lg2"
        }
      ]
    }
  ],
  "organismesResponsables": [
    {
      "id": "?publishers[1]",
      "uri": "?publishers[2]",
      "label": [
        {
          "contenu": "?publishers[3]",
          "langue": "?lg1"
        },
        {
          "contenu": "?publishers[4]",
          "langue": "?lg2"
        }
      ]
    }
  ],
  "partenaires": [
    {
      "id": "?contributors[1]",
      "uri": "?contributors[2]",
      "label": [
        {
          "contenu": "?contributors[3]",
          "langue": "?lg1"
        },
        {
          "contenu": "?contributors[4]",
          "langue": "?lg2"
        }
      ]
    }
  ],
  "statutValidation": "?validationState"
}

Même remarque que dans la carte pour /operations/serie/{id} : les ressources multiples sont regroupées dans des sous-requêtes avec des GROUP BY dans la requête proposée, ce qui nécessite des doubles split de chaîne de caractère en Java. Le choix fait pour /operations/serie/{id} s'appliquera de la même manière ici.