Skip to content

Built a PostgreSQL relational database scheme to store the results of a game tournament. Also provided a number of queries to efficiently report the results of the tournament and determine the winner.

Notifications You must be signed in to change notification settings

m-zheng/tournament-results

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 

Repository files navigation

About

This project is a part of Full Stack Developer Nanodegree from Udacity.

It has a Python module that uses the PostgreSQL database to keep track of players and matches in a swiss-style game tournament. It also creates a database schema to store the game matches between players. A Python module is used to rank the players and pair them up in matches in a tournament.

Getting Started

  • Install Python 2.7.
  • Install Vagrant and VirtualBox.
  • Clone this repository to your local machine:
    git clone https://github.com/m-zheng/tournament-results.git
    
  • Go to the directory that contains all code of this repository:
    cd tournament-results
    
  • Set up VM:
    vagrant up
    
  • Login to the virtual machine via SSH:
    vagrant ssh
    
  • Go to tournament directory:
    cd /vagrant/vagrant/tournament
    
  • Initialize the database:
    psql
    \i tournament.sql
    \q
    
  • Run the unit test:
    python tournament_test.py
    

License

MIT

About

Built a PostgreSQL relational database scheme to store the results of a game tournament. Also provided a number of queries to efficiently report the results of the tournament and determine the winner.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published