GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — GitHub - wpcodevo/python_fastapi: This article will teach you how to create a CRUD RESTful API with Python, FastAPI, SQLAlchemy ORM, Pydantic, Alembic, PostgreSQL, and Docker-compose to perform the basic Create/Read/Update/Delete operations against a database.

BranchesTags
Open more actions menu

Latest commit

 

History

23 Commits
23 Commits

Folders and files

NameName
Last commit message
Last commit date
alembic
alembic
 
 
app
app
 
 
.env
.env
 
 
.gitignore
.gitignore
 
 
Makefile
Makefile
 
 
alembic.ini
alembic.ini
 
 
docker-compose.yml
docker-compose.yml
 
 
readMe.md
readMe.md
 
 
requirements.txt
requirements.txt
 
 

Repository files navigation

RESTful API with Python, FastAPI, Pydantic, SQLAlchemy and Docker

1. RESTful API with Python,SQLAlchemy, & FastAPI: Access and Refresh Tokens

In this article, you'll learn how to secure a FastAPI app by implementing access and refresh token functionalities using JSON Web Tokens (JWTs). We'll use the FastAPI JWT Auth package to sign, encode and decode the access and refresh JWT tokens.

RESTful API with Python,SQLAlchemy, & FastAPI: Access and Refresh Tokens

Topics Covered

  • Python FastAPI JWT Authentication Overview
  • How to Setup FastAPI with PostgreSQL
    • Setup FastAPI
    • Initialize a Simple FastAPI Server
  • Setting up Environment Variables in FastAPI
  • Connect to the PostgreSQL Docker Container
  • Installing the UUID OSSP PostgreSQL Extension
  • Create Database Models with SQLAlchemy in FastAPI
  • Creating Schemas with Pydantic in FastAPI
  • Password Management with Bcrypt
  • Configure the FastAPI JWT Auth Extension
  • Creating the Authentication Controllers
    • User Registration Controller
    • User Sign-in Controller
    • Refresh Access Token Controller
    • Logout User Controller
  • How to add Protected Routes
  • Create a User Controller
  • Adding the Routes to FastAPI Middleware Pipeline
  • Database Migration with Alembic
  • Testing the FastAPI JSON Web Token API

Read the entire article here: https://codevoweb.com/restful-api-with-python-fastapi-access-and-refresh-tokens

2. RESTful API with Python, SQLAlchemy, & FastAPI: Send HTML Emails

In this article, you'll learn how to send HTML emails with Python, FastAPI, SQLAlchemy, PostgreSQL, Jinja2, and Docker-compose. Also, you'll learn how to dynamically generate HTML templates with the Jinja2 package.

RESTful API with Python, SQLAlchemy, & FastAPI: Send HTML Emails

Topics Covered

  • Send HTML Email with jinja2 and FastAPI Overview
  • Creating an SMTP Provider Account
  • Validating the Environment Variables with Pydantic
  • Create a Database Model with Sqlalchemy
  • Creating the HTML Email Templates with Jinja2
  • Set up SMTP Email Sender
  • How to Send the HTML Email
  • Update the SignUp Path Operation Function
  • Create a Controller to Verify the Code

Read the entire article here: https://codevoweb.com/restful-api-with-python-fastapi-send-html-emails

3. CRUD RESTful API Server with Python, SQLAlchemy, FastAPI, and PostgreSQL

This article will teach you how to create a CRUD RESTful API with Python, FastAPI, SQLAlchemy ORM, Pydantic, Alembic, PostgreSQL, and Docker-compose to perform the basic Create/Read/Update/Delete operations against a database.

CRUD RESTful API Server with Python, SQLAlchemy, FastAPI, and PostgreSQL

Topics Covered

  • Python, FastAPI, PostgreSQL, SQLAlchemy CRUD API Overview
  • Setting up FastAPI and PostgreSQL
    • Building the FastAPI Server
    • Starting the FastAPI Server
  • Setting up Environment Variables in FastAPI
  • Connecting to the PostgreSQL Server
  • Installing the UUID OSSP PostgreSQL Plugin
  • How to Create Database Models with SQLAlchemy
  • Creating Validation Schemas with Pydantic
  • Creating the FastAPI Route Handlers
    • Fetch All Posts Handler
    • Create New Post Handler
    • Update Post Handler
    • Get a Single Post Handler
    • Remove Post Handler
  • Add the Routes to the FastAPI Middleware Stack

Read the entire article here: https://codevoweb.com/crud-restful-api-server-with-python-fastapi-and-postgresql

About

This article will teach you how to create a CRUD RESTful API with Python, FastAPI, SQLAlchemy ORM, Pydantic, Alembic, PostgreSQL, and Docker-compose to perform the basic Create/Read/Update/Delete operations against a database.

codevoweb.com/crud-restful-api-server-with-python-fastapi-and-postgresql

Topics

fastapifastapi-crudfastapi-sqlalchemypostgresqlpydanticpydantic-modelspythonrest-apirestfulrestful-apisqlalchemysqlalchemy-ormsqlalchemy-pythonuvicorn

Resources

Readme
Activity

Stars

76 stars

Watchers

2 watching

Forks

25 forks
Report repository

Releases

Packages

Used by

Contributors

Languages

You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.