|
1
|
INSERT INTO hostedby_map (_dnet_resource_identifier_, oa_source_id, entry, datasourceid)
|
|
2
|
SELECT
|
|
3
|
p.id || '@@' || p.oa_source_id,
|
|
4
|
p.oa_source_id,
|
|
5
|
p.id,
|
|
6
|
d.id
|
|
7
|
FROM datasources d, pangaea_temp_journals p
|
|
8
|
WHERE
|
|
9
|
d.collectedfrom = 'driver______::1790119e-d281-4b7a-aedf-866d1d853a07' AND d.issn IS NOT NULL AND d.id LIKE 'doajarticles::%' AND p.issn = d.issn
|
|
10
|
AND
|
|
11
|
(p.oa_source_id, p.id) NOT IN
|
|
12
|
(SELECT
|
|
13
|
oa_source_id,
|
|
14
|
entry
|
|
15
|
FROM hostedby_map);
|
|
16
|
|
|
17
|
|
|
18
|
INSERT INTO hostedby_props (_dnet_resource_identifier_, key, value)
|
|
19
|
SELECT
|
|
20
|
p.id || '@@' || p.oa_source_id,
|
|
21
|
'issn',
|
|
22
|
p.issn
|
|
23
|
FROM datasources d, pangaea_temp_journals p
|
|
24
|
WHERE
|
|
25
|
d.collectedfrom = 'driver______::1790119e-d281-4b7a-aedf-866d1d853a07' AND d.issn IS NOT NULL AND d.id LIKE 'doajarticles::%' AND p.issn = d.issn
|
|
26
|
AND
|
|
27
|
(p.id || '@@' || p.oa_source_id, 'issn', p.issn) NOT IN
|
|
28
|
(SELECT
|
|
29
|
_dnet_resource_identifier_,
|
|
30
|
key,
|
|
31
|
value
|
|
32
|
FROM hostedby_props);
|