Revision 7335
Added by ben leinfelder over 12 years ago
src/doi_registration.sql | ||
---|---|---|
606 | 606 |
creator as dc_creator, |
607 | 607 |
publisher as dc_publisher, |
608 | 608 |
pub_date as datacite_publicationYear, |
609 |
resourceType, |
|
610 |
objectFormat, |
|
611 |
obsoletedBy as isPreviousVersionOf, |
|
612 |
obsoletes as isNewVersionOf, |
|
613 |
resourceMapId, |
|
614 |
resourceMapLocation, |
|
615 |
access |
|
609 |
split_part(resourceType, '/', 1) as datacite_resourceTypeGeneral, |
|
610 |
split_part(resourceType, '/', 2) as datacite_resourceType, |
|
611 |
objectFormat as datacite_format, |
|
612 |
obsoletedBy as datacite_relatedIdentifier_isPreviousVersionOf, |
|
613 |
obsoletes as datacite_relatedIdentifier_isNewVersionOf, |
|
614 |
resourceMapId as datacite_relatedIdentifier_isPartOf, |
|
615 |
resourceMapLocation as d1_resourceMapLocation, |
|
616 |
access as d1_read_access |
|
616 | 617 |
from doi_registration |
617 | 618 |
order by dc_identifier) |
618 | 619 |
TO '/tmp/doi_registration.csv' |
Also available in: Unified diff
align the final column headers with the datacite schema, as applicable.
https://redmine.dataone.org/issues/2815