Replacing Google Sheets with Commander Spellbook Backend JSON Api

[ldeluigi]

• Replace Google Sheets with the new commander spellbook backend API
  • Fetch combos (now called variants) from the bulk json endpoint, reformatting the data to fit the old combo data model
  • Re-route the bulk endpoint to a user friendly url
  • Remap old combo ids (integers) to new ones (strings) using the generated json map
  • Exploiting properly the new fields and information that the backend now provides within the bulk json api
    • Exploit the id field to identify combos in the URL
      • Keeping the backwards compatibility with pre-existing urls
    • Exploit card's oracle_id field to retrieve the best or most recent version/print of a card (more info at Scryfall docs and at Scryfall Collection Api)
    • Exploit card's zone_location and card_state fields to display information for each card
      • [MAYBE] with a better UI/UX than simple generated text on screen
    • Exploit variant's produces list of features to generate the result text information
    • Exploit the identity field of variants instead of computing it
    • Exploit the mana_needed field of variants
    • Exploit the other_prerequisites field of variants
    • Exploit the description field of variants
    • Exploit the legalities field of variants in order to check for variant's legality in supported formats
    • Exploit the spoiler field too
• Reset the backend database (which currently is dummy-seeded) and import combos from google sheets to the backend
  • while editor's work is paused
  • deploy the frontend in production after user acceptance tests succeed
• Use the random sort + variant query endpoint to find random combos and filter only combos legal in commander (as per Change Random Button to Not Show Banned Combos #443)
• Update the advanced syntax page and the syntax guide as well

[ldeluigi]

Mockup for templates:

[ldeluigi]

Mockup for variant grouping:

Mockup for EXAMPLES variant display: