Skip to content

Instantly share code, notes, and snippets.

@pgwillia

pgwillia/collection_sizes.csv

Last active December 5, 2024 19:45
Show Gist options
  • Save pgwillia/c0bd2f5bac8119edd5345028c583948f to your computer and use it in GitHub Desktop.
Save pgwillia/c0bd2f5bac8119edd5345028c583948f to your computer and use it in GitHub Desktop.
Download ZIP
ERA collections total file sizes
Raw
collection_sizes.csv
collection link collection title collection size collection size for humans
http://era.lvh.me:3000/communities/3fab823b-df63-4964-92cd-4d96fb5df3bd/collections/1580d0cc-7c29-44f7-b8ea-983e7588a054 The annals of 'Cat International' 132474 129 KB
http://era.lvh.me:3000/communities/3fab823b-df63-4964-92cd-4d96fb5df3bd/collections/336277df-b05f-49c0-856c-b9224642126a Theses about cats 132474 129 KB
http://era.lvh.me:3000/communities/541e0055-813d-4178-ac36-a94b79cd4127/collections/388bb612-5d5c-4cb9-9f7d-15ccb3f32046 The annals of 'Dog International' 132474 129 KB
http://era.lvh.me:3000/communities/541e0055-813d-4178-ac36-a94b79cd4127/collections/808aecb8-c30a-4cdd-b8ad-fea08e45596d Theses about dogs 132474 129 KB
http://era.lvh.me:3000/communities/11d1643e-0ea8-4b2f-adaa-3a2d2018f803/collections/e9ad79cb-bc09-4fbb-8847-d16711ade4e1 The annals of 'Unicorn International' 1323434 1.26 MB
http://era.lvh.me:3000/communities/11d1643e-0ea8-4b2f-adaa-3a2d2018f803/collections/7ffbc573-ff92-4d00-95ee-a60eaf584ca8 Theses about unicorns 132474 129 KB
http://era.lvh.me:3000/communities/1edd70f9-d63c-4de9-a6f1-56957b2f4542/collections/142c7ff5-0f8a-4032-b049-4f2247eaa50a The annals of 'Hamburger International' 132474 129 KB
http://era.lvh.me:3000/communities/1edd70f9-d63c-4de9-a6f1-56957b2f4542/collections/dc79d733-7b1e-4420-9582-87833d41d2df Theses about hamburgers 132474 129 KB
http://era.lvh.me:3000/communities/9c10fac7-e992-4916-9073-3047b1f58e4b/collections/8a7972d0-8ab5-4d57-9a72-7b4d177cd219 The annals of 'Librarian International' 132474 129 KB
http://era.lvh.me:3000/communities/9c10fac7-e992-4916-9073-3047b1f58e4b/collections/01e0a92e-450b-48b6-9e34-36fd76e16089 Theses about librarians 132474 129 KB
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/b3d0f437-78c3-4a67-830a-4685bb408189 Articles about the relationship between Libraries and non-Libraries 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/6f934a31-5489-4df1-9d19-b95cdfca0d8c Articles about the relationship between DONAIRs and non-DONAIRs 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/9f6f215f-c614-40ce-b2f9-d659ab5e97fa Articles about the relationship between magpies and non-magpies 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/a999a8e5-e5fe-4ef5-a66a-f823d959f33b Articles about the relationship between toques and non-toques 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/d36b2747-d231-4a63-b671-54c8b0418a84 Articles about the relationship between sombreros and non-sombreros 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/28de319f-10c3-401c-8456-17a888dddf77 Articles about the relationship between yetis and non-yetis 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/3733a796-2e5d-4f6a-98c5-560347ad7e73 Articles about the relationship between mimosas and non-mimosas 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/04a2a178-0ad9-4e01-ad31-5d0c9550d04b Articles about the relationship between ukuleles and non-ukuleles 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/5363d1f0-1ad3-4d5c-aa4d-c80773f022f8 Articles about the relationship between tourtières and non-tourtières 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/936d9900-c1c5-405c-aae8-49209f10ef30 Articles about the relationship between falafels and non-falafels 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/e9412a95-f89c-4d2b-86e9-eeb0d9204da1 Articles about the relationship between calculators and non-calculators 0 0 Bytes
http://era.lvh.me:3000/communities/aa918481-d882-49e4-ab03-5245a0805154/collections/0f9d1f51-0240-47f1-9521-1c67eaa45cb0 Articles about the relationship between papusas and non-papusas 0 0 Bytes
Raw
collection_sizes.rb
include ActionView::Helpers::NumberHelper
CSV.open('collection_sizes.csv', 'wb') do |csv|
csv << ['collection link', 'collection title', 'collection size', 'collection size for humans']
Collection.all.each do |collection|
total_size = collection.member_objects.sum do |object|
object.files.joins(:blob).sum(:byte_size)
end
csv << [Rails.application.routes.url_helpers.community_collection_url(collection.community_id, collection.id), collection.title, total_size, number_to_human_size(total_size)]
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment