/highlander-react-redux

A web app for coaches to manage their team's stats, averages, trash talk, and poach players from other teams.

Primary LanguageJavaScript

Highlander Build Status

Live Demo

Link: Coming soon!

Description

A simple app for coaches to manage their teams stats, averages, trash talk, and poach players from other teams.

Current MVP version omits 🚫:

  • Poaching power 👊
  • Player averages 📊
  • Trash talk 🙊

Want to keep up with the development and roadmap of Highlander? https://trello.com/b/p1gqbNtQ/thinkful-capstone-highlander

Screenshots

main page

Dashboard

dashboard

Add a Team

add team

View List of Teams

list of teams

Add Player

add players

Add Stat

add stat

Tech Stack

  • DB: cloud-hosted PostgreSQL instance

  • Server: Node, Express, Morgan, Knex, Bookshelf, Bcrypt

  • Client: React, Redux, CSS, Bulma

Database Structure

http://dbpatterns.com/documents/58c5ff7f1514b438af1a805e/

Tables

coaches

id email first_name last_name
123 isaac@gmail.com Isaac Brewman
124 danny@yahoo.com Danny Guach

coaches_teams

coach_id team_id
1 3
2 1
1 1

teams

id name city state
1 Highlander Bronx NY
2 Braves Brooklyn NY
3 Brew Crew Queens NY

teams_players

team_id player_id
1 4
2 2
3 7

players

id first_name last_name email password position
1 Ricardo Roman romanR@gmail.com Bcrypt(hash) 2nd base
2 Randy Brown brown@yahoo.com Bcrypt(hash) Catcher
3 Big Mac BG@yahoo.com Bcrypt(hash) 3rd base

stats

player_id stat_catalog_id how_many
1 4 56
2 2 3
3 6 24

stat_catalogs

id description
1 Hits
2 At Bats
3 Home Runs
4 Earned Runs
5 Innings Pitched
6 Strikeouts

Endpoints:

coach

  • router.get('/')

  • router.get('/:id')

  • router.post('/')

  • router.post('/login')

  • router.put('/:id')

player

  • router.get('/')

  • router.get('/:id')

  • router.get('/:id/stats')

  • router.post('/')

  • router.post('/:player_id/stats/:stat_catalog_id')

  • router.put('/:player_id/stats/:stat_catalog_id')

team

  • router.get('/')

  • router.get('/:id')

  • router.post('/')

  • router.post('/:id/player')

  • router.put('/:id')

stat

  • router.get('/')
  • router.get('/:id')