Common code for the Relational Databases and Full Stack Fundamentals courses.
Database can serve multiple tournaments.
In order to register a player to a tournament, first create a player and a tournament.
Then register the player to the tournament. Use registered player id for matches.
https://www.virtualbox.org/wiki/Downloads
https://www.vagrantup.com/downloads.html
vagrant up
vagrant ssh
Navigate to tournament folder and launch PostgreSQL CLI
psql
Create database
create database tournaments;
Connect to tournaments
\c tournaments
\i tournament.sql
Exit psql CLI and run tests
python tournament_test.py