This command line database analysis app interacts with a database of fighters associated with the Ultimate Fighting Championship. With our current functionality, a user is able to accept a list of commands that will display the information that they queried. The underlying ruby programs utilize Active Record to Create, Read, Update, and Delete our database of fighters depending on the commands that the user inputs. Our app can tell the user the camp or weight class that a given fighter belongs to, it also is able to take in two fighters and determine if they are able to fight one another and displays a champion, the app can also tell the user what camps are best for a given weight class, and the user is able to create and delete fighters from the database.
- Fork and clone the project file from GitHub:
- Run
rake db:migratein your terminal to build the "create tables" methods using Active Record - Once the classes are migrated, run
rake db:seedin your terminal to create the tables in our database that we will be interacting with - With the database populated, run
ruby bin/run.rband follow the instructions to Create, Read, Update, or Destroy instances associated with the database.
- This is the original Google Sheets document that we used to extrapolate our data > https://docs.google.com/spreadsheets/d/1z3QX0uWXv-XHX2Nfuj6zZHrfEeXI3A9CKWkrGaBzB8s/edit#gid=0
- We followed this video tutorial to change our Google Sheets to usable JSON > https://www.youtube.com/watch?v=uJDLT8nh2ps