Revision 48139
Added by Alessia Bardi almost 7 years ago
| dataciteSets_findMatches.sql | ||
|---|---|---|
| 1 |
INSERT INTO hostedby_map(_dnet_resource_identifier_, oa_source_id, entry, datasourceid) |
|
| 2 |
SELECT |
|
| 3 |
s.setspec||'@@'||s.oa_source_id, s.oa_source_id, s.setspec, MIN(d.id) as id |
|
| 4 |
FROM |
|
| 5 |
datacite_temp_sets s join datacite_temp_datarepos d ON (s.setname_cleaned = d.name_cleaned) |
|
| 6 |
where (s.oa_source_id, s.setspec) NOT IN |
|
| 7 |
(SELECT oa_source_id, entry from hostedby_map) |
|
| 8 |
GROUP BY s.oa_source_id, s.setspec |
|
| 1 |
INSERT INTO hostedby_map (_dnet_resource_identifier_, oa_source_id, entry, datasourceid) |
|
| 2 |
SELECT |
|
| 3 |
s.setspec || '@@' || s.oa_source_id, |
|
| 4 |
s.oa_source_id, |
|
| 5 |
s.setspec, |
|
| 6 |
MIN(d.id) AS id |
|
| 7 |
FROM |
|
| 8 |
datacite_temp_sets s |
|
| 9 |
JOIN datacite_temp_datarepos d ON (s.setname_cleaned = d.name_cleaned) |
|
| 10 |
WHERE (s.oa_source_id, s.setspec) NOT IN |
|
| 11 |
(SELECT |
|
| 12 |
oa_source_id, |
|
| 13 |
entry |
|
| 14 |
FROM hostedby_map) |
|
| 15 |
GROUP BY s.oa_source_id, s.setspec |
|
Also available in: Unified diff
integrated (hopefully) all required changes from dnet40