Skip to content

RESTful API and Database Management System (DBMS) supporting CRUD operations to track video game wishlists and gift exchanges among employees at a midsize company.

Notifications You must be signed in to change notification settings

rngolam/Game-Gifters

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Game Gifters

Track video game wishlists for your company's employees.

Splash Page

Setup Environment

  • Install Node.js
  • Navigate to Game-Gifters root directory
  • Install dependencies with npm install

MySQL Database Setup

  • Create new .env file in Game-Gifters root directory
  • Add the following lines to the .env file with your MySQL database credentials
PORT={YOUR PORT}
DB_HOST={YOUR DATABASE HOST}
DB_USER={YOUR DATABASE USERNAME}
DB_PASS={YOUR DATABASE PASSWORD}
DB_NAME={YOUR DATABASE NAME}

Run App

  • Navigate to Game-Gifters root directory
  • Run app with node app.js

Navigate App

  • Navigate to localhost:{YOUR PORT} e.g. localhost:3000 in your web browser
  • There are four pages: Employees, Games, Wishes, and Gifts, each with their own tables
  • To add a row to a table, select the Add option from the dropdown menu above the table
  • To update a row in a table, click the memo icon in the row you wish to edit
  • To delete a row or multiple rows, select the checkboxes next to each row you would like to delete, then select the Delete option from the above dropdown menu
  • When adding a new Game, you can choose to enter a search query that interfaces with the Steam Store API and quickly retrieve a game's metadata

Games Table Adding a Game Searching the Steam Store Newly-added Row Deleting Multiple Games

About

RESTful API and Database Management System (DBMS) supporting CRUD operations to track video game wishlists and gift exchanges among employees at a midsize company.

Resources

Stars

Watchers

Forks