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_erc_pubsrepository.sql
1 
INSERT INTO datasources (_dnet_resource_identifier_, id, officialname, englishname, websiteurl, logourl, contactemail, latitude, longitude, timezone, namespaceprefix, collectedfrom, datasourceclass) VALUES ('openaire____::erc', 'openaire____::erc', 'European Research Council (ERC)', 'European Research Council (ERC)', 'http://erc.europa.eu', 'http://erc.europa.eu/sites/default/files/content/LOGO-ERC.jpg', 'Alexis-Michel.MUGABUSHAKA@ec.europa.eu', 50.85, 4.35, 1, 'erc_________', 'infrastruct_::openaire', 'pubsrepository::unknown');
2 
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass) VALUES ('api_________::erc::0', 'api_________::erc::0', 'file', 'openaire____::erc', 'pubsrepository::unknown', 'openaire3.0');
1 
INSERT INTO datasources (_dnet_resource_identifier_, id, officialname, englishname, websiteurl, logourl, contactemail, latitude, longitude, timezone, namespaceprefix, collectedfrom, datasourceclass)
2 
VALUES ('openaire____::erc', 'openaire____::erc', 'European Research Council (ERC)', 'European Research Council (ERC)', 'http://erc.europa.eu',
3 
                             'http://erc.europa.eu/sites/default/files/content/LOGO-ERC.jpg', 'Alexis-Michel.MUGABUSHAKA@ec.europa.eu', 50.85, 4.35, 1,
4 
                             'erc_________', 'infrastruct_::openaire', 'pubsrepository::unknown');
5 
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass)
6 
VALUES ('api_________::erc::0', 'api_________::erc::0', 'file', 'openaire____::erc', 'pubsrepository::unknown', 'openaire3.0');
3 7 
INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'file:///var/lib/dnet/erc/PUB_REPORTED.xml', 'api_________::erc::0');
4 8 
INSERT INTO apicollections (param, original, api) VALUES ('splitOnElement', 'RECORD', 'api_________::erc::0');
5 
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//PUB_ID', 'api_________::erc::0', false);
9 
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//PUB_ID', 'api_________::erc::0', FALSE);
6 10 

  		




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


  		




  
  11
  
    
UPDATE apicollections


  		




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


  		












Also available in:  Unified diff