SQL Database

[aidanprk]

We need a way to store user data in tables. I suggests looking into sqlite3 which is integrated into python. Table(s) should hold:

Students

• Username
• Problem Status (up or down cup)
• Problem Statement (The Written out problem stated in the student page)

Class

• Class code
• Class name
• project name

2 man-hours

[aidanprk]

Don't use sqlite3, flask has more temporary database functions

[TheCoub]

I will take this task. Reminder to self: Local Storage

[JCharante]

@aidanprk What temporary database functions? Could you be referring to sqlalchemy-flask which is a flask integrated database solution? In that case I'd actually go with vanilla sqlalchemy to keep your stack flexable.

In the case that you do end up going with sqlalchemy, it's fairly easy to get started. You can read this guide and how I personally like to breakup my files is

• db_setup.py
  • declare tables here
• db_functions.py
  • Create all the functions that will interact with the database
  • This file will be imported by your flask app)
• util.py
  • Has a bunch of static utility functions here such as hashing passwords, checking if entered password is the same as a stored hashed password, checking if a password is secure enough.

Even if you don't follow my preferred style, I'd still recommend adding version names to your tables, as it makes migrating to newer tables much easier.