🎲 Poker Tracker Backend (MySQL)

A backend application to manage and track poker game data. Built with Node.js, Express, and MySQL.

📁 Project Structure

Pocker_Tracker_backendmysql/
├── config/           # Database and app configuration
├── controllers/      # API route handlers
├── middleware/       # Authentication & custom middleware
├── models/           # Database models (tables)
├── routes/           # API routes
├── uploads/          # File uploads
├── .env              # Environment variables
├── .gitignore
├── package.json
└── poker.js          # Entry point of the application

⚙️ Technologies Used

• Node.js
• Express.js
• MySQL
• dotenv
• bcryptjs (for password hashing)
• jsonwebtoken (for authentication)

🗄️ Database Tables and Relationships

Here’s an overview of the key tables:

Table Name	Description	Relationships
users	Stores user info	user_id linked to games and transactions
games	Stores poker game sessions	game_id linked to transactions
transactions	Tracks bets, wins, and losses	user_id → users, game_id → games
tables	Stores poker table info	table_id → games
chips	Tracks chip counts per user per game	user_id → users, game_id → games

Example Relationships:

• User ↔ Games: One user can participate in multiple games.
• Game ↔ Transactions: Each game has multiple betting transactions.
• User ↔ Chips: Each user’s chip count is tracked per game.

🚀 Getting Started

Prerequisites

• Node.js v14+
• MySQL server

Installation

1. Clone the repo:

git clone https://github.com/AnuragFrantic/Pocker_Tracker_backendmysql.git
cd Pocker_Tracker_backendmysql

2. Install dependencies:

npm install

3. Create a .env file:

DB_HOST=localhost
DB_USER=root
DB_PASSWORD=yourpassword
DB_NAME=poker_tracker
JWT_SECRET=your_jwt_secret

4. Run the app:

node poker.js

📄 API Endpoints

• POST /api/users/register → Register a new user
• POST /api/users/login → User login
• GET /api/games → Fetch all games
• POST /api/games → Create a new game
• POST /api/transactions → Add a new transaction
• GET /api/users/:id/chips → Get user’s chips

(Check routes/ folder for more endpoints.)

🔒 Authentication

Uses JWT tokens. Users must send the token in the Authorization header as:

Authorization: Bearer <token>

📌 License

MIT License. See LICENSE for details.