Project

General

Profile

« Previous | Next » 

Revision 48139

Added by Alessia Bardi almost 7 years ago

integrated (hopefully) all required changes from dnet40

View differences:

patch-fct.sql
9 9 
-- THEN RUN THE CLASS/SCHEME UPDATE FROM THE IS TO THE DB
10 10 

  		




  11
  11
  
    
--FCT ENTITY REGISTRY


  		




  12
  
  
    
INSERT INTO organizations (_dnet_resource_identifier_, id, legalshortname, legalname, websiteurl, logourl, countryclass, provenanceactionclass) VALUES ('fct_________::FCT', 'fct_________::FCT', 'FCT', 'Fundação para a Ciência e a Tecnologia, I.P.', 'http://www.fct.pt', 'http://www.fct.pt/images/FCT_H_color_v2011_b.png', 'PT', 'sysimport:crosswalk:entityregistry');


  		




  13
  
  
    
INSERT INTO datasources (_dnet_resource_identifier_, id, officialname, englishname, websiteurl, logourl, contactemail, latitude, longitude, timezone, namespaceprefix, collectedfrom, datasourceclass) VALUES ('openaire____::fct', 'openaire____::fct', 'FCT - Fundação para a Ciência e a Tecnologia', 'FCT - Foundation for Science and Technology', 'http://www.fct.pt', 'http://www.fct.pt/images/FCT_H_color_v2011_b.png', 'projectos@fct.pt', 38.71, -9.14, 0.0, 'fct_________', 'infrastruct_::openaire', 'entityregistry');


  		




  14
  
  
    
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass) VALUES ('api_________::fct::0', 'api_________::fct::0', 'filesystem', 'openaire____::fct', 'entityregistry', 'native');


  		




  
  12
  
    
INSERT INTO organizations (_dnet_resource_identifier_, id, legalshortname, legalname, websiteurl, logourl, countryclass, provenanceactionclass) VALUES


  		




  
  13
  
    
	('fct_________::FCT', 'fct_________::FCT', 'FCT', 'Fundação para a Ciência e a Tecnologia, I.P.', 'http://www.fct.pt',


  		




  
  14
  
    
	 'http://www.fct.pt/images/FCT_H_color_v2011_b.png', 'PT', 'sysimport:crosswalk:entityregistry');


  		




  
  15
  
    
INSERT INTO datasources (_dnet_resource_identifier_, id, officialname, englishname, websiteurl, logourl, contactemail, latitude, longitude, timezone, namespaceprefix, collectedfrom, datasourceclass)


  		




  
  16
  
    
VALUES


  		




  
  17
  
    
	('openaire____::fct', 'openaire____::fct', 'FCT - Fundação para a Ciência e a Tecnologia', 'FCT - Foundation for Science and Technology', 'http://www.fct.pt',


  		




  
  18
  
    
	                      'http://www.fct.pt/images/FCT_H_color_v2011_b.png', 'projectos@fct.pt', 38.71, -9.14, 0.0, 'fct_________', 'infrastruct_::openaire',


  		




  
  19
  
    
	 'entityregistry');


  		




  
  20
  
    
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass)


  		




  
  21
  
    
VALUES ('api_________::fct::0', 'api_________::fct::0', 'filesystem', 'openaire____::fct', 'entityregistry', 'native');


  		




  15
  22
  
    
INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'file:///var/lib/dnet/fct', 'api_________::fct::0');


  		




  16
  23
  
    
INSERT INTO apicollections (param, original, api) VALUES ('extensions', '*.xml', 'api_________::fct::0');


  		




  17
  
  
    
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '/project/id', 'api_________::fct::0', false);


  		




  18
  
  
    
UPDATE apicollections SET _dnet_resource_identifier_ = api||'@@'||param;


  		




  19
  
  
    
INSERT INTO datasource_organization (_dnet_resource_identifier_, datasource, organization) VALUES ('fct_________::fct@@fct_________::FCT', 'openaire____::fct', 'fct_________::FCT');


  		




  
  24
  
    
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '/project/id', 'api_________::fct::0', FALSE);


  		




  
  25
  
    
UPDATE apicollections


  		




  
  26
  
    
SET _dnet_resource_identifier_ = api || '@@' || param;


  		




  
  27
  
    
INSERT INTO datasource_organization (_dnet_resource_identifier_, datasource, organization)


  		




  
  28
  
    
VALUES ('fct_________::fct@@fct_________::FCT', 'openaire____::fct', 'fct_________::FCT');


  		




  20
  29
  
    

  		




  21
  30
  
    
 


  		












Also available in:  Unified diff