Appli

A job application portal API built with FastAPI, SQLModel, and PostgreSQL.

Live API: https://appli-oc5h.onrender.com/docs

Frontend: https://appli-frontend.onrender.com

Features

• User Authentication: Register and login with JWT-based authentication
• Role-Based Access Control: Separate permissions for users and admins
• Job Management: Admins can create, delete, and toggle job listings
• Application System: Users can apply to jobs and track their applications
• Application Status Tracking: Status history for applications (submitted, shortlisted, approved, rejected)

Tech Stack

• Framework: FastAPI
• ORM: SQLModel (SQLAlchemy + Pydantic)
• Database: PostgreSQL (async with asyncpg)
• Authentication: JWT (PyJWT)
• Password Hashing: PBKDF2-HMAC-SHA256
• Server: Uvicorn / Gunicorn
• Python: 3.11.9

Project Structure

src/
├── __init__.py         # FastAPI app initialization and router setup
├── config.py           # Environment configuration (Pydantic Settings)
├── dependency.py       # JWT authentication dependency
├── main.py             # Application entry point
├── model.py            # SQLModel database models
├── auth/
│   ├── routes.py       # Login and registration endpoints
│   └── util.py         # Password hashing and JWT utilities
├── db/
│   └── main.py         # Database engine and initialization
└── jobs/
    ├── admin_routes.py # Admin-only job and application management
    └── user_routes.py  # User job browsing and application endpoints

API Endpoints

Authentication

Jobs (User)

Applications (User)

Admin

Data Models

User Roles

• user - Regular user who can browse jobs and submit applications
• admin - Administrator who can manage jobs and review applications

Application Status

• submitted - Initial status when application is created
• shortlisted - Application has been shortlisted for review
• approved - Application has been approved
• rejected - Application has been rejected

Installation

1. Clone the repository

   git clone <repository-url>
   cd Appli

2. Create a virtual environment

   python -m venv venv
   venv\Scripts\activate  # Windows
   # source venv/bin/activate  # Linux/Mac

3. Install dependencies

   pip install -r requirements.txt

4. Configure environment variables

   Create a .env file in the root directory:

   DATABASE_URL=postgresql+asyncpg://user:password@host:port/database
   ACCESS_TOKEN_KEY=your-secret-key

5. Run the application

   python -m src.main

   The API will be available at http://127.0.0.1:8000

API Documentation

Once running, access the interactive API documentation at:

• Swagger UI: http://127.0.0.1:8000/docs
• ReDoc: http://127.0.0.1:8000/redoc

Usage Examples

Register a new user

curl -X POST "http://127.0.0.1:8000/appli/v1/register" \
  -H "Content-Type: application/json" \
  -d '{"name": "John Doe", "email": "john@example.com", "password": "Pass123", "role": "user"}'

Login

curl -X POST "http://127.0.0.1:8000/appli/v1/login" \
  -H "Content-Type: application/json" \
  -d '{"email": "john@example.com", "password": "Pass123"}'

List jobs

curl -X GET "http://127.0.0.1:8000/appli/v1/jobs"

Apply to a job (authenticated)

curl -X POST "http://127.0.0.1:8000/appli/v1/jobs/apply/{job_id}?resume_url=https://example.com/resume.pdf" \
  -H "Authorization: Bearer <your_token>"

Deployment

The application is configured for deployment on Render with:

• runtime.txt - Specifies Python 3.11.9
• gunicorn - Production WSGI server