Project

General

Profile

Revision 7321

include the resourceMapId for the metadata objects, not just the data files.

View differences:

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