Revision 48139
Added by Alessia Bardi almost 7 years ago
| tubitak_journal.sql | ||
|---|---|---|
| 1 |
INSERT INTO hostedby_map(_dnet_resource_identifier_, oa_source_id, entry, datasourceid) |
|
| 2 |
SELECT d.issn||'@@'||d.collectedfrom, d.collectedfrom, d.issn, d.id |
|
| 3 |
FROM datasources d where |
|
| 4 |
d.collectedfrom ='openaire____::tubitak' and d.issn is not null and d.id like 'tubitak::%' |
|
| 5 |
AND |
|
| 6 |
(d.collectedfrom, d.issn) NOT IN |
|
| 7 |
(SELECT oa_source_id, entry from hostedby_map) |
|
| 1 |
INSERT INTO hostedby_map (_dnet_resource_identifier_, oa_source_id, entry, datasourceid) |
|
| 2 |
SELECT |
|
| 3 |
d.issn || '@@' || d.collectedfrom, |
|
| 4 |
d.collectedfrom, |
|
| 5 |
d.issn, |
|
| 6 |
d.id |
|
| 7 |
FROM datasources d |
|
| 8 |
WHERE |
|
| 9 |
d.collectedfrom = 'openaire____::tubitak' AND d.issn IS NOT NULL AND d.id LIKE 'tubitak::%' |
|
| 10 |
AND |
|
| 11 |
(d.collectedfrom, d.issn) NOT IN |
|
| 12 |
(SELECT |
|
| 13 |
oa_source_id, |
|
| 14 |
entry |
|
| 15 |
FROM hostedby_map) |
|
Also available in: Unified diff
integrated (hopefully) all required changes from dnet40