🚀 FastAPI SQL Server Project

Backend project built with FastAPI in Python, using a clean modular architecture and connected to SQL Server. Designed to be maintainable, scalable, and ready for production.

---

🧱 Tech Stack

• 🐍 Python 3.13
• ⚡ FastAPI
• 🛢️ SQLAlchemy + Alembic
• 🧮 SQL Server (via pyodbc)
• 🔐 Pydantic v2
• 🔄 JWT Authentication (coming soon)
• 🧪 Uvicorn (development server)

---

📁 Project Structure

app/
├── main.py                # App entry point
├── config.py              # Environment & DB settings
├── database.py            # DB connection setup
├── models/                # SQLAlchemy models
├── schemas/               # Pydantic schemas (validation)
├── repositories/          # Data access layer
├── services/              # Business logic
├── routers/               # FastAPI route definitions
└── utils/                 # JWT, security, and helpers

---

⚙️ Getting Started

1. Clone the repository:

   git clone https://github.com/your_user/fastapi-project.git

2. Create and activate a virtual environment:

   python -m venv env
   env\Scripts\activate   # Windows

3. Install dependencies:

   pip install -r requirements.txt

4. Create your .env file:

   database_hostname=localhost
   database_port=1433
   database_username=your_user
   database_password=your_password
   database_name=FastApiDB
   
   secret_key=YourSuperSecretKey
   algorithm=HS256
   access_token_expire_minutes=30

5. Run Alembic migrations:

   alembic upgrade head

6. Launch the server:

   uvicorn app.main:app --reload

---

📡 Endpoints

• / — Health check
• 🔐 Auth & CRUD endpoints coming soon...

---

🔜 Coming Soon

• JWT Authentication
• Role-based Permissions
• Unit & Integration Testing
• CI/CD & Production Deployment

---

👨‍💻 Author

Built with ❤️ by Javier Méndez aka jam300 GitHub — LinkedIn

---