Prototype Implementation

Overview

The first prototype is a command-line interface (CLI) application written in Python that demonstrates six use cases through direct interaction with the PostgreSQL database. The prototype uses psycopg2 for database connectivity and bcrypt for password hashing. All data selections are presented as numbered lists so the user never needs to remember identifiers.

Technology

Component	Technology
Language	Python 3
Database Driver	psycopg2-binary
Password Hashing	bcrypt
Database	PostgreSQL 16 (Docker)

Implemented Use Cases

ID	Title	Actor	Details
UC0001	Browse Available Resources	All roles	Implementation
UC0002	Make a Resource Reservation	Teaching Staff	Implementation
UC0003	Approve or Reject Reservations	Administrator	Implementation
UC0007	View Resource Usage Analytics	Administrator	Implementation
UC0008	Log In to the System	All roles	Implementation
UC0009	Register a New User	Administrator	Implementation

Application Structure

File	Description
main.py	Entry point: login with email/password, role-based main menu
db.py	Database connection helper and shared UI utilities
uc_browse.py	UC0001: Browse Available Resources
uc_reserve.py	UC0002: Make a Resource Reservation
uc_approve.py	UC0003: Approve or Reject Reservations
uc_analytics.py	UC0007: View Resource Usage Analytics
uc_users.py	UC0009: Register a New User

Source Code

The source code is publicly available at: ​https://github.com/Teo03/FRRUAS-prototype

Build and Run

See BuildInstructions.