Backend

Installing requirements

All requirements are contained in the requirements.txt file in the CLT-webapp/backend directory.
To install, run

sudo pip3 install -r requirements.txt  

Running the backend locally

To be able to run the backend, you will need to have any version of python3 installed. The server will be running version 3.4.2.

In order to run backend locally, all you need to do is run

./clt_backend.py   

from the directory which you have the file saved in.

Alternatively, for windows you may need to run

python3|python clt_backend.py  

from the directory to run the backend.

Connecting to the database

In order to connect to the database, you have a few options.
The MySQL workbench is a graphical tool you can use to visualize the database, as well as run queries. In order to use it install it on windows, go to https://www.mysql.com/products/workbench/ and follow the instructions to download from there. If using a package manager in from debian/ubuntu linux, run the command

sudo apt-get install mysql-workbench  

To run the software, run the program and put in cltglobal.ddns.net as the host, and either the all_priv or read_only as the user. The password is in our hidden spooky place, you will need that as well.

In order to connect to the database from the command line, use the command -

mysql -h cltglobal.ddns.net -u all_priv|read_only -p

and enter the password when prompted.