zHacking the Cheesy Arena Schedule - Team254/cheesy-arena GitHub Wiki
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.
- Loaded all of the teams via UI and sync'd with The Blue Alliance. (very cool!)
- Loaded 10 "FIRST Off-Season Demo Teams" (aka "dummy" or "placeholder teams") using the team numbers 9990-9999.
- 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.
- Created the schedule I really wanted in a Google sheet.
- Downloaded & installed DB Browser for SQLite --- This tool is awesome.
- Open the database in the tool. I am intentionally leaving out detail on this step.
- 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. - Updated the
matches
table to have the number of rows I wanted. - 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"