This is a simple User Service CRUD (Create, Read, Update, Delete) API built with FastAPI and SQLite. The API allows you to create, read, update, and delete users. It uses Pydantic models for request and response validation and SQLAlchemy for database operations.
This project follows a clean architecture pattern, separating concerns to enhance maintainability and scalability. Here's a brief overview:
- API Layer (FastAPI): Handles HTTP requests and responses, routing, and interaction with the service layer.
- Service Layer: Contains business logic and communicates with the database layer.
- Database Layer (SQLite): Manages data persistence and database operations.
- Testing: Unit tests are written in Pytest to test the service layer functions.
- Python 3.12
- FastAPI
- SQLite
- Uvicorn (for running the server)
This project uses Poetry for dependency management.
If you're not familiar with Poetry, please follow these instructions to install it.
Once you've installed Poetry, you can install the dependencies using the following command:
$ poetry install
Then run the below command to activate the virtual environment.
$ poetry shell
If you prefer using pip
, you can create a virtual environment and then install the dependencies using the following command:
$ pip install -r requirements.txt
To run the server, use the following command:
$ uvicorn app.main:app --host localhost --port 8000 --reload
This will spin up the server at http://localhost:8000
with a local SQLite database users.db
.
POST /api/users/
: Create a new user.
To create a user, send a POST request to http://localhost:8000/api/users
with the following JSON payload:
{
"first_name": "John",
"last_name": "Doe",
"address": "123 Fake St",
"activated": true
}
As we use Pydantic models, the API will validate the request payload and return an error if the payload is invalid.
GET /api/users/
: Get all users.
To get all users, send a GET request to http://localhost:8000/api/users
.
GET /api/users/{userId}/
: Get a user by ID.
To get a user by ID, send a GET request to http://localhost:8000/api/users/{userId}
.
If the user with the specified ID does not exist, the API will return a 404 Not Found response. The same logic is carried out for the Update and Delete endpoints.
PATCH /api/users/{userId}/
: Update a user by ID.
To update a user by ID, send a PATCH request to http://localhost:8000/api/users/{userId}
with the following JSON payload:
{
"first_name": "Jane",
"last_name": "Doe",
"address": "321 Fake St",
"activated": true
}
DELETE /api/users/{userId}/
: Delete a user by ID.
To delete a user by ID, send a DELETE request to http://localhost:8000/api/users/{userId}
.
To run the Unit Tests, from the root of the repo run
$ pytest
This will spin up a test database in SQLite test_db.db
, run the tests and then tear down the database.
You can use pytest -v
for verbose output and pytest -s
to disable output capture for better debugging.