Skip to content

zHacking the Cheesy Arena Schedule

hollisms edited this page May 1, 2021 · 1 revision

This is a bad idea.

Turn back now.

Still here?

OK, obviously this is a hack and I would love to build the UI to do this, but I don't/didn't have time. The challenge that I have is that we are doing a small scrimmage with LESS teams that Cheesy-arena supports AND we want to do qualifications using 2v2 instead of 3v3.

So... I will outline the steps below, but if you don't know what you are doing you can mess everything up. Take backups of the database regularly in case you make a mistake. Assume you will make a mistake. If this page gets deleted, my feelings won't be hurt.

  1. Loaded all of the teams via UI and sync'd with The Blue Alliance. (very cool!)
  2. Loaded 10 "FIRST Off-Season Demo Teams" (aka "dummy" or "placeholder teams") using the team numbers 9990-9999.
  3. Created scheduling blocks for practice and qualifications. Trying to just have the scheduler build as close to the number of matches in each that I wanted. I didn't fret over how the 999x teams were sorted in.
  4. Created the schedule I really wanted in a Google sheet.
  5. Downloaded & installed DB Browser for SQLite --- This tool is awesome.
  6. Open the database in the tool. I am intentionally leaving out detail on this step.
  7. Using the tool I updated the appropriate rows on the schedule_blocks table. I wanted 25 matches, but the closest I could get the system to generate was 26.
  8. Updated the matches table to have the number of rows I wanted.
  9. Updated the matches table by copying and pasting columns of team numbers from the Google sheet I created.

Note: I put the leading z in the page title to get it to sort "below the fold"