CS 257: Software Design

A database-driven command-line application

Folder: database (same as last assignment!)

Tag: olympics

You may continue to work with your partner for the database design assignment, or you may work alone.

Goal

• Learn to use the psycopg2 module to access your PostgreSQL databases from within Python programs.

Rubric

Things to do

• You did the psycopg2 lab, right?
• Make sure your database/database-schema.sql file is up to date with respect to your actual olympics database.
• Save a copy of your olympics database using this Unix command:
  pg_dump --no-owner --no-privileges -U YOUR_PG_USER olympics > olympics.sql
  This will be a moderately big file (probably somewhere between 10MB and 40MB, depending on your database design), but that's OK. (Do note, however, that GitHub imposes file-size limits, so watch out for that.) This operation (including olympics.sql in your repo) will make it much easier for the grader to grade this assignment.
• Write a Python command-line program named olympics.py that enables the user to do the following:
  • Prints a usage statement for "python3 olympics.py -h" (or --help). You may use argparse or not for command-line parsing and usage statement printing.
  • List the names of all the athletes from a specified NOC.
  • List all the NOCs and the number of gold medals they have won, in decreasing order of the number of gold medals.
  • One more operation of your choosing. Simple is fine, crazily-ambitious is also fine. (Both are worth the same number of points, though crazily-ambitious may earn you more points on the Cosmic Scoreboard. Or fewer. I have no idea how the cosmos keeps score.)

Have fun!