Welcome to our database final project

Contributors

Patrick O'Shea
Yaniv Kovalski
Parker Rowley

To clone the repository

git clone https://github.com/oshea-patrick/database_management.git

To install the required modules

cd database_management
npm i

To start the project in your window (live reload)

npm start

Stack implmentation

Frontend: React/Javascript/HTML/CSS (hosted locally)
Backend: Python3/Flask hosted at 18.221.103.54:5000
Database: Oracle hosted at csc325spring2021.cjjvanphib99.us-west-2.rds.amazonaws.com:1521

API Methods

URL: ENDPOINT/getUser
METHOD: POST
body : {
"email" : "",
"first_name" : "",
"last_name" : "",
"password" : ""
}
Response on Success: [true, {"email": "hpotter1@students.hogwarts.edu", "first_name": "Harry1", "last_name": "Potter", "password": "test"}]
Response on Failure: [false, ""]

URL: ENDPOINT/signup
METHOD: POST
body : {
"email" : "",
"first_name" : "",
"last_name" : "",
"password" : ""
}
Response on Success: 'Success'
Response on Failure: 'Failed'

URL: ENDPOINT/getLocations
METHOD: POST
body : no body
Response on Success: [location object, ...]
Response on Failure: []

URL: ENDPOINT/getReservations
METHOD: POST
body : no body
Response on Success: [reservation object, ...]
Response on Failure: []

URL: ENDPOINT/joinReservation
METHOD: POST
body : {
"email" : "",
"time_block" : "",
"location_name" : "",
"address" : ""
}
Response on Success: 'Success'
Response on Failure: 'Failed'

URL: ENDPOINT/getRegisteredReservations
METHOD: POST
body : no body
Response on Success: [sign object, ...]
Response on Failure: []

URL: ENDPOINT/getItems
METHOD: POST
body : no body
Response on Success: [item object, ...]
Response on Failure: []

URL: ENDPOINT/checkoutItem
METHOD: POST
body : {
"item_name" : "",
"location" : "",
"email" : ""
}
Response on Success: 'Success'
Response on Failure: 'Failed'

URL: ENDPOINT/getCheckedOutItems
METHOD: POST
body : no body
Response on Success: [check object, ...]
Response on Failure: []

oshea-patrick/database_management