Tournament planner is a tool for planning and keeping scores of game or sports tournaments. It uses a Swiss pairing system where players compete against others on their same level, based on results in the tournament.

The program uses PostgreSQL, Virtual Box, Vagrant, Psychopg2 and Python 2.7 to create a back-end solution for managing a tournament after the Swiss model. In a Swiss model tournament players do not get knocked out, but in each round they play agains players who have the same amount of wins as they have.

To use the module, you first need to install the following:

• Python2.7
• Virtual Box
• Vagrant
• GIT (Recommended)

1. Install all software listed above.
2. In GIT, cd to your project folder and type
   git clone https://github.com/udacity/fullstack-nanodegree-vm
3. Inside the vagrant folder, clone this repository
   git clone https://github.com/stonescar/tournament-planner
4. Type vagrant up to boot your virtual machine (This might take a while...)
5. When the VM is booted, log in with vagrant ssh
6. cd to the tournament planner folder with cd /vagrant/tournament-planner
7. To build the database, type psql, then \i tournament.sql
8. Press CTRL+D to exit psql
9. You can now run the example program with python play.py or build your project and import tournament.py

A short description of the functions in tournament.py. Se the docstrings for more detailed information.

• connect(): Sets up and returns a database connection. Edit this to fit your database
• deleteTournaments(): Deletes ALL tournaments
• deleteTournament(id): Deletes a tournament
• deleteMatches(tournament): Deletes all matches, or just all matches for a given tournament
• deletePlayers(): Deletes ALL players
• newTournament(name): Creates a new tournament
• countPlayers(tournament): Counts ALL players in the database, or just those assigned to a given tournament
• registerPlayer(name): Adds a new player to the database
• assignPlayers(tournament, *players): Assigns a list of players to a tournament
• quicktournament(t_name, *players): Creates a new tournament and adds assigns players to it
• playerStandings(tournament): Returns a list of all players in a tournament, sorted by wins
• reportMatch(tournament, winner, loser): Report the outcome of a match
• swissPairings(tournament): Returns a list of pairs of players based on the Swiss model
• randomPairings(tournament): Returns a lis of random pairs of players

Listed below are the tables the data is stored in and the views that have been created to retreieve the data easily. For each table or view is an example table showing how the tables and views could look like. Values in tables in parentheses shows the value that the foreign key points to.

Holds the unique id of the player as a primary key, and the player's name as a text value.

Holds the unique id of the tournament as a primary key, and the tournament name as a text value:

Assigns players to tournaments. player references to the id field in the players table, and tournament references to the id in the tournaments table. This way a user can be in many different tournaments.

Stores results of matches in all tournaments. Hold the unique id of the match as a primary key, tournament references to the id field in the tournament table and tells which tournement the match was part of, while winner and loser references to the id field in the players table representing the two players in the match, where the winner of the match is set as winner.

Temporary view that lists all matches for all players. So all the matches a player has played will be listed in this view and connected to his id and name. tournament references to the id field of the tournaments table for later sorting and selecting. id and name references to the player's id and name in the players table. winner and loser holds the ids of the player in the match, with winner showing who won. This view is only used for further selecting, sorting and grouping, i.e. in the standings view.

Shows the current standings of all tournaments. Lists all players, sorted by number of wins. Includes tournament (id of tournament), id (player's id), name (player's name), matches (the total number of matches the player has played) and wins (the total number of matches the player has won. Use ...WHERE tournament = [tournament-id] to only show standings for one tournament.

This project is licensed under the MIT License.