Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Build APIs with Python: FastAPI Edition
Welcome!
Welcome onboard!
Introduction to the project
Introducing the PyJobs API
Setting up the environment and project structure (8:04)
Building an API with FastAPI
Implementing API endpoints (14:18)
Capturing and validating URL query and path parameters; setting response status codes (18:34)
Modelling validation schemas with Pydantic (22:45)
Hooking the Pydantic models with the endpoints to validate request and response payloads (11:27)
Fine-tuning Pydantic schemas for OpenAPI compatibility (14:21)
Adding the data layer with SQLAlchemy
What is SQLAlchemy? (6:03)
Introducing the database design (3:03)
Setting up SQLAlchemy and Alembic (5:12)
Creating SQLAlchemy's base declarative class (6:36)
Modelling the database with SQLAlchemy (20:07)
Running migrations with Alembic (14:10)
Inserting records with SQLAlchemy (11:25)
Running your first query with SQLAlchemy (3:25)
Adding Dataclass super powers to SQLAlchemy models (3:52)
Running WHERE and COUNT queries with SQLAlchemy (5:12)
Running complex queries with SQLAlchemy (2:59)
Updating records with SQLAlchemy (3:13)
Deleting records with SQLAlchemy (1:24)
Avoid glitches with SQLite (2:54)
SQLAlchemy assignment (1:30)
Integrating SQLAlchemy with the API layer
Adding dataclass support to all models (4:56)
Creating a SQLAlchemy session factory object (0:28)
Listing and paginating skills (7:19)
Creating a job listing (12:17)
Listing and paginating jobs (11:11)
Testing with the Swagger UI and tracing errors in FastAPI
Introduction (0:43)
Testing and debugging POST /jobs (11:53)
Testing and debugging GET /jobs (3:04)
Updating jobs
Implementing the PUT /jobs/{job_id} endpoint (5:43)
Testing and debugging update jobs (3:21)
Adding the Candidates API
Introduction (0:42)
Adding the register candidate endpoint (6:18)
Deleting candidates (0:59)
Testing, debugging, and fixing the register and delete candidate endpoints (7:09)
Uploading a CV (4:21)
Downloading CVs (1:13)
Testing and debugging the CV endpoints (2:43)
Wrapping up (1:43)
Teach online with
Modelling the database with SQLAlchemy
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock