/AttendanceManager

Final Project for Databases course at Universidad del Norte

Primary LanguagePython

AttendanceManager

This repository is the Final Project for Databases course at Universidad del Norte. It was made using FlaskAppBuilder and an Oracle Database.

Features

  • Simulate the database structure of a University
  • Assistance manager for all Students and Professors
  • Record of Attendance for every class
  • Basic CRUD features for every table of the database only accesible to the admin

Preview

Welcome Welcome screen

History Attendance Record of a student

Setup

  1. Install all requirements using pip install -r requirements.txt

  2. Create a file nammed conn_string.py that should look like this:
    cs = 'oracle://user:password@host:port/serviceName'

  3. In your terminal run the following commands:

$ export FLASK_APP=app

# Creates all tables of the database filling it with the data provided in 'test_data.py'
$ flask initdata

# Creates all the users for every student, teacher and an admin user
$ flask createusers
$ flask run
  1. The Webapp should now be running in localhost:5000