search

SamSmithNZ-dotcom / SamSmithNZ.com

Source code for my personal website, samsmithnz.com
0 stars 5 forks source link

Fix playoffs - not currently setup right. #27

Closed samsmithnz closed 3 years ago

samsmithnz commented 3 years ago

See: https://en.wikipedia.org/wiki/2022_FIFA_World_Cup#Knockout_stage

samsmithnz commented 3 years ago

Need to update the format, so that instead of based on static games, it's based on game number winners and losers. e.g.

samsmithnz commented 3 years ago

Properties

samsmithnz commented 3 years ago

Migration: Look at existing playoffs, starting at FF and 3P, and back up to build the tree.

  1. Get a list of all tournaments that aren't processed (optional)
  2. Get a list of all playoff games for a tournament. Return 0 rows if the tournament is processed
  3. Start at the final/3rd place game and work backwards, building the network in memory
  4. Write the network back to the database (the playoff format table)