A final project for CPSC 304 - Introduction to Relational Databases, Summer 2020 T1. This project is a bare bones skeleton for a delivery/service app. In light of the COVID-19 pandemic, this app was designed to help people who are immunocompromised, disabled, or for other reasons - aren't able to go out to purchase essential items.
Database is hosted on Heroku via ClearDB addon with NodeJS & Express JS, and ReactJS functioning as our back-end and front-end stack respectively.
- MYSQL Community Edition 8.x.xx
- NodeJS v12.xx.x
- NPM v6.xx.x
- Clone the repository onto your desktop. You can do this by launching Terminal and entering
git clone https://github.com/tommytwm/store-2-door.git
- Launch terminal and make sure the root is at the repository. You can do this by entering
cd store-2-door
on Terminal. - Run the following script on your Terminal:
npm install
. It should install all node dependencies.
- Run the app by entering
node app.js
. You should see some logs printed on your terminal. - Launch your local host in your browser of choice. For example,
http://localhost:3000/
- Run the app by entering
npm run dev
. You should see some logs printed on your terminal. - Launch your local host in your browser of choice. For example,
http://localhost:3000/
. This is webpage of your app.
We are using Heroku as our hosting service to store and manage our database via MYSQL. To manually connect and contribute to the database, connect to the MYSQL server (credentials can be found in the config file(s)): mysql --host={HOSTNAME} --user={USERNAME} --password={PASSWORD} --reconnect {DB}
You should now be able to enter SQL commands and contribute to the database.
For any major changes that affects the structural integrity connecting the database with the back-end (API endpoints and functionalities for example) make sure to follow this deployment process:
- Create a pull request from your personal branch to master branch.
- Get another developer to review your pull request. Make changes if necessary.
- Approve the pull request and merge into master.
- On terminal, enter the script
git push heroku master
to deploy the update master branch code to heroku