Skip to content

NecroReindeer/comp110-coding-task-1

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 

Repository files navigation

COMP110 Coding Task 1

I designed the database and the high score processing algorithms to interact with my Kivy game project.
The primary key for levels is not auto-incremented, as level names are added corresponding to the level number, and the level number is used as the primary key.
If any of the requests are unable to retrieve or add the requested data, they print None. This is to make it easier to for my Kivy game to know the result of its request. Any functions that are used by more than one of the algorithms are located in processing.py.

Note: Commits have only happened in the last couple of weeks because I was leaving this project until last, as it is much smaller than the others. This project being much smaller than the others is also the reason for significantly less commits.

##Locations of Algorithms Required for Assignment

Algorithm File Fields Required for GET Request
retrieve the top 10 high scores from a database server getscores.py level
retrieve the highest score of a given user getbest.py player, level
insert new users adduser.py player
update user names updatename.py player, new
insert new high scores into the database server submitscore.py player, level, score
update high scores in the database updatescore.py player, level, score
SQL file highscores.sql

##Entity Relationship Diagram for Database One player can have zero to many scores. One level can have zero to many scores. A score can have one and only one player. A score can have one and only one level.

Entity Relationship Diagram

About

A client-server database system to support a mobile game app.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%