Player League

A GraphQL-based API for managing a player league, handling players, matches, and statistics.

Tech Stack

• Runtime: Node.js
• Framework: Express.js
• API: GraphQL (using express-graphql)
• Database: MongoDB
• Containerization: Docker & Docker Compose

Demo

Project Structure

player_league/
├── config/
│   └── mongo.json          # Database configuration
├── src/
│   ├── db/
│   │   └── MongoWrapper.js # MongoDB connection and wrapper
│   ├── graphql/
│   │   ├── resolvers.js    # GraphQL resolvers
│   │   └── schema.graphql  # GraphQL type definitions
│   ├── services/
│   │   ├── MatchService.js # Business logic for matches
│   │   └── PlayerService.js# Business logic for players
│   └── server.js           # Application entry point
├── .gitignore
├── docker-compose.yml      # Docker services configuration
├── index.js                # Legacy entry point (deprecated)
├── package.json
├── package-lock.json
└── README.md

Functionality

Player Handling

• Create Player: Register new players with their name, handedness (Left, Right, Ambi), and initial balance.
• Update Player: Modify player details such as active status and last name.
• Delete Player: Remove a player from the league.
• Get Player(s): Retrieve individual player details or a list of players. Supports filtering by active status and searching by name.
• Deposit: Add funds to a player's balance.
• Statistics: Automatically calculates:
  • Efficiency (Wins / Joins)
  • Number of matches joined
  • Number of matches won
  • Number of disqualifications
  • Total points earned
  • Total prize money won

Match Handling

• Create Match: Set up a match between two players.
  • Validates player existence and active status.
  • Checks if players are already in an active match.
  • Verifies players have sufficient balance for the entry fee.
  • Deducts entry fee from both players upon creation.
• End Match: Conclude a match.
  • Determines the winner based on points.
  • Awards the prize money to the winner.
  • Records the end time.
• Disqualify: Disqualify a player from an active match. The opponent is automatically declared the winner.
• Award Points: Add points to a specific player during a match.
• Get Match(s): Retrieve details for a specific match or a list of matches (active or history).

Dashboard

• Provides high-level league statistics:
  • Average player balance.
  • Count of active, inactive, and total players.

Usage

Prerequisites

• Node.js
• Docker & Docker Compose

Setup

1. Start the Database: Use Docker Compose to start the MongoDB container.

   docker-compose up -d

2. Configuration: Ensure config/mongo.json is configured correctly (default provided):

   { "host": "localhost", "port": "27017", "db": "player_league" }

3. Install Dependencies:

   npm install

4. Start the Server:

   npm start

   Note: This runs src/server.js.

5. Access the API: The GraphQL Playground is available at: http://localhost:3000/graphql

Example Queries

create player

mutation {
  playerCreate(
    playerInput: {
      fname: "Tony"
      lname: "Luo"
      initial_balance_usd_cents: 100
      handed: right
    }
  ) {
    name
    pid
  }
}

deposit

mutation {
  playerDeposit(pid: "69256f07382b9f17d1a94ae6", amount_usd_cents: 100) {
    pid
    name
    balance_usd_cents
  }
}

Get All Players

query {
  players {
    pid
    name
    num_join
    num_won
    in_active_match
    efficiency
    balance_usd_cents
  }
}

Create a Match

mutation {
  matchCreate(
    p1_id: "69256f07382b9f17d1a94ae6"
    p2_id: "69256f0a382b9f17d1a94ae7"
    entry_fee_usd_cents: 50
    prize_usd_cents: 100
  ) {
    age
    ended_at
    entry_fee_usd_cents
    is_active
    mid
    p1 {
      name
      pid
    }
    p2 {
      name
      pid
    }
    p1_points
    p2_points
    prize_usd_cents
    winner {
      name
    }
  }
}

Post points

mutation {
  postPoints(
    mid: "692802bb8d2ae9ec4d439d9f"
    pid: "69256f0a382b9f17d1a94ae7"
    amount: 100
  ) {
    mid
  }
}

Get Matches

query {
  matches(is_active: true) {
    age
    ended_at
    entry_fee_usd_cents
    is_active
    mid
    p1 {
      name
      pid
    }
    p2 {
      name
      pid
    }
    p1_points
    p2_points
    prize_usd_cents
    winner {
      name
    }
  }
}

End Match

mutation {
  matchEnd(mid: "692802bb8d2ae9ec4d439d9f") {
    age
    ended_at
    entry_fee_usd_cents
    is_active
    mid
    p1 {
      name
      pid
    }
    p2 {
      name
      pid
    }
    p1_points
    p2_points
    prize_usd_cents
    winner {
      name
    }
  }
}