Skip to content

GitLab

L
lab-exercises
Last edited by Sorrel Harriet
Page history

resit coursework 2018

IS52027C Resit Coursework Brief (Summer 2018)

Deadline: 17:00PM 10th August 2018

If you are unsure whether you should be retaing the coursework element of the module, please check with department admin (computing@gold.ac.uk).

Part 1: Design and implement a MySQL database backend

  • Clone or pull latest changes from the term 1 lab extercises repo: git clone git@gitlab.doc.gold.ac.uk:data-networks-web/lab-exercises.git OR cd lab-exercises git pull origin master
  • Inside you will find a new directory, resit-app, inside which is the code for a simple hangman game app.
  • A live demo of the application can be found here: http://www.doc.gold.ac.uk/usr/111/cgi-bin/splash.py (let Sorrel know if it goes down!)

Your first task is to implement a MySQL backend for the app and deploy a working version on Igor.

  • Look at the hangman application code to figure out what tables need to be created, and what fields they should have
  • Create the database and insert some dummy data
  • Hook the database up to the application code (CLUE: edit cgi_bin/config.py)

Note: You may complete Part 1 without editing any of the application code apart from the config.py script. However, you are not prohibited from editing it.

Part 2: Second iteration

In this part of the coursework, you should develop this application a stage further.

  • It is up to you what improvements you make to the application, but they should constitute an improvement.
  • Improvements may be new functionality, or improved engineering of the existing app.
  • Some suggestions are:
    • Develop the leaderboard view. Perhaps this will involve using a template engine such as Jinja?
    • Add (or start adding) login functionality so that the same player needn't always play
    • Develop the architecture. This might involve adopting an app framework such as flask
  • Make sure your ``improved'' version of the app is deployed on a Virtual Server and set to run continuously

You will probably find the Term 2 materials most helpful in this part of the assignment.

Submission Instructions

  • You should submit your new version of the hangman application as a Gitlab repo (hint: create a new project on Gitlab and copy the files to it. Refer to the Lab Exercises Wiki if you need reminding how to add and commit files).
  • You should ensure a working copy of the complete application is deployed on a Virtual Server, and that the URL is included in the app README file on Gitlab.
  • Also in your README, include a brief explanation of the changes you've made in response to Part 2.
  • Make sure that Sorrel Harriet and Dan McQuillan both have access to your repo. You do this from the Gitlab project dashboard under settings > members.

If you are uncertain about any of the above, please get in touch! The deadline for submisisons is 17:00 PM August 10th 2018.