This is the prototype strategy & scouting database of FRC team Arctos 6135, using a MySQL database and nodejs with the Blue Alliance API for getting teams. It is still in development, but is has most of the key features of the old Arctos excel db.
Installation
Install node Install mysql
In MySql workbench, run schema.sql (to create db and tables)
npm install
Then, in the client folder do another npm install
You need a The Blue Alliance API Key. If you want to use your own, edit that line in tba.js
To prepare the database, run these from the command line. They are configured for the Ontario District, you will have to make some changes to use them elsewhere.
node load_teams.js
node load_events.js
node load_matches.js EVENT (e.g. 2019oncmp1)
node parse_output.js
node load_alliance_outcomes.js EVENT (e.g. 2019oncmp1)
To run the webapp, run npm start. It will open in your default browser at ports 3000(client) and 3001(server).