correlr
/
roam
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
roam/20240226173021-organizing_m...

21 KiB
Raw Permalink Blame History

Organizing Magic: The Gathering cards

Organizing my Magic: The Gathering cards.

Inventory

Cards are inventoried by scanning them with the Delver Lens Android app. The collection is then exported and loaded into my Tutor database.

Storage

Binders

Boxes

  • 4x 660-card boxes
  • 11x BCW 800-card boxes
  • Constructed product bins
  • Phil's deck box

  • Fat packs

    • 2x Strixhaven
    • 1x 2012 Core Set
    • 1x Innistrad

  • B0oster boxes

    • Core Set 2020
  • Unsanctioned

Sealed

  • Jumpstart
  • Jumpstart 2022

Reimagining boxes 

  select sets.set_code
       , sets.name
       , sets.set_type
       , min(scryfall.release_date) as release_date
       , count(copies.id) as cards
  from sets
  join scryfall using(set_code)
  join copies using (scryfall_id)
  where scryfall.rarity in ('common', 'uncommon')
  group by sets.set_code, sets.name, sets.set_type
  order by release_date
set_code name set_type release_date cards
ATQ Antiquities core 1994-03-04 1
3ED Revised Edition core 1994-04-01 38
LEG Legends core 1994-06-01 2
DRK The Dark core 1994-08-01 2
FEM Fallen Empires core 1994-11-01 16
4ED Fourth Edition core 1995-04-01 120
ICE Ice Age core 1995-06-03 122
CHR Chronicles core 1995-07-01 1
HML Homelands core 1995-10-01 42
ALL Alliances core 1996-06-10 11
MIR Mirage core 1996-10-08 207
VIS Visions core 1997-02-03 4
5ED Fifth Edition core 1997-03-24 69
WTH Weatherlight core 1997-06-09 77
TMP Tempest core 1997-10-14 31
STH Stronghold core 1998-03-02 33
EXO Exodus core 1998-06-15 21
USG Urza's Saga core 1998-10-12 146
ULG Urza's Legacy core 1999-02-15 31
6ED Classic Sixth Edition core 1999-04-21 113
UDS Urza's Destiny core 1999-06-07 37
S99 Starter 1999 core 1999-07-01 17
MMQ Mercadian Masques core 1999-10-04 168
NEM Nemesis core 2000-02-14 92
S00 Starter 2000 core 2000-04-01 4
PCY Prophecy core 2000-06-05 30
INV Invasion core 2000-10-02 135
PLS Planeshift core 2001-02-05 39
7ED Seventh Edition core 2001-04-11 184
APC Apocalypse core 2001-06-04 629
ODY Odyssey core 2001-10-01 219
TOR Torment core 2002-02-04 27
JUD Judgment core 2002-05-27 1
ONS Onslaught core 2002-10-07 32
LGN Legions core 2003-02-03 36
SCG Scourge core 2003-05-26 53
8ED Eighth Edition core 2003-07-28 1
MRD Mirrodin core 2003-10-02 98
DST Darksteel core 2004-02-06 45
5DN Fifth Dawn core 2004-06-04 57
CHK Champions of Kamigawa core 2004-10-01 6
9ED Ninth Edition core 2005-07-29 2
TSP Time Spiral core 2006-10-06 1
PLC Planar Chaos core 2007-02-02 1
10E Tenth Edition core 2007-07-13 3
MOR Morningtide core 2008-02-01 1
SHM Shadowmoor core 2008-05-02 2
ALA Shards of Alara core 2008-10-03 20
DD2 Duel Decks: Jace vs. Chandra core 2008-11-07 112
CON Conflux core 2009-02-06 13
M10 Magic 2010 core 2009-07-17 83
HOP Planechase core 2009-09-04 13
ZEN Zendikar core 2009-10-02 76
WWK Worldwake core 2010-02-05 145
ROE Rise of the Eldrazi core 2010-04-23 312
M11 Magic 2011 core 2010-07-16 290
SOM Scars of Mirrodin core 2010-10-01 300
MBS Mirrodin Besieged core 2011-02-04 345
NPH New Phyrexia core 2011-05-13 228
M12 Magic 2012 core 2011-07-15 230
DDH Duel Decks: Ajani vs. Nicol Bolas core 2011-09-02 1
ISD Innistrad core 2011-09-30 340
DKA Dark Ascension core 2012-02-03 49
AVR Avacyn Restored core 2012-05-04 46
M13 Magic 2013 core 2012-07-13 86
RTR Return to Ravnica core 2012-10-05 31
GTC Gatecrash core 2013-02-01 9
DGM Dragon's Maze core 2013-05-03 6
M14 Magic 2014 core 2013-07-19 2
THS Theros core 2013-09-27 29
BNG Born of the Gods core 2014-02-07 4
JOU Journey into Nyx core 2014-05-02 3
M15 Magic 2015 core 2014-07-18 43
KTK Khans of Tarkir core 2014-09-26 14
FRF Fate Reforged core 2015-01-23 2
DTK Dragons of Tarkir core 2015-03-27 2
PTKDF Tarkir Dragonfury core 2015-04-03 1
MM2 Modern Masters 2015 core 2015-05-22 2
C15 Commander 2015 core 2015-11-13 2
OGW Oath of the Gatewatch core 2016-01-22 1
SOI Shadows over Innistrad core 2016-04-08 55
EMN Eldritch Moon core 2016-07-22 6
KLD Kaladesh core 2016-09-30 75
C16 Commander 2016 core 2016-11-11 1
MM3 Modern Masters 2017 core 2017-03-17 1
AKH Amonkhet core 2017-04-28 22
CMA Commander Anthology core 2017-06-09 1
HOU Hour of Devastation core 2017-07-14 33
THOU Hour of Devastation Tokens core 2017-07-14 1
C17 Commander 2017 core 2017-08-25 1
XLN Ixalan core 2017-09-29 10
IMA Iconic Masters core 2017-11-17 1
UST Unstable core 2017-12-08 108
TRIX Rivals of Ixalan Tokens core 2018-01-19 1
RIX Rivals of Ixalan core 2018-01-19 27
TDOM Dominaria Tokens core 2018-04-27 1
DOM Dominaria core 2018-04-27 14
BBD Battlebond core 2018-06-08 1
M19 Core Set 2019 core 2018-07-13 22
C18 Commander 2018 core 2018-08-09 1
GRN Guilds of Ravnica core 2018-10-05 121
GNT Game Night core 2018-11-16 1
UMA Ultimate Masters core 2018-12-07 16
RNA Ravnica Allegiance core 2019-01-25 44
WAR War of the Spark core 2019-05-03 518
TWAR War of the Spark Tokens core 2019-05-03 36
MH1 Modern Horizons core 2019-06-14 3
M20 Core Set 2020 core 2019-07-12 563
C19 Commander 2019 core 2019-08-23 58
ELD Throne of Eldraine core 2019-10-04 140
MB1 Mystery Booster core 2019-11-07 2
PLST The List core 2019-11-07 354
SLD Secret Lair Drop core 2019-12-16 2
TTHB Theros Beyond Death Tokens core 2020-01-24 1
THB Theros Beyond Death core 2020-01-24 105
C20 Commander 2020 core 2020-04-17 1
IKO Ikoria: Lair of Behemoths core 2020-04-24 529
M21 Core Set 2021 core 2020-07-03 12
JMP Jumpstart core 2020-07-17 2
2XM Double Masters core 2020-08-07 2
PLIST The List core 2020-09-01 1
ZNC Zendikar Rising Commander core 2020-09-25 54
ZNR Zendikar Rising core 2020-09-25 110
CMR Commander Legends core 2020-11-20 439
TKHM Kaldheim Tokens core 2021-02-05 1
KHC Kaldheim Commander core 2021-02-05 39
KHM Kaldheim core 2021-02-05 165
TSR Time Spiral Remastered core 2021-03-19 2
STA Strixhaven Mystical Archive core 2021-04-23 20
TSTX Strixhaven: School of Mages Tokens core 2021-04-23 6
C21 Commander 2021 core 2021-04-23 26
STX Strixhaven: School of Mages core 2021-04-23 353
TMH2 Modern Horizons 2 Tokens core 2021-06-18 1
MH2 Modern Horizons 2 core 2021-06-18 271
AFC Forgotten Realms Commander core 2021-07-23 24
AFR Adventures in the Forgotten Realms core 2021-07-23 211
AAFR Adventures in the Forgotten Realms Art Series core 2021-07-23 3
MID Innistrad: Midnight Hunt core 2021-09-24 19
VOW Innistrad: Crimson Vow core 2021-11-19 102
NEO Kamigawa: Neon Dynasty core 2022-02-18 758
SNC Streets of New Capenna core 2022-04-29 185
CLB Commander Legends: Battle for Baldur's Gate core 2022-06-10 85
2X2 Double Masters 2022 core 2022-07-08 388
DMC Dominaria United Commander core 2022-09-09 14
DMU Dominaria United core 2022-09-09 167
UNF Unfinity core 2022-10-07 36
BRO The Brothers' War core 2022-11-18 622
TBOT Transformers Tokens core 2022-11-18 1
BRR The Brothers' War Retro Artifacts core 2022-11-18 60
BRC The Brothers' War Commander core 2022-11-18 100
TDMR Dominaria Remastered Tokens core 2023-01-13 1
DMR Dominaria Remastered core 2023-01-13 704
ONE Phyrexia: All Will Be One core 2023-02-03 372
MOC March of the Machine Commander core 2023-04-21 41
MOM March of the Machine core 2023-04-21 117
MUL Multiverse Legends core 2023-04-21 25
MAT March of the Machine: The Aftermath core 2023-05-12 1
LTR The Lord of the Rings: Tales of Middle-earth core 2023-06-23 427
LTC Tales of Middle-earth Commander core 2023-06-23 111
CMM Commander Masters core 2023-08-04 10
WOE Wilds of Eldraine core 2023-09-08 280
WOT Wilds of Eldraine: Enchanting Tales core 2023-09-08 26
SPG Special Guests core 2023-11-17 1
LCC Lost Caverns of Ixalan Commander core 2023-11-17 1
REX Jurassic World Collection core 2023-11-17 1
LCI Lost Caverns of Ixalan core 2023-11-17 421
RVR Ravnica Remastered core 2024-01-12 129
MKM Murders at Karlov Manor core 2024-02-09 63 
  import itertools

  boxes = itertools.chain([660] * 4, itertools.repeat(800))

  filled = []
  space = next(boxes)
  box = []
  used = 0
  for set_code, name, set_type, release_date, cards in sets:
      if int(cards) > space:
          filled.append((used, box))
          used = 0
          box = []
          space = next(boxes)
      box.append(set_code)
      used += int(cards)
      space -= int(cards)
  return filled
635 (ATQ 3ED LEG DRK FEM 4ED ICE CHR HML ALL MIR VIS 5ED)
506 (WTH TMP STH EXO USG ULG 6ED UDS S99)
652 (MMQ NEM S00 PCY INV PLS 7ED)
629 (APC)
730 (ODY TOR JUD ONS LGN SCG 8ED MRD DST 5DN CHK 9ED TSP PLC 10E MOR SHM ALA DD2 CON)
629 (M10 HOP ZEN WWK ROE)
590 (M11 SOM)
573 (MBS NPH)
800 (M12 DDH ISD DKA AVR M13 RTR GTC DGM M14)
667 (THS BNG JOU M15 KTK FRF DTK PTKDF MM2 C15 OGW SOI EMN KLD C16 MM3 AKH CMA HOU THOU C17 XLN IMA UST TRIX RIX TDOM DOM BBD M19 C18 GRN GNT UMA RNA)
557 (WAR TWAR MH1)
763 (M20 C19 ELD MB1)
463 (PLST SLD TTHB THB C20)
710 (IKO M21 JMP 2XM PLIST ZNC ZNR)
698 (CMR TKHM KHC KHM TSR STA TSTX C21)
649 (STX TMH2 MH2 AFC)
335 (AFR AAFR MID VOW)
758 (NEO)
672 (SNC CLB 2X2 DMC)
203 (DMU UNF)
784 (BRO TBOT BRR BRC TDMR)
704 (DMR)
556 (ONE MOC MOM MUL MAT)
548 (LTR LTC CMM)
730 (WOE WOT SPG LCC REX LCI)