/lunch-service

A simple prototype application to manage the logic behind restaurant tickets of a public university in Colombia.

Primary LanguageHTMLGNU General Public License v3.0GPL-3.0

A simple prototype application to manage the logic behind restaurant tickets in a public university in Colombia, this use the security features of a database, then there are many features which are not included. This prototype will include:

  • application process
  • restaurant tickets
  • review of applications

It is worth to say it is just a prototype and it is develop for academic purposes for the subject databases, then the backend contains "many" problems.

Demo

Instructions

Database

  $ cd schema
  # creates the db apoyo_alimentario and connect to the schema using psql
  $ sh utils/init.sh
  # execute the script to load the db, roles, grants, stored procedures, triggers
  apoyo_alimentario=# \i main.sql
  # exit of psql
  apoyo_alimentario=# \q

App

 $ python3 -m venv env-lunch/
 $ source env-lunch/bin/activate
 (env-lunch)$ pip3 install -r requirements.txt
 (env-lunch)$ cd app/
 (env-lunch)$ flask run # export FLASK_APP=app.py

Testing

 $ cd app/
 $ python3 -m pytest tests

Email

 $ export MAIL_USERNAME=XXXXX
 $ export MAIL_PASSWORD=XXXXX

Domain Model