collection_criteria.csv

collection_criteria.rb

CSV.open('collection_criteria.csv', 'wb') do |csv|
  csv << ['community id', 'community title', 'collection id', 'collection link', 'collection title', 'item', 'thesis', 'edits in last month', 'edits in last quarter', 'edits in the last year', 'duplicate files', 'shared objects', 'file size', 'public', 'authenticated', 'embargo', 'private', 'draft']
  Collection.find_each do |collection|
    items_count = collection.member_objects.map {|object| object.class }.count(Item)
    thesis_count = collection.member_objects.map {|object| object.class }.count(Thesis)
    
    collection_filenames = []
    collection_updates_month = 0
    date_month = Time.now - 1.month
    collection_updates_quarter = 0
    date_quarter = Time.now - 3.month
    collection_updates_year = 0
    date_year = Time.now - 1.year
    collection.member_objects.each do |object| 
      object.files.each do |file| 
        collection_filenames << file.filename.to_s
      end
      collection_updates_month += object.versions.where(created_at: date_month..).count
      collection_updates_quarter += object.versions.where(created_at: date_quarter..).count
      collection_updates_year += object.versions.where(created_at: date_year..).count
    end
    duplicate_files_count = collection_filenames.count - collection_filenames.uniq.count

    shared_objects_count = collection.member_objects.count {|object| object.member_of_paths.count > 1 }

    total_file_size = collection.member_objects.sum do |object|
      object.files.joins(:blob).sum(:byte_size)
    end
    
    public_count = collection.member_objects.map {|object| object.visibility }.count(ControlledVocabulary.jupiter_core.visibility.public)
    authenticated_count = collection.member_objects.map {|object| object.visibility }.count(ControlledVocabulary.jupiter_core.visibility.authenticated)
    embargo_count = collection.member_objects.map {|object| object.visibility }.count(ControlledVocabulary.jupiter_core.visibility.embargo)
    private_count = collection.member_objects.map {|object| object.visibility }.count(ControlledVocabulary.jupiter_core.visibility.private)
    draft_count = collection.member_objects.map {|object| object.visibility }.count(ControlledVocabulary.jupiter_core.visibility.draft)
    
    csv << [collection.community_id, collection.community.title, collection.id, Rails.application.routes.url_helpers.community_collection_url(collection.community_id, collection.id), collection.title, items_count, thesis_count, collection_updates_month, collection_updates_quarter, collection_updates_year, duplicate_files_count, shared_objects_count, total_file_size, public_count, authenticated_count, embargo_count, private_count, draft_count]
  end
end
    

collection_filename_duplication.csv

collection_filename_duplication.rb

CSV.open('collection_filename_duplication.csv', 'wb') do |csv|
  csv << ['community id', 'collection id', 'collection link', 'collection title', 'duplicate filename', 'item links']
  Collection.all.each do |collection|
    collection_filenames = {}
    collection.member_objects.each do |object| 
      object.files.each do |file| 
        collection_filenames[file.filename.to_s] = [] unless collection_filenames[file.filename.to_s]
        collection_filenames[file.filename.to_s] << Rails.application.routes.url_helpers.item_url(object)
      end
    end
    collection_filenames.each do |filename, uuids|
      csv << [collection.community_id, collection.id, Rails.application.routes.url_helpers.community_collection_url(collection.community_id, collection.id), collection.title, filename, uuids] if uuids.size > 1
    end
  end
end

collection_num_files.csv

collection_num_files.rb

CSV.open('collection_num_files.csv', 'wb') do |csv|
  csv << ['community id', 'collection id', 'collection link', 'collection title', 'num files']
  Collection.all.each do |collection|
    collection_files_count = collection.member_objects.sum {|object| object.files.count}
    csv << [collection.community_id, collection.id, Rails.application.routes.url_helpers.community_collection_url(collection.community_id, collection.id), collection.title, collection_files_count]
  end
end

collection_shared.rb

CSV.open('collections_shared.csv', 'wb') do |csv|
  csv << ['collection link', 'collection title', 'item link', 'item title']
  Collection.find_each do |collection|
   collection.member_objects.each do |object| 
      if object.member_of_paths.count > 1
        csv << [Rails.application.routes.url_helpers.community_collection_url(collection.community_id, collection.id), collection.title, Rails.application.routes.url_helpers.item_url(object.id), object.title]
      end
    end
  end
end

collections_logos_and_descriptions.csv

communities_logos_and_descriptions.csv

historical_community_ids.csv

historical_community_ids.rb

CSV.open('historical_community_ids.csv', 'wb') do |csv|
  csv << ['community link', 'community title', 'jupiter id', 'hydra noid', 'fedora3 uuid']
  Community.find_each do |community|
    csv << [Rails.application.routes.url_helpers.community_url(community.id), community.title, community.id, community.hydra_noid, community.fedora3_uuid]
  end
end

logos_and_descriptions.rb

ActiveStorage::Current.url_options = { host: 'https://era.library.ualberta.ca'}

CSV.open('communities_logos_and_descriptions.csv', 'wb') do |csv|
  csv << ['community link', 'community title', 'logo link', 'community description']
  Community.find_each do |community|
    logo_url = if community.logo.attached? 
      community.logo.url(expires_in: 20.days)
    else 
      nil
    end
    csv << [Rails.application.routes.url_helpers.community_url(community.id), community.title, logo_url, community.description]
  end
end
CSV.open('collections_logos_and_descriptions.csv', 'wb') do |csv|
  csv << ['collection link', 'collection title', 'collection description']
  Collection.find_each do |collection|
   csv << [Rails.application.routes.url_helpers.community_collection_url(collection.community_id, collection.id), collection.title, collection.description]
  end
end