How saurabhalex/sql-server-user-module works
Project type and purpose
• This is a backend RESTful API service built with FastAPI, SQLAlchemy, and Pydantic.
• Its single purpose is to manage users (CRUD operations) against a relational database (PostgreSQL or SQL Server via ODBC/Azure).
File structure
• Top-level:
• .env – holds the DATABASE_URL.
• main.py – entry point that creates the FastAPI app and mounts routers.
• azure_sql_api.py & helper scripts – demonstrate or patch Azure/ODBC connectivity.
• requirements.txt – Python dependencies.
• app/ module:
• database.py – initializes SQLAlchemy engine and session.
• models.py – declares ORM models (the User table).
• schemas.py – Pydantic request/response models for data validation.
• routers/users.py – defines all user endpoints (GET, POST, PUT, DELETE).
README
• Confirms the tech stack: FastAPI + Uvicorn, SQLAlchemy ORM, Pydantic, Azure/Postgres DB.
• Lists available endpoints and database schema.