1 |
33797
|
alessia.ba
|
-- REMEMBER TO UPDATE THE CLEANING RULE AND THE FOLLOWING VOCABULARIES:
|
2 |
|
|
-- aecdb60c-e1ed-40bd-a6c1-edc9993f07cb_Vm9jYWJ1bGFyeURTUmVzb3VyY2VzL1ZvY2FidWxhcnlEU1Jlc291cmNlVHlwZQ==
|
3 |
|
|
-- ecdd1e73-cf16-4a8b-8842-d0a7c780ab6e_Vm9jYWJ1bGFyeURTUmVzb3VyY2VzL1ZvY2FidWxhcnlEU1Jlc291cmNlVHlwZQ==
|
4 |
|
|
-- AND TO REGISTER:
|
5 |
|
|
-- 3470afb2-d15f-4046-988e-7a7a2f7c993b_Vm9jYWJ1bGFyeURTUmVzb3VyY2VzL1ZvY2FidWxhcnlEU1Jlc291cmNlVHlwZQ==
|
6 |
|
|
-- 5d11b639-51c3-4dc3-a2aa-da0ad168e768_Vm9jYWJ1bGFyeURTUmVzb3VyY2VzL1ZvY2FidWxhcnlEU1Jlc291cmNlVHlwZQ==
|
7 |
|
|
-- ec216410-9ebc-4547-bb4a-190acb0985ef_Vm9jYWJ1bGFyeURTUmVzb3VyY2VzL1ZvY2FidWxhcnlEU1Jlc291cmNlVHlwZQ==
|
8 |
|
|
|
9 |
|
|
-- THEN RUN THE CLASS/SCHEME UPDATE FROM THE IS TO THE DB
|
10 |
|
|
|
11 |
32278
|
sandro.lab
|
--FCT ENTITY REGISTRY
|
12 |
48139
|
alessia.ba
|
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');
|
22 |
31914
|
michele.ar
|
INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'file:///var/lib/dnet/fct', 'api_________::fct::0');
|
23 |
|
|
INSERT INTO apicollections (param, original, api) VALUES ('extensions', '*.xml', 'api_________::fct::0');
|
24 |
48139
|
alessia.ba
|
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');
|
29 |
33217
|
michele.ar
|
|