limjiajing / cz-4031-project-2

cz4031-project-2

This repository contains the implementation for Project 2 of "Database Systems Principles (CZ/CE4031)".

Requirements

1. Extract files from zip file cz4031-project-2.zip
2. Enter directory cz4031-project-2
3. Python version >= 3.9

Install dependencies

pip install -r requirements.txt

Login Details

1. Access the preprocessing.py file and edit lines 9-12
2. Lines 9-12 will be edited according to the User's Database Account Details

Two ways to run the program

1. Run the python file (project.py)
2. Run in terminal

1. Python file

1. Double click project.py to open the program in an IDE of your choice
2. Run project.py in the IDE.

2. Run in terminal

1. Launch terminal in project directory
2. Type the following to run project.py

   python project.py

or

   python3 project.py

MANUAL FOR OUR PROGRAM

1. Before running project.py, the User should first open preprocessing.py and edit their User Login Details from lines 9-12 for their Postgres Database.

2. After running project.py, there will be a pop-up window and the program will first ask the user to input their sql query on the left side of the UI. The user will then press submit. If the user’s input details is incorrect, the pop-up window will exit.

3. After pressing submit the UI will display the output formatted query and the annotations on the right side of the UI.

4. Before type in the new query, please click the clear button to clear the current output and query in the input box.