Navigate to the gRPC directory
cd ./grpc
The requirement dependencies can be found in ./grpc/requirement.txt
Install dependencies using the following command
pip install -r requirements.txt
The gRPC server can be found in ./grpc/server.py
Run the Server
python server.py
The gRPC client can be found in ./grpc/client.py
Run the Client
python client.py
User are required to login to use the features The following login credentials are provided
The user and officer are pre-set in the system
Normal User | |
---|---|
name: | user1 (The following name works as well: user1,user2,user3,... user10) |
nric: | 98765432 |
Officer | |
---|---|
name: | officer |
nric: | 98765432 |
After Login, user will be prompted serveral options
Users will be able to naviagte the UI by selecting the available options
If an invalid input is selected, users are required to re-run the client program
Accessing the database would require 'psql' to be installed
The installation guide can be found in postgresql_guide.pdf
psql -d testing -U postgres -h 174.138.23.75 -p 5432
Password: cl0udplus!
Navigate to the Database Directory
cd Database
Drop Schema
psql -d testing -U postgres -h 174.138.23.75 -p 5432 -f './drop.sql'
Create Schema
psql -d testing -U postgres -h 174.138.23.75 -p 5432 -f './main.sql'
Bootstrap with Sample Data
psql -d testing -U postgres -h 174.138.23.75 -p 5432 -f './init.sql'