Project

General

Profile

« Previous | Next » 

Revision 61500

Added by Alessia Bardi almost 3 years ago

#6902 : SQL commands to update the eosc ds table

View differences:

modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/eosc-datasources.sql
38 38 
-- note that ids are from beta (in the hope that they are the same in prod)
39 39 

  		




  40
  40
  
    
-- Crossref is an entity registry (of products) with global jurisdiction


  		




  
  41
  
    
UPDATE dsm_datasources SET typology='entityregistry::products' WHERE id='openaire____::crossref';


  		




  
  42
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  43
  
    
VALUES('openaire____::crossref', 'openaire____::crossref', 'Global');


  		




  41
  44
  
    

  		




  42
  45
  
    
-- Datacite is an entity registry (of products) with global jurisdiction


  		




  
  46
  
    
UPDATE dsm_datasources SET typology='entityregistry::products' WHERE id='openaire____::datacite';


  		




  
  47
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  48
  
    
VALUES('openaire____::datacite', 'openaire____::datacite', 'Global');


  		




  43
  49
  
    

  		




  44
  50
  
    
-- ORCID is an entity registry (of persons) with global jurisdiction


  		




  
  51
  
    
UPDATE dsm_datasources SET typology='entityregistry::researchers' WHERE id='openaire____::orcid';


  		




  
  52
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  53
  
    
VALUES('openaire____::orcid', 'openaire____::orcid', 'Global');


  		




  45
  54
  
    

  		




  46
  55
  
    
-- ROR is an entity registry (of orgs) with global jurisdicition


  		




  
  56
  
    
UPDATE dsm_datasources SET typology='entityregistry::organizations' WHERE id='openaire____::ROR';


  		




  
  57
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  58
  
    
VALUES('openaire____::ROR', 'openaire____::ROR', 'Global');


  		




  47
  59
  
    

  		




  48
  60
  
    
-- Grid.ac is an entity registry (of orgs) with global jurisdicition


  		




  
  61
  
    
UPDATE dsm_datasources SET typology='entityregistry::organizations' WHERE id='openaire____::grid';


  		




  
  62
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  63
  
    
VALUES('openaire____::grid', 'openaire____::grid', 'Global');


  		




  49
  64
  
    

  		




  50
  65
  
    
-- re3data is an entity registry (of data sources) with global jurisdiction


  		




  
  66
  
    
UPDATE dsm_datasources SET typology='entityregistry::repositories' WHERE id='openaire____::re3data';


  		




  
  67
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  68
  
    
VALUES('openaire____::re3data', 'openaire____::re3data', 'Global');


  		




  51
  69
  
    

  		




  
  70
  
    

  		




  52
  71
  
    
-- opendoar is an entity registry (of data sources) with global jurisdiction


  		




  
  72
  
    
UPDATE dsm_datasources SET typology='entityregistry::repositories' WHERE id='openaire____::opendoar';


  		




  
  73
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  74
  
    
VALUES('openaire____::opendoar', 'openaire____::opendoar', 'Global');


  		




  53
  75
  
    

  		




  54
  76
  
    
-- Unpaywall is an aggregator with global jurisdiction


  		




  
  77
  
    
UPDATE dsm_datasources SET typology='aggregator::pubsrepository::unknown' WHERE id='openaire____::unpaywall';


  		




  
  78
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  79
  
    
VALUES('openaire____::unpaywall', 'openaire____::unpaywall', 'Global');


  		




  55
  80
  
    

  		




  56
  81
  
    
-- MAG is an aggregator with global jurisdiction and knowledge graph = true


  		




  
  82
  
    
UPDATE dsm_datasources SET typology='aggregator::pubsrepository::unknown' WHERE id='openaire____::microsoft';


  		




  
  83
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction, knowledge_graph)


  		




  
  84
  
    
VALUES('openaire____::microsoft', 'openaire____::microsoft', 'Global', true);


  		




  57
  85
  
    

  		




  58
  86
  
    
-- OpenAIRE is an aggregator with global jurisdiction and knowledge graph = true


  		




  
  87
  
    
--UPDATE dsm_datasources SET typology='aggregator' WHERE id='infrastruct_::openaire';


  		




  
  88
  
    
UPDATE dsm_datasources_eosc SET knowledge_graph = true WHERE _dnet_resource_identifier_ = 'infrastruct_::openaire';


  		




  59
  89
  
    

  		




  60
  90
  
    
-- ScholeXplorer is an aggregator with global jurisdiction and knowledge graph = true


  		




  
  91
  
    
--UPDATE dsm_datasources SET typology='aggregator' WHERE id='openaire____::scholexplorer';


  		




  
  92
  
    
UPDATE dsm_datasources_eosc SET knowledge_graph = true WHERE _dnet_resource_identifier_ = 'openaire____::scholexplorer';


  		




  61
  93
  
    

  		




  
  94
  
    

  		




  62
  95
  
    
-- patstat has a regional jurisdiction


  		




  
  96
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  97
  
    
VALUES('openaire____::EPO', 'openaire____::EPO', 'Regional');


  		




  63
  98
  
    

  		




  64
  99
  
    
-- Software Heritage is an aggregator with global jurisdiction


  		




  
  100
  
    
UPDATE dsm_datasources SET typology='aggregator::softwarerepository' WHERE id='openaire____::SoftwareHeritage';


  		




  
  101
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  102
  
    
VALUES('openaire____::SoftwareHeritage', 'openaire____::SoftwareHeritage', 'Global');


  		




  65
  103
  
    

  		




  66
  104
  
    
-- bio.tools is thematic


  		




  
  105
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, thematic)


  		




  
  106
  
    
VALUES('rest________::bioTools', 'rest________::bioTools', true);


  		




  67
  107
  
    

  		




  68
  
  
    
-- PubMed is thematic


  		




  69
  108
  
    

  		




  70
  109
  
    

  		




  
  110
  
    
--DRIVER is an aggregator with global jurisdiction


  		




  
  111
  
    
UPDATE dsm_datasources SET typology='aggregator::pubsrepository::unknown' WHERE id='openaire____::driver';


  		




  
  112
  
    
INSERT INTO dsm_datasources_eosc(id, _dnet_resource_identifier_, jurisdiction)


  		




  
  113
  
    
VALUES('openaire____::driver', 'openaire____::driver', 'Global');


  		




  71
  114
  
    

  		




  72
  115
  
    

  		




  73
  
  
    

  		




  
  116
  
    
-- FIX DOAJ journals with the proper content policies until we fix the transformation (#6970)


  		




  
  117
  
    
UPDATE dsm_datasources_eosc SET content_policies = ARRAY ['Journal articles'] where id like 'doajarticles%';


  		












Also available in:  Unified diff