Skip to content

kongling893/Tournament-Results-UDACITY

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Project 2: Tournament Results

=============================

This is the code for the study of the "Full Stack Web Developer Nanodegree" on Udacity.

This project requires defining the database schema (SQL table definitions) for a Swiss tournament system and writing a Python module that uses the PostgreSQL database to keep track of players and matches in a game tournament.

The game tournament uses the Swiss system for pairing up players in each round: players are not eliminated, and each player is paired with another player with the same number of wins, or as close as possible.

In this project:

  • Database scheme was desinged at first to fulfill Swiss tournament system;
  • PostgreSQL database was used to implement this scheme;
  • Python module was wrote to interact with the database and rank the players in the tournament.

How to Run:

  1. Import the database scheme into PostgreSQL database.

Type the following commands on you terminal:

psql -> create database tournament; -> \c tournament -> \i tournament.sql -> \q

Make sure that the directory of your terminal is the same with the directory your codes under.

  1. Run the tests of this project by typing

    python tournament_test.py

You will see the information of noticing successful running.

About

This is the second project of the "Full Stack Web Developer Nanodegree" on Udacity

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages