TTS - Backend

The backend for the timetable selector, which is a platform that aims to help students better choose their class schedules by allowing them to see and play with all possible combinations.

Made with ❤️ by NIAEFEUP.

Installation

Prerequisites

• docker
• docker compose

Installing docker

to install docker, take a look on the official website and follow the Get docker section to install it. If you're using windows, make sure to have the wsl installed.

In case you're using linux, after installing docker check the Manage Docker as a non-root user, so you can use docker without the sudo command, which involves creating a user group for docker.

Data

The data is available at the NIAEFEUP drive (Only for NIAEFEUP members):

https://drive.google.com/drive/folders/1hyiwPwwPWhbAPeJm03c0MAo1HTF6s_zK?usp=sharing

• The 00_schema_mysql.sql corresponds to the schema for the most recent data.

• Copy the 01_data.sql and 00_schema_mysql.sql of year and semester you desire to the mysql/sql folder.

Usage

Development environment

Building the container

After you installed docker, go to the folder where you cloned this repository and do:

docker compose build

This will build the docker container for the backend.

In case you have already build the server before and want to repopulate the database, make sure you run

sudo make clean

We need to clean the database to repopulate it, since the way the mysql container works is that it only runs the sql files present in the mysql/sql folder if the database is clean. This is way we need to issue sudo make clean in order for the insert sql queries to be run.

Running the container

Before running docker, you have to create an .env file with required environment variables for the backend to work.

cp .env.dev .env

And then you need to set the correct desired values in the .env file.

The .env file is not already on the repository in order to prevent sensitive information to be leaked. This way, the file with default non important values (.env.dev) serves as a template, while the real file with important sensitive values is on .gitignore so it is never accidentally uploaded to github with sensitive information.

docker compose up 

Some django caveats after running the container

• The first time you run this docker container or after you clean the database, you will need to a wait for some time (5-10 minutes) until the database is populated. It is normal to see django giving a 115 error since the database is not yet ready to anwser to connection requests since it is busy populating itself.

• There are some times on the first execution of this command that django will start giving a2 error. If that happens, you need to close the container with docker compose down and then turning it on with docker compose up again.

Accessing the development database

We are currently using phpmyadmin and you can access it

1. Go to localhost:4000

2. On the login screen, both the username and password are root. This is fine, since this is only a development environment