/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 8028

type the doctype="metadata" objects as "FGDC-STD-001-1998" formatId for rendering XSLT and for DataONE SystemMetadata.

     );
     /*
      * Update the "metadata" doctypes to use "FGDC-STD-001-1998" formatId
      * now that we have a correct format for them
+     *
      */
     UPDATE systemMetadata sm
     SET object_format = 'FGDC-STD-001-1998'
     FROM xml_documents xml,
     identifier id
     WHERE id.docid = xml.docid
     AND id.rev = xml.rev
     AND id.guid = sm.guid
     AND xml.doctype = 'metadata';
     /*
      * and in the xml_revisions
      */
     UPDATE systemMetadata sm
     SET object_format = 'FGDC-STD-001-1998'
     FROM xml_revisions xml,
     identifier id
     WHERE id.docid = xml.docid
     AND id.rev = xml.rev
     AND id.guid = sm.guid
     AND xml.doctype = 'metadata';
     /*
      * Increase harvest_log column length to avoid errors
      */
     ALTER TABLE harvest_log ALTER COLUMN harvest_operation_code TYPE VARCHAR(1000);
     /*
      * update the database version
      */
     UPDATE db_version SET status=0;

       harvest_date           DATE,           -- date of the current harvest
       status                 NUMBER,         -- non-zero indicates an error status
       message                VARCHAR2(1000), -- text message for this log entry
       harvest_operation_code VARCHAR2(30),   -- the type of harvest operation
       harvest_operation_code VARCHAR2(1000),   -- the type of harvest operation
       site_schedule_id       NUMBER,         -- site schedule id, or 0 if no site
       CONSTRAINT harvest_log_pk PRIMARY KEY (harvest_log_id)
     );

     );
     /*
      * Update the "metadata" doctypes to use "FGDC-STD-001-1998" formatId
      * now that we have a correct format for them
+     *
      */
     UPDATE systemMetadata sm
     SET object_format = 'FGDC-STD-001-1998'
     FROM xml_documents xml,
     identifier id
     WHERE id.docid = xml.docid
     AND id.rev = xml.rev
     AND id.guid = sm.guid
     AND xml.doctype = 'metadata';
     /*
      * and in the xml_revisions
      */
     UPDATE systemMetadata sm
     SET object_format = 'FGDC-STD-001-1998'
     FROM xml_revisions xml,
     identifier id
     WHERE id.docid = xml.docid
     AND id.rev = xml.rev
     AND id.guid = sm.guid
     AND xml.doctype = 'metadata';
     /*
      * Increase harvest_log column length to avoid errors
      */
     ALTER TABLE harvest_log MODIFY (harvest_operation_code VARCHAR2(1000));
     /*
      * update the database version
      */
     UPDATE db_version SET status=0;

       harvest_date           DATE,          -- date of the current harvest
       status                 INT8,          -- non-zero indicates an error status
       message                VARCHAR(1000), -- text message for this log entry
       harvest_operation_code VARCHAR(30),   -- the type of harvest operation
       harvest_operation_code VARCHAR(1000),   -- the type of harvest operation
       site_schedule_id       INT8,          -- site schedule id, or 0 if no site
       CONSTRAINT harvest_log_pk PRIMARY KEY (harvest_log_id)
     );

     		if (doctype.trim().equals("BIN")) {
     			// we don't know much about this file (yet)
     			fmtid = ObjectFormatCache.getInstance().getFormat("application/octet-stream").getFormatId();
     		} else if (doctype.trim().equals("metadata")) {
     			// special ESRI FGDC format
     			fmtid = ObjectFormatCache.getInstance().getFormat("FGDC-STD-001-1998").getFormatId();
     		} else {
     			try {
     				// do we know the given format?

Also available in: Unified diff