🎪 Event Management System

A blazing-fast 🏃‍♂️, offline-first 📴, and scalable ⚡ backend for managing attendees, check-ins, wristbands, and more — all powered by FastAPI + PostgreSQL + RFID.

---

🚀 Features

• 🎟️ Attendee Onboarding via CSV
• 🚂 RFID Wristband Assignment
• ⏱️ Real-time Check-in/Check-out Tracking
• 🡾 Freebies & Kit Distribution Tracking
• 🔌 Offline Caching for Desks
• 🔄 Multi-System Syncing with Conflict Resolution
• 🔒 Data Integrity & Deduplication

---

🧠 Tech Stack

Layer	Tech
Backend API	⚡ FastAPI
Database	🐘 PostgreSQL + SQLite (Offline)
RFID Interface	🎯 PySerial / Device SDK
Caching	📦 Local JSON / SQLite
Deployment	☁️ Docker-ready

---

🛠️ Setup Instructions

1. Clone the repo

git clone https://github.com/ashvp/Event-Management.git
cd Event-Management

2. Install dependencies

python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate
pip install -r requirements.txt

3. Setup PostgreSQL

Create a .env file with your DB creds:

DATABASE_URL=postgresql://user:pass@localhost:5432/rfid_event

Run migrations:

alembic upgrade head

4. Run the backend

uvicorn app.main:app --reload

---

🧪 Testing

pytest

---

📆 API Endpoints

POST   /attendees/upload_csv                 → Bulk onboard via CSV
GET    /attendees/                           → Get all attendee info
POST   /attendees/                           → On spot registration
POST   /attendees/{attendee_id}/assign_rfid  → Assign RFID to attendee
GET    /attendees/rfid_export/               → Downloads RFID
POST   /check-in/                            → Check in attendee
POST   /claim/{item_name}                    → Claiming an offered item
GET    /event_days/                          → Get event days
POST   /event_days/                          → Add event days
GET    /dashboard/stats                      → Get basic stats
GET    /dashboard/                           → Dashboard with advanced search

📚 Full docs available at /docs via Swagger UI.

---

🤝 Contributing

Wanna help out? Pull requests welcome! Please follow the conventional commits style and keep PRs atomic.

---

🚇 Known Challenges

• RFID reader behavior can vary by vendor 🤷‍♂️
• Offline-first mode can cause timestamp conflicts — we dedupe based on uuid + ts
• SQLite schema must match production schema — auto-migration WIP 🔧

---

📊 Future Improvements

• Admin Dashboard (React / Streamlit / Vue)
• PDF Badge Generator
• Realtime WebSocket Sync
• Telegram Bot for Check-in Alerts 📲

---

🐛 Bug? Suggestion?

Open an issue or hit us up via carrier pigeon. Seriously, just open an issue ☛ here

---

📜 License

MIT © Ashwin 2025

---

💡 Fun Fact

Each wristband is basically a tiny dumb storage device with a superpower: being at the right place at the right time.

---