Revision 48139
Added by Alessia Bardi almost 7 years ago
patch.sql | ||
---|---|---|
1 |
ALTER TABLE datasources ADD COLUMN issn character varying(20); |
|
2 |
ALTER TABLE datasources ADD COLUMN eissn character varying(20); |
|
3 |
ALTER TABLE datasources ADD COLUMN lissn character varying(20); |
|
4 |
ALTER TABLE datasources ALTER COLUMN databaseaccesstype TYPE VARCHAR(32); |
|
5 |
ALTER TABLE datasources ALTER COLUMN datauploadtype TYPE VARCHAR(32); |
|
6 |
ALTER TABLE datasources ALTER COLUMN databaseaccessrestriction TYPE VARCHAR(32); |
|
7 |
ALTER TABLE datasources ALTER COLUMN datauploadrestriction TYPE VARCHAR(32); |
|
8 |
ALTER TABLE datasources ALTER COLUMN qualitymanagementkind TYPE VARCHAR(32); |
|
1 |
ALTER TABLE datasources |
|
2 |
ADD COLUMN issn CHARACTER VARYING(20); |
|
3 |
ALTER TABLE datasources |
|
4 |
ADD COLUMN eissn CHARACTER VARYING(20); |
|
5 |
ALTER TABLE datasources |
|
6 |
ADD COLUMN lissn CHARACTER VARYING(20); |
|
7 |
ALTER TABLE datasources |
|
8 |
ALTER COLUMN databaseaccesstype TYPE VARCHAR(32); |
|
9 |
ALTER TABLE datasources |
|
10 |
ALTER COLUMN datauploadtype TYPE VARCHAR(32); |
|
11 |
ALTER TABLE datasources |
|
12 |
ALTER COLUMN databaseaccessrestriction TYPE VARCHAR(32); |
|
13 |
ALTER TABLE datasources |
|
14 |
ALTER COLUMN datauploadrestriction TYPE VARCHAR(32); |
|
15 |
ALTER TABLE datasources |
|
16 |
ALTER COLUMN qualitymanagementkind TYPE VARCHAR(32); |
|
9 | 17 |
|
10 |
ALTER TABLE datasources ADD COLUMN registeredby character varying(255); |
|
18 |
ALTER TABLE datasources |
|
19 |
ADD COLUMN registeredby CHARACTER VARYING(255); |
|
11 | 20 |
|
12 |
DELETE FROM apicollections WHERE api NOT LIKE 'api_________::%'; |
|
13 |
DELETE FROM api WHERE id NOT LIKE 'api_________::%'; |
|
21 |
DELETE FROM apicollections |
|
22 |
WHERE api NOT LIKE 'api_________::%'; |
|
23 |
DELETE FROM api |
|
24 |
WHERE id NOT LIKE 'api_________::%'; |
|
14 | 25 |
|
15 |
ALTER TABLE apicollections DROP COLUMN name; |
|
16 |
ALTER TABLE apicollections RENAME COLUMN accessparam TO param; |
|
17 |
ALTER TABLE apicollections RENAME COLUMN accessvalue TO original; |
|
18 |
ALTER TABLE apicollections ADD COLUMN edited VARCHAR(255) DEFAULT NULL; |
|
19 |
ALTER TABLE apicollections ADD COLUMN accessparam boolean DEFAULT true; |
|
20 |
ALTER TABLE apicollections DROP CONSTRAINT apicollection_pkey; |
|
21 |
ALTER TABLE apicollections ALTER COLUMN original SET DEFAULT ''; |
|
26 |
ALTER TABLE apicollections |
|
27 |
DROP COLUMN name; |
|
28 |
ALTER TABLE apicollections |
|
29 |
RENAME COLUMN accessparam TO param; |
|
30 |
ALTER TABLE apicollections |
|
31 |
RENAME COLUMN accessvalue TO original; |
|
32 |
ALTER TABLE apicollections |
|
33 |
ADD COLUMN edited VARCHAR(255) DEFAULT NULL; |
|
34 |
ALTER TABLE apicollections |
|
35 |
ADD COLUMN accessparam BOOLEAN DEFAULT TRUE; |
|
36 |
ALTER TABLE apicollections |
|
37 |
DROP CONSTRAINT apicollection_pkey; |
|
38 |
ALTER TABLE apicollections |
|
39 |
ALTER COLUMN original SET DEFAULT ''; |
|
22 | 40 |
|
23 |
UPDATE apicollections SET param = 'set' WHERE param = 'SET'; |
|
24 |
UPDATE apicollections SET param = 'format' WHERE param = 'FORMAT'; |
|
25 |
UPDATE apicollections SET param = 'baseUrl' WHERE param = 'BASEURL'; |
|
41 |
UPDATE apicollections |
|
42 |
SET param = 'set' |
|
43 |
WHERE param = 'SET'; |
|
44 |
UPDATE apicollections |
|
45 |
SET param = 'format' |
|
46 |
WHERE param = 'FORMAT'; |
|
47 |
UPDATE apicollections |
|
48 |
SET param = 'baseUrl' |
|
49 |
WHERE param = 'BASEURL'; |
|
26 | 50 |
|
27 | 51 |
-- FIX A PROBLEM WITH MULTIPLE SET |
28 |
DELETE FROM apicollections WHERE api='api_________::opendoar____::1560::1' AND param='set'; |
|
29 |
INSERT INTO apicollections (param, original, api) VALUES ('set', 'hdl_10251_3829, hdl_10251_321, hdl_10251_11256, hdl_10251_11206, hdl_10251_8702, hdl_10251_3026, hdl_10251_11076', 'api_________::opendoar____::1560::1'); |
|
30 |
DELETE FROM apicollections WHERE api='api_________::driver______::d0b68287-678d-4efc-b354-c47cbacaed3c::0' AND param='set'; |
|
31 |
INSERT INTO apicollections (param, original, api) VALUES ('set', 'pub-type:article, pub-type:conf-proceeding, pub-type:lecture, pub-type:paper, pub-type:report', 'api_________::driver______::d0b68287-678d-4efc-b354-c47cbacaed3c::0'); |
|
32 |
DELETE FROM apicollections WHERE api='api_________::driver______::79476713-c428-4f23-bf97-8f27500f754a::0' AND param='set'; |
|
33 |
INSERT INTO apicollections (param, original, api) VALUES ('set', 'dad:SIQG, jhs,sal:CNF+PA', 'api_________::driver______::79476713-c428-4f23-bf97-8f27500f754a::0'); |
|
34 |
DELETE FROM apicollections WHERE api='api_________::opendoar____::202::0' AND param='set'; |
|
35 |
INSERT INTO apicollections (param, original, api) VALUES ('set', 'hdl_1887_4540, hdl_1887_4951', 'api_________::opendoar____::202::0'); |
|
36 |
DELETE FROM apicollections WHERE api='api_________::driver______::c75b9f23-25a8-4e45-aadd-ba449211e2a8::0' AND param='set'; |
|
37 |
INSERT INTO apicollections (param, original, api) VALUES ('set', 'ijdc:ART, ijdc:PAP', 'api_________::driver______::c75b9f23-25a8-4e45-aadd-ba449211e2a8::0'); |
|
52 |
DELETE FROM apicollections |
|
53 |
WHERE api = 'api_________::opendoar____::1560::1' AND param = 'set'; |
|
54 |
INSERT INTO apicollections (param, original, api) VALUES |
|
55 |
('set', 'hdl_10251_3829, hdl_10251_321, hdl_10251_11256, hdl_10251_11206, hdl_10251_8702, hdl_10251_3026, hdl_10251_11076', |
|
56 |
'api_________::opendoar____::1560::1'); |
|
57 |
DELETE FROM apicollections |
|
58 |
WHERE api = 'api_________::driver______::d0b68287-678d-4efc-b354-c47cbacaed3c::0' AND param = 'set'; |
|
59 |
INSERT INTO apicollections (param, original, api) VALUES |
|
60 |
('set', 'pub-type:article, pub-type:conf-proceeding, pub-type:lecture, pub-type:paper, pub-type:report', |
|
61 |
'api_________::driver______::d0b68287-678d-4efc-b354-c47cbacaed3c::0'); |
|
62 |
DELETE FROM apicollections |
|
63 |
WHERE api = 'api_________::driver______::79476713-c428-4f23-bf97-8f27500f754a::0' AND param = 'set'; |
|
64 |
INSERT INTO apicollections (param, original, api) |
|
65 |
VALUES ('set', 'dad:SIQG, jhs,sal:CNF+PA', 'api_________::driver______::79476713-c428-4f23-bf97-8f27500f754a::0'); |
|
66 |
DELETE FROM apicollections |
|
67 |
WHERE api = 'api_________::opendoar____::202::0' AND param = 'set'; |
|
68 |
INSERT INTO apicollections (param, original, api) VALUES ('set', 'hdl_1887_4540, hdl_1887_4951', 'api_________::opendoar____::202::0'); |
|
69 |
DELETE FROM apicollections |
|
70 |
WHERE api = 'api_________::driver______::c75b9f23-25a8-4e45-aadd-ba449211e2a8::0' AND param = 'set'; |
|
71 |
INSERT INTO apicollections (param, original, api) VALUES ('set', 'ijdc:ART, ijdc:PAP', 'api_________::driver______::c75b9f23-25a8-4e45-aadd-ba449211e2a8::0'); |
|
38 | 72 |
-- AND FIX |
39 | 73 |
|
40 |
ALTER TABLE apicollections ADD CONSTRAINT apicollection_pkey PRIMARY KEY (api, param); |
|
74 |
ALTER TABLE apicollections |
|
75 |
ADD CONSTRAINT apicollection_pkey PRIMARY KEY (api, param); |
|
41 | 76 |
|
42 |
INSERT INTO apicollections (param, original, edited, api) SELECT 'baseUrl', COALESCE(original,''), COALESCE(edited, ''), id FROM api WHERE originalprotocolclass = editedprotocolclass; |
|
43 |
INSERT INTO apicollections (param, original, api) SELECT 'baseUrl', COALESCE(original,''), id FROM api WHERE originalprotocolclass != editedprotocolclass OR editedprotocolclass IS NULL; |
|
44 |
UPDATE apicollections SET edited = NULL WHERE edited = ''; |
|
77 |
INSERT INTO apicollections (param, original, edited, api) SELECT |
|
78 |
'baseUrl', |
|
79 |
COALESCE(original, ''), |
|
80 |
COALESCE(edited, ''), |
|
81 |
id |
|
82 |
FROM api |
|
83 |
WHERE originalprotocolclass = editedprotocolclass; |
|
84 |
INSERT INTO apicollections (param, original, api) SELECT |
|
85 |
'baseUrl', |
|
86 |
COALESCE(original, ''), |
|
87 |
id |
|
88 |
FROM api |
|
89 |
WHERE originalprotocolclass != editedprotocolclass OR editedprotocolclass IS NULL; |
|
90 |
UPDATE apicollections |
|
91 |
SET edited = NULL |
|
92 |
WHERE edited = ''; |
|
45 | 93 |
|
46 |
UPDATE datasources SET datasourceclass = 'websource' where id = 'openaire____::webcrawl'; |
|
94 |
UPDATE datasources |
|
95 |
SET datasourceclass = 'websource' |
|
96 |
WHERE id = 'openaire____::webcrawl'; |
|
47 | 97 |
|
48 | 98 |
INSERT INTO apicollections (param, original, api) VALUES ('splitOnElement', 'repository', 'api_________::opendoar::0'); |
49 | 99 |
INSERT INTO apicollections (param, original, api) VALUES ('splitOnElement', 'ROW', 'api_________::re3data::0'); |
50 | 100 |
INSERT INTO apicollections (param, original, api) VALUES ('splitOnElement', 'Record', 'api_________::wellcometrust::0'); |
51 | 101 |
INSERT INTO apicollections (param, original, api) VALUES ('splitOnElement', 'ROW', 'api_________::corda::0'); |
52 | 102 |
|
53 |
UPDATE apicollections SET _dnet_resource_identifier_ = api||'@@'||param; |
|
103 |
UPDATE apicollections |
|
104 |
SET _dnet_resource_identifier_ = api || '@@' || param; |
|
54 | 105 |
|
55 |
INSERT INTO scheme (_dnet_resource_identifier_, code, name) VALUES ('dnet:content_description_typologies', 'dnet:content_description_typologies', 'D-Net Content Description Typologies'); |
|
106 |
INSERT INTO scheme (_dnet_resource_identifier_, code, name) |
|
107 |
VALUES ('dnet:content_description_typologies', 'dnet:content_description_typologies', 'D-Net Content Description Typologies'); |
|
56 | 108 |
|
57 |
INSERT INTO class (_dnet_resource_identifier_, code, name) VALUES ('UNKNOWN', 'UNKNOWN', 'UNKNOWN');
|
|
109 |
INSERT INTO class (_dnet_resource_identifier_, code, name) VALUES ('UNKNOWN', 'UNKNOWN', 'UNKNOWN'); |
|
58 | 110 |
|
59 | 111 |
INSERT INTO class (_dnet_resource_identifier_, code, name) VALUES ('native', 'native', 'native'); |
60 | 112 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) VALUES ('native@@dnet:compatibilityLevel', 'native', 'dnet:compatibilityLevel'); |
... | ... | |
66 | 118 |
INSERT INTO class (_dnet_resource_identifier_, code, name) VALUES ('file::PDF', 'file::PDF', 'file::PDF'); |
67 | 119 |
INSERT INTO class (_dnet_resource_identifier_, code, name) VALUES ('file::EuropePMC', 'file::EuropePMC', 'file::EuropePMC'); |
68 | 120 |
|
69 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) VALUES ('metadata@@dnet:content_description_typologies', 'metadata', 'dnet:content_description_typologies'); |
|
70 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) VALUES ('file::WoS@@dnet:content_description_typologies', 'file::WoS', 'dnet:content_description_typologies'); |
|
71 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) VALUES ('file::PDF@@dnet:content_description_typologies', 'file::PDF', 'dnet:content_description_typologies'); |
|
72 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) VALUES ('file::EuropePMC@@dnet:content_description_typologies', 'file::EuropePMC', 'dnet:content_description_typologies'); |
|
121 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) |
|
122 |
VALUES ('metadata@@dnet:content_description_typologies', 'metadata', 'dnet:content_description_typologies'); |
|
123 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) |
|
124 |
VALUES ('file::WoS@@dnet:content_description_typologies', 'file::WoS', 'dnet:content_description_typologies'); |
|
125 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) |
|
126 |
VALUES ('file::PDF@@dnet:content_description_typologies', 'file::PDF', 'dnet:content_description_typologies'); |
|
127 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) |
|
128 |
VALUES ('file::EuropePMC@@dnet:content_description_typologies', 'file::EuropePMC', 'dnet:content_description_typologies'); |
|
73 | 129 |
|
74 |
ALTER TABLE api ADD COLUMN contentdescriptionclass VARCHAR(255) DEFAULT 'metadata'; |
|
75 |
ALTER TABLE api ADD COLUMN contentdescriptionscheme VARCHAR(255) DEFAULT 'dnet:content_description_typologies'; |
|
76 |
ALTER TABLE api DROP COLUMN editedprotocolclass; |
|
77 |
ALTER TABLE api DROP COLUMN editedprotocolscheme; |
|
78 |
ALTER TABLE api DROP COLUMN original; |
|
79 |
ALTER TABLE api DROP COLUMN edited; |
|
80 |
ALTER TABLE api DROP COLUMN useedited; |
|
81 |
ALTER TABLE api RENAME COLUMN originalprotocolclass TO protocolclass; |
|
82 |
ALTER TABLE api RENAME COLUMN originalprotocolscheme TO protocolscheme; |
|
83 |
ALTER TABLE api ADD COLUMN active BOOLEAN DEFAULT false; |
|
84 |
ALTER TABLE api ADD COLUMN removable BOOLEAN DEFAULT false; |
|
85 |
ALTER TABLE api ADD COLUMN typologyclass VARCHAR(255) DEFAULT 'UNKNOWN'; |
|
86 |
ALTER TABLE api ADD COLUMN typologyscheme VARCHAR(255) DEFAULT 'dnet:datasource_typologies'; |
|
87 |
ALTER TABLE api ADD CONSTRAINT api_typologyclass_fkey FOREIGN KEY (typologyclass) REFERENCES class(code); |
|
88 |
ALTER TABLE api ADD CONSTRAINT api_typologyscheme_fkey FOREIGN KEY (typologyscheme) REFERENCES scheme(code); |
|
89 |
ALTER TABLE api ADD COLUMN compatibilityclass VARCHAR(255) DEFAULT 'UNKNOWN'; |
|
90 |
ALTER TABLE api ADD COLUMN compatibilityscheme VARCHAR(255) DEFAULT 'dnet:compatibilityLevel'; |
|
91 |
ALTER TABLE api ADD CONSTRAINT api_compatibilityclass_fkey FOREIGN KEY (compatibilityclass) REFERENCES class(code); |
|
92 |
ALTER TABLE api ADD CONSTRAINT api_compatibilityscheme_fkey FOREIGN KEY (compatibilityscheme) REFERENCES scheme(code); |
|
130 |
ALTER TABLE api |
|
131 |
ADD COLUMN contentdescriptionclass VARCHAR(255) DEFAULT 'metadata'; |
|
132 |
ALTER TABLE api |
|
133 |
ADD COLUMN contentdescriptionscheme VARCHAR(255) DEFAULT 'dnet:content_description_typologies'; |
|
134 |
ALTER TABLE api |
|
135 |
DROP COLUMN editedprotocolclass; |
|
136 |
ALTER TABLE api |
|
137 |
DROP COLUMN editedprotocolscheme; |
|
138 |
ALTER TABLE api |
|
139 |
DROP COLUMN original; |
|
140 |
ALTER TABLE api |
|
141 |
DROP COLUMN edited; |
|
142 |
ALTER TABLE api |
|
143 |
DROP COLUMN useedited; |
|
144 |
ALTER TABLE api |
|
145 |
RENAME COLUMN originalprotocolclass TO protocolclass; |
|
146 |
ALTER TABLE api |
|
147 |
RENAME COLUMN originalprotocolscheme TO protocolscheme; |
|
148 |
ALTER TABLE api |
|
149 |
ADD COLUMN active BOOLEAN DEFAULT FALSE; |
|
150 |
ALTER TABLE api |
|
151 |
ADD COLUMN removable BOOLEAN DEFAULT FALSE; |
|
152 |
ALTER TABLE api |
|
153 |
ADD COLUMN typologyclass VARCHAR(255) DEFAULT 'UNKNOWN'; |
|
154 |
ALTER TABLE api |
|
155 |
ADD COLUMN typologyscheme VARCHAR(255) DEFAULT 'dnet:datasource_typologies'; |
|
156 |
ALTER TABLE api |
|
157 |
ADD CONSTRAINT api_typologyclass_fkey FOREIGN KEY (typologyclass) REFERENCES class (code); |
|
158 |
ALTER TABLE api |
|
159 |
ADD CONSTRAINT api_typologyscheme_fkey FOREIGN KEY (typologyscheme) REFERENCES scheme (code); |
|
160 |
ALTER TABLE api |
|
161 |
ADD COLUMN compatibilityclass VARCHAR(255) DEFAULT 'UNKNOWN'; |
|
162 |
ALTER TABLE api |
|
163 |
ADD COLUMN compatibilityscheme VARCHAR(255) DEFAULT 'dnet:compatibilityLevel'; |
|
164 |
ALTER TABLE api |
|
165 |
ADD CONSTRAINT api_compatibilityclass_fkey FOREIGN KEY (compatibilityclass) REFERENCES class (code); |
|
166 |
ALTER TABLE api |
|
167 |
ADD CONSTRAINT api_compatibilityscheme_fkey FOREIGN KEY (compatibilityscheme) REFERENCES scheme (code); |
|
93 | 168 |
|
94 |
ALTER TABLE api ADD CONSTRAINT api_contentdescriptionclass_fkey FOREIGN KEY (contentdescriptionclass) REFERENCES class(code); |
|
95 |
ALTER TABLE api ADD CONSTRAINT api_contentdescriptionscheme_fkey FOREIGN KEY (contentdescriptionscheme) REFERENCES scheme(code); |
|
169 |
ALTER TABLE api |
|
170 |
ADD CONSTRAINT api_contentdescriptionclass_fkey FOREIGN KEY (contentdescriptionclass) REFERENCES class (code); |
|
171 |
ALTER TABLE api |
|
172 |
ADD CONSTRAINT api_contentdescriptionscheme_fkey FOREIGN KEY (contentdescriptionscheme) REFERENCES scheme (code); |
|
96 | 173 |
|
97 |
UPDATE api SET typologyclass = d.datasourceclass FROM datasources d WHERE datasource = d.id; |
|
174 |
UPDATE api |
|
175 |
SET typologyclass = d.datasourceclass FROM datasources d |
|
176 |
WHERE datasource = d.id; |
|
98 | 177 |
--UPDATE api SET compatibilityclass = 'driver' where typology = 'driver'; |
99 | 178 |
--UPDATE api SET compatibilityclass = 'openaire2.0' FROM apicollections ac WHERE typology = 'openaire' AND id = ac.api AND ac.param = 'set' AND ac.original like '%ec_fundedresources%'; |
100 | 179 |
--UPDATE api SET compatibilityclass = 'openaire3.0' FROM apicollections ac WHERE typology = 'openaire' AND id = ac.api AND ac.param = 'set' AND ac.original like '%openaire%'; |
101 | 180 |
|
102 | 181 |
-- Jochen version |
103 |
UPDATE api SET compatibilityclass = ds.openairecompatibilityclass FROM datasources ds where ds.id=api.datasource; |
|
104 |
UPDATE api SET compatibilityclass = 'driver' WHERE compatibilityclass = 'driver-openaire2.0' AND typology = 'driver'; |
|
105 |
UPDATE api SET compatibilityclass = 'openaire2.0' WHERE compatibilityclass = 'driver-openaire2.0' AND typology = 'openaire'; |
|
106 |
UPDATE api SET compatibilityclass = 'UNKNOWN' WHERE compatibilityclass = 'openaire2.0-openaire3.0' |
|
182 |
UPDATE api |
|
183 |
SET compatibilityclass = ds.openairecompatibilityclass FROM datasources ds |
|
184 |
WHERE ds.id = api.datasource; |
|
185 |
UPDATE api |
|
186 |
SET compatibilityclass = 'driver' |
|
187 |
WHERE compatibilityclass = 'driver-openaire2.0' AND typology = 'driver'; |
|
188 |
UPDATE api |
|
189 |
SET compatibilityclass = 'openaire2.0' |
|
190 |
WHERE compatibilityclass = 'driver-openaire2.0' AND typology = 'openaire'; |
|
191 |
UPDATE api |
|
192 |
SET compatibilityclass = 'UNKNOWN' |
|
193 |
WHERE compatibilityclass = 'openaire2.0-openaire3.0' |
|
107 | 194 |
-- END Jochen |
108 | 195 |
|
109 |
UPDATE api SET (typologyclass, compatibilityclass) = ('entityregistry', 'native') WHERE id = 'api_________::opendoar::0'; |
|
110 |
UPDATE api SET (typologyclass, compatibilityclass) = ('entityregistry', 'native') WHERE id = 'api_________::re3data::0'; |
|
111 |
UPDATE api SET (typologyclass, compatibilityclass) = ('entityregistry', 'native') WHERE id = 'api_________::wellcometrust::0'; |
|
112 |
UPDATE api SET (typologyclass, compatibilityclass) = ('entityregistry', 'native') WHERE id = 'api_________::corda::0'; |
|
196 |
UPDATE api |
|
197 |
SET (typologyclass, compatibilityclass) = ('entityregistry', 'native') |
|
198 |
WHERE id = 'api_________::opendoar::0'; |
|
199 |
UPDATE api |
|
200 |
SET (typologyclass, compatibilityclass) = ('entityregistry', 'native') |
|
201 |
WHERE id = 'api_________::re3data::0'; |
|
202 |
UPDATE api |
|
203 |
SET (typologyclass, compatibilityclass) = ('entityregistry', 'native') |
|
204 |
WHERE id = 'api_________::wellcometrust::0'; |
|
205 |
UPDATE api |
|
206 |
SET (typologyclass, compatibilityclass) = ('entityregistry', 'native') |
|
207 |
WHERE id = 'api_________::corda::0'; |
|
113 | 208 |
|
114 |
ALTER TABLE api DROP COLUMN typology; |
|
115 |
ALTER TABLE datasources DROP COLUMN openairecompatibilityclass; |
|
116 |
ALTER TABLE datasources DROP COLUMN openairecompatibilityscheme; |
|
209 |
ALTER TABLE api |
|
210 |
DROP COLUMN typology; |
|
211 |
ALTER TABLE datasources |
|
212 |
DROP COLUMN openairecompatibilityclass; |
|
213 |
ALTER TABLE datasources |
|
214 |
DROP COLUMN openairecompatibilityscheme; |
|
117 | 215 |
|
118 |
DELETE FROM class_scheme WHERE scheme = 'dnet:compatibilityLevel' AND class = 'driver-openaire2.0'; |
|
119 |
DELETE FROM class_scheme WHERE scheme = 'dnet:compatibilityLevel' AND class = 'driver-openaire2.0-openaire3.0'; |
|
120 |
DELETE FROM class_scheme WHERE scheme = 'dnet:compatibilityLevel' AND class = 'driver-openaire3.0'; |
|
121 |
DELETE FROM class_scheme WHERE scheme = 'dnet:compatibilityLevel' AND class = 'openaire2.0-openaire3.0'; |
|
122 |
DELETE FROM class WHERE code = 'driver-openaire2.0'; |
|
123 |
DELETE FROM class WHERE code = 'driver-openaire2.0-openaire3.0'; |
|
124 |
DELETE FROM class WHERE code = 'driver-openaire3.0'; |
|
125 |
DELETE FROM class WHERE code = 'openaire2.0-openaire3.0'; |
|
216 |
DELETE FROM class_scheme |
|
217 |
WHERE scheme = 'dnet:compatibilityLevel' AND class = 'driver-openaire2.0'; |
|
218 |
DELETE FROM class_scheme |
|
219 |
WHERE scheme = 'dnet:compatibilityLevel' AND class = 'driver-openaire2.0-openaire3.0'; |
|
220 |
DELETE FROM class_scheme |
|
221 |
WHERE scheme = 'dnet:compatibilityLevel' AND class = 'driver-openaire3.0'; |
|
222 |
DELETE FROM class_scheme |
|
223 |
WHERE scheme = 'dnet:compatibilityLevel' AND class = 'openaire2.0-openaire3.0'; |
|
224 |
DELETE FROM class |
|
225 |
WHERE code = 'driver-openaire2.0'; |
|
226 |
DELETE FROM class |
|
227 |
WHERE code = 'driver-openaire2.0-openaire3.0'; |
|
228 |
DELETE FROM class |
|
229 |
WHERE code = 'driver-openaire3.0'; |
|
230 |
DELETE FROM class |
|
231 |
WHERE code = 'openaire2.0-openaire3.0'; |
|
126 | 232 |
|
127 |
DELETE FROM apicollections WHERE api = 'api_________::openaire____::webcrawl::0'; |
|
128 |
DELETE FROM api WHERE id = 'api_________::openaire____::webcrawl::0'; |
|
233 |
DELETE FROM apicollections |
|
234 |
WHERE api = 'api_________::openaire____::webcrawl::0'; |
|
235 |
DELETE FROM api |
|
236 |
WHERE id = 'api_________::openaire____::webcrawl::0'; |
|
129 | 237 |
|
130 | 238 |
INSERT INTO class (_dnet_resource_identifier_, code, name) VALUES ('fileCSV', 'fileCSV', 'fileCSV'); |
131 | 239 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) VALUES ('fileCSV@@dnet:protocols', 'fileCSV', 'dnet:protocols'); |
... | ... | |
138 | 246 |
INSERT INTO class (_dnet_resource_identifier_, code, name) VALUES ('filesystem', 'filesystem', 'filesystem'); |
139 | 247 |
INSERT INTO class_scheme (_dnet_resource_identifier_, class, scheme) VALUES ('filesystem@@dnet:protocols', 'filesystem', 'dnet:protocols'); |
140 | 248 |
|
141 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass) VALUES ('api_________::openaire____::webcrawl::csv', 'api_________::openaire____::webcrawl::csv', 'fileCSV', 'openaire____::webcrawl', 'websource', 'native'); |
|
142 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES ('api_________::openaire____::webcrawl::files', 'api_________::openaire____::webcrawl::files', 'files_from_mdstore', 'openaire____::webcrawl', 'websource', 'files', 'file::WoS'); |
|
143 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES ('api_________::opendoar____::18::files', 'api_________::opendoar____::18::files', 'files_from_metadata', 'opendoar____::18', 'pubsrepository::unknown', 'files', 'file::PDF'); |
|
144 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES ('api_________::opendoar____::908::files', 'api_________::opendoar____::908::files', 'files_from_metadata', 'opendoar____::908', 'pubsrepository::unknown', 'files', 'file::PDF'); |
|
145 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES ('api_________::opendoar____::2367::files', 'api_________::opendoar____::2367::files', 'files_from_metadata', 'opendoar____::2367', 'pubsrepository::unknown', 'files', 'file::PDF'); |
|
146 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES ('api_________::opendoar____::165::files', 'api_________::opendoar____::165::files', 'files_from_metadata', 'opendoar____::165', 'pubsrepository::unknown', 'files', 'file::PDF'); |
|
147 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES ('api_________::infrastruct_::openaire::jdbc', 'api_________::infrastruct_::openaire::jdbc', 'jdbc', 'infrastruct_::openaire', 'scholarcomminfra', 'openaire2.0', 'metadata'); |
|
249 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass) |
|
250 |
VALUES ('api_________::openaire____::webcrawl::csv', 'api_________::openaire____::webcrawl::csv', 'fileCSV', 'openaire____::webcrawl', 'websource', 'native'); |
|
251 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES |
|
252 |
('api_________::openaire____::webcrawl::files', 'api_________::openaire____::webcrawl::files', 'files_from_mdstore', 'openaire____::webcrawl', 'websource', |
|
253 |
'files', 'file::WoS'); |
|
254 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES |
|
255 |
('api_________::opendoar____::18::files', 'api_________::opendoar____::18::files', 'files_from_metadata', 'opendoar____::18', 'pubsrepository::unknown', |
|
256 |
'files', 'file::PDF'); |
|
257 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES |
|
258 |
('api_________::opendoar____::908::files', 'api_________::opendoar____::908::files', 'files_from_metadata', 'opendoar____::908', 'pubsrepository::unknown', |
|
259 |
'files', 'file::PDF'); |
|
260 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES |
|
261 |
('api_________::opendoar____::2367::files', 'api_________::opendoar____::2367::files', 'files_from_metadata', 'opendoar____::2367', 'pubsrepository::unknown', |
|
262 |
'files', 'file::PDF'); |
|
263 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES |
|
264 |
('api_________::opendoar____::165::files', 'api_________::opendoar____::165::files', 'files_from_metadata', 'opendoar____::165', 'pubsrepository::unknown', |
|
265 |
'files', 'file::PDF'); |
|
266 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass, contentdescriptionclass) VALUES |
|
267 |
('api_________::infrastruct_::openaire::jdbc', 'api_________::infrastruct_::openaire::jdbc', 'jdbc', 'infrastruct_::openaire', 'scholarcomminfra', |
|
268 |
'openaire2.0', 'metadata'); |
|
148 | 269 |
|
149 | 270 |
INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'jdbc:postgresql://localhost:5432', 'api_________::infrastruct_::openaire::jdbc'); |
150 | 271 |
INSERT INTO apicollections (param, original, api) VALUES ('dbName', 'dnet_openaireplus', 'api_________::infrastruct_::openaire::jdbc'); |
151 |
INSERT INTO apicollections (param, original, api) VALUES ('sql', 'SELECT regexp_replace(xml, ''&(?!amp;)'', ''&'', ''g'') as xml FROM claims WHERE type = ''dmf2actions'' and set = ''userclaim_dmf''', 'api_________::infrastruct_::openaire::jdbc'); |
|
272 |
INSERT INTO apicollections (param, original, api) VALUES |
|
273 |
('sql', 'SELECT regexp_replace(xml, ''&(?!amp;)'', ''&'', ''g'') as xml FROM claims WHERE type = ''dmf2actions'' and set = ''userclaim_dmf''', |
|
274 |
'api_________::infrastruct_::openaire::jdbc'); |
|
152 | 275 |
INSERT INTO apicollections (param, original, api) VALUES ('format', 'OAF', 'api_________::infrastruct_::openaire::jdbc'); |
153 | 276 |
|
154 | 277 |
INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'file:///var/lib/dnet/wos/metadata.tsv', 'api_________::openaire____::webcrawl::csv'); |
... | ... | |
172 | 295 |
INSERT INTO apicollections (param, original, api) VALUES ('mdstoreId', '', 'api_________::opendoar____::165::files'); |
173 | 296 |
INSERT INTO apicollections (param, original, api) VALUES ('xpath', '//dc:identifier', 'api_________::opendoar____::165::files'); |
174 | 297 |
|
175 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//repository/@rID', 'api_________::opendoar::0', false); |
|
176 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//*[local-name()=''repository'']/*[local-name()=''identifier'']', 'api_________::re3data::0', false); |
|
177 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//Position', 'api_________::wellcometrust::0', false); |
|
178 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//ProjectId', 'api_________::corda::0', false); |
|
298 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//repository/@rID', 'api_________::opendoar::0', FALSE); |
|
299 |
INSERT INTO apicollections (param, original, api, accessparam) |
|
300 |
VALUES ('metadata_identifier_path', '//*[local-name()=''repository'']/*[local-name()=''identifier'']', 'api_________::re3data::0', FALSE); |
|
301 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//Position', 'api_________::wellcometrust::0', FALSE); |
|
302 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//ProjectId', 'api_________::corda::0', FALSE); |
|
179 | 303 |
|
180 |
DELETE FROM apicollections WHERE param = 'splitOnElement' and api = 'api_________::corda::0'; |
|
304 |
DELETE FROM apicollections |
|
305 |
WHERE param = 'splitOnElement' AND api = 'api_________::corda::0'; |
|
181 | 306 |
INSERT INTO apicollections (param, original, api) VALUES ('filter', '*.xml', 'api_________::corda::0'); |
182 | 307 |
INSERT INTO apicollections (param, original, api) VALUES ('username', '***', 'api_________::corda::0'); |
183 | 308 |
INSERT INTO apicollections (param, original, api) VALUES ('password', '***', 'api_________::corda::0'); |
184 | 309 |
INSERT INTO apicollections (param, original, api) VALUES ('recursive', 'false', 'api_________::corda::0'); |
185 | 310 |
|
186 |
UPDATE apicollections SET original = 'ftp://fts.ec.europa.eu' WHERE api = 'api_________::corda::0' AND param = 'baseUrl'; |
|
187 |
UPDATE api SET protocolclass = 'ftp' WHERE id = 'api_________::corda::0'; |
|
188 |
UPDATE api SET protocolclass = 'filesystem' WHERE id='api_________::re3data::0'; |
|
189 |
UPDATE apicollections SET original = '/var/lib/dnet/re3data' WHERE api='api_________::re3data::0' AND param='baseUrl'; |
|
190 |
UPDATE api SET compatibilityclass = 'native' WHERE id = 'api_________::datacite::0' ; |
|
311 |
UPDATE apicollections |
|
312 |
SET original = 'ftp://fts.ec.europa.eu' |
|
313 |
WHERE api = 'api_________::corda::0' AND param = 'baseUrl'; |
|
314 |
UPDATE api |
|
315 |
SET protocolclass = 'ftp' |
|
316 |
WHERE id = 'api_________::corda::0'; |
|
317 |
UPDATE api |
|
318 |
SET protocolclass = 'filesystem' |
|
319 |
WHERE id = 'api_________::re3data::0'; |
|
320 |
UPDATE apicollections |
|
321 |
SET original = '/var/lib/dnet/re3data' |
|
322 |
WHERE api = 'api_________::re3data::0' AND param = 'baseUrl'; |
|
323 |
UPDATE api |
|
324 |
SET compatibilityclass = 'native' |
|
325 |
WHERE id = 'api_________::datacite::0'; |
|
191 | 326 |
|
192 | 327 |
-- metadata_identifier_path for Datacite and WoS |
193 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//*[local-name()=''header'']/*[local-name()=''identifier'']', 'api_________::datacite::0', false); |
|
194 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '//*[local-name()=''column'' and @isID=''true'']', 'api_________::openaire____::webcrawl::csv', false); |
|
328 |
INSERT INTO apicollections (param, original, api, accessparam) |
|
329 |
VALUES ('metadata_identifier_path', '//*[local-name()=''header'']/*[local-name()=''identifier'']', 'api_________::datacite::0', FALSE); |
|
330 |
INSERT INTO apicollections (param, original, api, accessparam) |
|
331 |
VALUES ('metadata_identifier_path', '//*[local-name()=''column'' and @isID=''true'']', 'api_________::openaire____::webcrawl::csv', FALSE); |
|
195 | 332 |
|
196 |
UPDATE apicollections SET _dnet_resource_identifier_ = api||'@@'||param; |
|
333 |
UPDATE apicollections |
|
334 |
SET _dnet_resource_identifier_ = api || '@@' || param; |
|
197 | 335 |
|
198 | 336 |
|
199 | 337 |
|
Also available in: Unified diff
integrated (hopefully) all required changes from dnet40