|
|
# 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/www/111/lab-exercises/resit-app/splash.py
|
|
|
|
|
|
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:
|
|
|
- Add a leaderboard view, so that it is possible to see a list of the top scorers
|
|
|
- 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, or a template library such as jinja
|
|
|
- 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**. |