Project

General

Profile

« Previous | Next » 

Revision 7415

Added by ben leinfelder over 11 years ago

replace new lines in creator with spaces. set blank " " titles and creators to "unknown". use "Baltimore Ecosystem Study LTER" for publisher on all BES objects.

View differences:

src/doi_registration.sql
793 793 
and id.docid = x.docid
794 794 
and id.rev = x.rev;
795 795 

  		




  
  796
  
    
update doi_registration


  		




  
  797
  
    
set creator = replace(creator, E'\n', ' ');


  		




  
  798
  
    

  		




  
  799
  
    
-- some entries got in with blank spaces 


  		




  
  800
  
    
update doi_registration


  		




  
  801
  
    
set title = 'unknown'


  		




  
  802
  
    
where length(trim(title)) = 0;


  		




  
  803
  
    

  		




  
  804
  
    
update doi_registration


  		




  
  805
  
    
set creator = 'unknown'


  		




  
  806
  
    
where length(trim(creator)) = 0;


  		




  
  807
  
    

  		




  
  808
  
    
-- BES has very long publisher fields, so use this default for them all


  		




  
  809
  
    
update doi_registration


  		




  
  810
  
    
set publisher = 'Baltimore Ecosystem Study LTER'


  		




  
  811
  
    
where guid like '%knb-lter-bes%';


  		




  
  812
  
    

  		




  796
  813
  
    
-- copy to the external file


  		




  797
  814
  
    
COPY 


  		




  798
  815
  
    
(select ezid_account, 


  		












Also available in:  Unified diff