SkillSprint is a full-stack ASEP/capstone project that centralizes coding contests, MCQ quizzes, hackathons, and tech opportunities for students.

• Lets students register and log in.
• Lets admins/teachers host quiz tests and coding contests.
• Lets students attempt MCQ tests and stores scores.
• Lets users create contest submissions (currently stored with PENDING verdict).
• Exposes all APIs through FastAPI Swagger docs.

• FastAPI
• SQLAlchemy
• SQLite locally (backend/skillsprint.db)
• PostgreSQL on Render via DATABASE_URL using psycopg3

• backend/database.py: DB engine, SessionLocal, Base, get_db
• backend/models.py: User, Test, Question, QuizSubmission, Contest, ContestProblem, ContestSubmission
• backend/schemas.py: Pydantic request/response models
• backend/routes/auth_routes.py: /auth/register, /auth/login
• backend/routes/quiz_routes.py: quiz endpoints
• backend/routes/contest_routes.py: contest endpoints
• backend/main.py: app init, CORS, router registration
• backend/seed_data.py: sample data seeding

cd backend
python -m pip install --upgrade pip
pip install -r requirements.txt
python seed_data.py
uvicorn main:app --reload

docker build -t skillsprint-backend .
docker run -p 8000:8000 --env-file backend/.env skillsprint-backend

The Docker image includes the toolchains required for the compiler engine:

• gcc, g++, gdb
• Python, Node.js, Java, PHP, Go, Rust, R

1. Set DATABASE_URL to your Render PostgreSQL connection string.
2. From the backend folder, run:

python migrate_sqlite_to_postgres.py

3. If you want to overwrite rows already in Postgres, run:

python migrate_sqlite_to_postgres.py --clear-target

Open:

• API root: http://127.0.0.1:8000/
• Swagger docs: http://127.0.0.1:8000/docs

From project root:

python -m http.server 5500

Open:

• Landing page: http://127.0.0.1:5500/index.html
• Quiz page: http://127.0.0.1:5500/frontend/html/quiz.html

• POST /auth/register
• POST /auth/login

• GET /quiz/tests
• GET /quiz/tests/{test_id}/questions
• POST /quiz/tests/{test_id}/submit
• GET /quiz/admin/tests/{test_id}/submissions

• POST /contests
• GET /contests
• GET /contests/{contest_id}
• POST /contests/{contest_id}/problems
• POST /contests/{contest_id}/problems/{problem_id}/submit
• GET /contests/{contest_id}/submissions

• GET /compiler/languages
• POST /compiler/run
• POST /compiler/debug

Supported execution languages in the backend engine:

• c, cpp, python, javascript, java, php, go, rust, r

Web-oriented languages are recognized with preview-only responses:

• html, css, react, typescript

For full multi-language execution in deployment, install runtime/toolchain binaries on the host/container:

• gcc, g++, python, node, javac/java, php, go, rustc, Rscript
• Optional debug support: gdb (for C/C++ debug endpoint)

• http://localhost:5500
• http://127.0.0.1:5500
• https://dreynox.github.io