Heavy SQL Query - Githubissues

CRISalid-esr / svp-harvester

Sovisu+ publications harvester as microservice

Other

3 stars 2 forks source link

Heavy SQL Query #514

Open jdp1ps opened 5 months ago

jdp1ps commented 5 months ago

SELECT
  concepts.id,
  concepts.uri,
  concepts.dereferenced,
  concepts.last_dereferencing_date_time,
  labels_1.id AS id_1,
  labels_1.value,
  labels_1.language,
  labels_1.concept_id,
  labels_1.preferred
FROM
  concepts
LEFT OUTER JOIN
  labels AS labels_1
ON
  concepts.id = labels_1.concept_id
WHERE
  concepts.uri = $1::VARCHAR

jdp1ps commented 5 months ago

SELECT
  concepts.id AS concepts_id,
  concepts.uri AS concepts_uri,
  concepts.dereferenced AS concepts_dereferenced,
  concepts.last_dereferencing_date_time AS concepts_last_dereferencing_date_time,
  labels_1.id AS labels_1_id,
  labels_1.value AS labels_1_value,
  labels_1.language AS labels_1_language,
  labels_1.concept_id AS labels_1_concept_id,
  labels_1.preferred AS labels_1_preferred
FROM
  concepts
LEFT OUTER JOIN
  labels AS labels_1
ON
  concepts.id = labels_1.concept_id
WHERE
  concepts.id = $1::INTEGER

jdp1ps commented 5 months ago

SELECT
  concepts.id,
  concepts.uri,
  concepts.dereferenced,
  concepts.last_dereferencing_date_time,
  labels_1.id AS id_1,
  labels_1.value,
  labels_1.language,
  labels_1.concept_id,
  labels_1.preferred
FROM
  concepts
LEFT OUTER JOIN
  labels AS labels_1
ON
  concepts.id = labels_1.concept_id
WHERE
  concepts.uri = $1::VARCHAR

Paldana99 commented 5 months ago

For the DAO get_concept_by_uri, we can't set raise in label due that ScanR need the label scanr_references_converter