A Casino Database Management System. This Repo contains only the backend. Front-End Repo - https://github.com/iamfauz/Casino304-App
Check google drive folder for more info - https://drive.google.com/drive/folders/1iY7cgz8o0zcPrrHRTL30F1ROklkidkJz?usp=sharing
There is file calledinitDBSql.sql that contains the sql script that creates all the tables and adds dummy data to it.
All SQL queries used can be found in the controller files. Go to api/server/controller/. You'll find all the neccesary SQL queries used to interact with our remote db.
https://docs.google.com/document/d/1pALJscXqIRhUh1yVWfpVBWvXBYJGrB_kO3VoUPx5N-0/edit?usp=sharing
MVC (Model-View-Contoller) architecture is used powered by routes and controllers
- You need to have Node and NPM installed on your computer.
- Installing Node automatically comes with npm.
- Clone this project to your local machine 'http://github.com/iamfauz/Casino304'
- Installing the project dependencies
Run the command below
$ npm install
- Start your node server
run the command below
$ npm run dev
- Use
http://localhost:3000as base url for endpoints for now. Will Deploy to heroku or Zeit Now later
| METHOD | DESCRIPTION | ENDPOINTS |
|---|---|---|
| GET | Gets all players | /players |
| GET | Login for player | /players/login |
| DELETE | Delete player by id | /players/:id |
| GET | Get All games | /games |
| POST | Create Game | /games |
| GET | Get a game by id | /game/:id |
| GET | Get all games filtered by date | /games?game_date='date' |
| GET | Get all gameplays filtered by date | /gameplays |
| GET | Get gameplays info of a player | /gameplays/player?player_id=id |
| GET | Get players who have played all games | /gameplays/leaderBoards |
| GET | Count a players games | /gameplays/count |
| PATCH | End Game by entering endTime | /gameplays/endGame |
| GET | Count all games played by a player | /aggregate/total_games?player_id=id |
| GET | Total rake for each date | /aggregate/total_rake_by_date |
| GET | Get all the tables types for each branch | /branches |
| GET | Get the names of all of the branches | /branches/branchnames |
| PATCH | Update Employee data | /employees/:id |