Revision 7321
Added by ben leinfelder almost 12 years ago
| doi_registration.sql | ||
|---|---|---|
| 403 | 403 |
and child.nodetype = 'TEXT' |
| 404 | 404 |
and id.guid in (select guid from doi_registration); |
| 405 | 405 |
|
| 406 |
-- NOTE: some of thee maps might not actually exist
|
|
| 406 |
-- Set the resource map for the data files (NOTE: some of thee maps might not actually exist on the system depending on how successful the ORE generation was)
|
|
| 407 | 407 |
update doi_registration doi |
| 408 | 408 |
set resourceMapId = 'resourceMap_'||eco.docid||'.'||eco.rev |
| 409 | 409 |
from identifier id, ecogrid_docids eco |
| 410 | 410 |
where doi.guid = id.guid |
| 411 | 411 |
and id.docid||'.'||id.rev = eco.data_docid; |
| 412 | 412 |
|
| 413 |
-- set the resource map id for the metadata file that did most of the packaging work! |
|
| 414 |
update doi_registration doi |
|
| 415 |
set resourceMapId = 'resourceMap_'||eco.docid||'.'||eco.rev |
|
| 416 |
from ecogrid_docids eco |
|
| 417 |
where doi.guid = eco.guid; |
|
| 418 |
|
|
| 413 | 419 |
select count(*) |
| 414 | 420 |
from doi_registration |
| 415 | 421 |
where resourceMapId is null; |
Also available in: Unified diff
include the resourceMapId for the metadata objects, not just the data files.