Reports from ERA/jupiter a) of all destroyed objects tracked by papertrail b) of all items/theses with handles c) items and theses that are drafts or private d) visibility after embargo values d) items and theses with no DOI

destroy_papertrail_report.rb

CSV.open('destroyed.csv', 'wb') do |csv|
  csv << ['item type', 'item id', 'item destroyed at']
  PaperTrail::Version.where(event: 'destroy').each do |item|
    csv << [item.item_type, item.item_id, item.created_at]
  end
end

draft_items.csv

draft_thesis.csv

drafts_report.rb

CSV.open('draft_items.csv', 'wb') do |csv|
  keys = DraftItem.first.attributes.keys
  csv << keys.map {|key|  Item.rdf_annotation_for_attr(key).present? ? RDF::URI(Item.rdf_annotation_for_attr(key).first.predicate).pname.to_s : key }
  DraftItem.find_each do |item|
    values = item.values_at(keys)
    user_id = values[16] 
    values[16] = User.find(user_id).email
    csv << values
  end
end
CSV.open('draft_thesis.csv', 'wb') do |csv|
  keys = DraftThesis.first.attributes.keys
  csv << keys.map {|key|  Item.rdf_annotation_for_attr(key).present? ? RDF::URI(Item.rdf_annotation_for_attr(key).first.predicate).pname.to_s : key }
  DraftThesis.find_each do |item|
    values = item.values_at(keys)
    user_id = values[4] 
    values[4] = User.find(user_id).email
    csv << values
  end
end

duplicated_doi.csv

duplicated_doi.rb

CSV.open('duplicated_doi.csv', 'wb') do |csv|
  csv << ['item url', 'item id', 'title', 'doi', 'created date', 'date_ingested', '[views,downloads]']
  [Item,Thesis].each do |klass|
    dois = klass.group(:doi).count
    dois.each do |key,value|
      next unless value > 1
      klass.where(doi: key).each {|item| csv << [Rails.application.routes.url_helpers.item_url(item.id), item.id, item.title, item.doi, item.created_at, item.date_ingested, Statistics.for(item_id: item.id)] }
    end
  end
end

embargo_end_date.csv

embargo_end_date.rb

CSV.open('embargo_end_date.csv', 'wb') do |csv|
  csv << ['klass', 'item id', 'embargo end date', 'visibility after embargo']
  Thesis.where.not(embargo_end_date: nil).each{|item| csv << [item.class.name, item.id, item.embargo_end_date.strftime('%Y-%m-%d'), item.visibility_after_embargo] }
  Item.where.not(embargo_end_date: nil).each{|item| csv << [item.class.name, item.id, item.embargo_end_date.strftime('%Y-%m-%d'), item.visibility_after_embargo] }
end

embargo_visibility.csv

embargo_visibility.rb

CSV.open('embargo_visibility.csv', 'wb') do |csv|
  csv << ['item id', 'visibility after embargo']
  Thesis.find_each{|item| csv << [item.id, item.visibility_after_embargo] }
  Item.find_each{|item| csv << [item.id, item.visibility_after_embargo] }
end

handles.rb

CSV.open('thesis_handle.csv', 'wb') do |csv|
  csv << ['item id', 'item handle']
  Thesis.where.not(fedora3_handle: nil).each{|item| csv << [item.id, item.fedora3_handle] }
end
CSV.open('handle.csv', 'wb') do |csv|
  csv << ['item id', 'item handle']
  Item.where.not(fedora3_handle: nil).each{|item| csv << [item.id, item.fedora3_handle] }
end

without_doi.rb

CSV.open('without_doi.csv', 'wb') do |csv|
  csv << ['item url', 'item id', 'title']
  [Item,Thesis].each {|klass| klass.where(doi: nil).each{|item| csv << [Rails.application.routes.url_helpers.item_url(item.id), item.id, item.title] }}
end

there are six items which should have been theses

thesis = Thesis.find('')
thesis.doi =
thesis.save

DOIServer.new(thesis).update