This project consists of:

• Frontend: Flutter web application
• Backend: FastAPI Python application
• Database: PostgreSQL

• Backend API and Database Setup
• README.md Documentation for Migration
• README.md Documentation for Testing

• Python 3.8+
• PostgreSQL database

First, set up a Python virtual environment to isolate project dependencies:

python -m venv venv

# Activate virtual environment
# Windows:
venv\Scripts\activate
# macOS/Linux:
source venv/bin/activate

You should see (venv) in your terminal prompt when the environment is active.

With your virtual environment activated:

cd App
pip install -r requirements.txt

or alternatively, from the root directory:

pip install -r App/requirements.txt

Return to main directory by running cd ..

Create a .env file based on the template in .env.example.

cp .env.example .env

For security, actual credentials shall be sent separately. After entering the credentials into the created .env file, save the document.

Connecting to Dockerized PostgreSQL

Database Details: Available upon request.

Refer to the link to download Docker Desktop: https://docs.docker.com/desktop/

After downloading Docker Desktop, open Docker Desktop on your device. Then, use the appropriate command for your system:

## Mac / Windows (Docker Desktop)
docker compose -f Infrastructure/docker-compose.yml up -d --build

## Linux (some distributions still use the old binary)
docker-compose -f Infrastructure/docker-compose.yml up -d --build

or alternatively, you can first move into the Infrastructure directory:

# Make sure you are in the main directory, if not, run `cd` ... 
cd Infrastructure

Then, use the appropriate command for your system:

## Mac / Windows (Docker Desktop)
docker compose up -d

## Linux (some distributions still use the old binary)
docker-compose up -d

1. Open pgAdmin using either Docker Desktop or your local installation.
   • If using Docker Desktop:
     • a. Make sure your pgAdmin container is running.
     • b. Open Docker Desktop → Click on the Containers tab.
     • c. Find the container named pgadmin.
     • d. Under Port(s), click the port number (usually 5050). This will open pgAdmin in your browser.
     • e. Login using the credentials as defined in .env file:
       • Email Address / Username: PGADMIN_DEFAULT_EMAIL
       • Password: PGADMIN_DEFAULT_PASSWORD
     • f. Click the dropdown next to servers. If the server and database is listed under servers, then you can skip steps 2-6
   • If installed locally:
     • Simply search for pgAdmin in your system applications and launch it, which will open in your default browser.
2. Login using the credentials as defined in .env file:
   • Email Address / Username: PGADMIN_DEFAULT_EMAIL
   • Password: PGADMIN_DEFAULT_PASSWORD
3. Click on: Quick Links - Add New Server.
4. . General tab:
   • Name: CITS3200 (or any name you like)
5. Connection tab:
   • Host name/address: postgres if in Docker, localhost if on your local PGAdmin
   • Port: 5432 or 5434 (if pgAdmin was installed locally)
   • Maintenance database: postgres
   • Username: Refer to DATABASE_USER as provided
   • Password: Refer to DATABASE_PASSWORD as provided
6. Click Save.
7. You should now see the databases
8. Perform a right-click on "mydb_verVB"
9. Select Query Tool (To create SQL Queries)
10. eg. SELECT * from location_type

Alembic is used for managing database schema migrations with SQLAlchemy and PostgreSQL.

In your project root (where your database code lives):

# Make sure you are in the main directory, if not, run `cd` ... 
alembic init alembic

This creates an alembic/ directory and an alembic.ini config file.

• Open alembic.ini and set your database URL If you are using the Docker container, then set the URL as:

# line 66 of file or ~line 87 of the file
sqlalchemy.url = postgresql+psycopg2://<user>:<password>@postgres:5432/<databasename>

If you are using the local installation of PGAdmin instead, the set the URL as:

# line 66 of file or ~line 87 of the file
sqlalchemy.url = postgresql+psycopg2://<user>:<password>@localhost:5434/<databasename>

• In alembic/env.py, import your SQLAlchemy models and set metadata:

from App.models import Base  
target_metadata = Base.metadata   # ~ line 24 of env file

Using existing database schema (backup.sql), create an initial alembic migration version:

alembic revision -m "Initial migration"

Ensure your PostgreSQL database is running and accessible with the credentials specified in your .env file.

API will be available at http://localhost:8000

Once the application is running, you can access:

• Interactive docs: http://localhost:8000/docs
• Alternative API docs: http://localhost:8000/redoc

To set up Flutter, refer to the official set-up guide: Flutter Installation Guide

To check that Flutter is installed and available on your system, run the following in your Terminal:

flutter doctor -v

Run the following command in your Terminal:

flutter config --enable-web

Run the following command in your Terminal:

flutter build web

Run the following command in your Terminal:

flutter run -d web-server