Introduction

Project dependencies

Connecting to the database (core)

Running synchronous functions

Inserting data (using the core)

Select statements (using the core)

Closing a connection

Creating a connection (using the ORM)

Creating an async engine

Creating database tables

Inserting data (using the ORM)

select, insert, delete

Conclusion

Async Example

Creating a User

Create a New User

Async Session

Declarative Base

Want To Execute a Query

Intro

What is Python Discord

Importance of AsyncIO for SQLAlchemy

Demo

Create Async Engine

Conclusion

Attribute access in asynchronous applications

Lazy loading and relationships

Using run_sync

Are there any plans to change the defaults for asynchronous mode to use eager loading?

Intro

SQLAlchemy async - introduction

Why async?

Creating SQLAlchemy async engine

Async Sessions in SQLAlchemy

Async Session in FastAPI Dependency

Using async/await in FastAPI

Implicit transaction example

Simplified request lifecycle

Compare logs

Initial solution

A more real life example

Response time benchmarks

Old benchmarks

What do programmers love the most?

Introduction

Project Setup

Create a Fast API server

simple API doc with SwaggerUi

setup db with Async SQLAlchemy

Creating database models

Creating tables from the model in PostgreSQL

Create, Retrieve, Update, And Delete

Formatting code with black

Create serializers with Pydantic

List all note resources

Create a note resource

Customize the request body on SwaggerUI

Retrieve a note resource

Update a note resource

Delete a note resource

Conclusion

Recap

Install Flash Sql Alchemy

Extensions

Create Our Database

Connect to this Database

Migrate Our Database

Seed the Database

Data Class

Posting Data

Deleting a User

Import async Context Manager

Defining Our Models

Import from Sql Model

Create Engine

Intro

Synchronous code

Code overview

Get_delay function

Create an async main method

Running the code

Conclusion

Project Setup

Difference between Asynchronous Endpoints and Synchronous Endpoints

Test Script

Why Does Synchronous Win

Introduction and fixing database structure

Creating the service class

Handling the CRUD methods

Intro to dependency injection

Create the session dependency

CRUD using Dependency Injection and the service class

Testing the CRUD and fixing errors

Conclusion

Обзор кода Телеграм бота на aiogram 3 с прошлого видео

Middleware слои в aiogram 3

Работа с базой данных. Установка sqlalchemy, asyncpg и aiosqlite

Создание / описание моделей (таблиц) в sqlalchemy

Создание асинхронного engine и менеджера сессий sqlalchemy

Передача сессий orm sqlalchemy через middleware слой в хендлер aiogram бота

Добавление товара в таблицу базы данных

Удаление товара из таблицы

Отправка изображений ботом

Инлайн клавиатуры и кнопки в aiogram 3

Событие Callback Query

Изменение товара в БД. Модифицируем FSM на добавление/изменение товара

Установка PostgreSQL сервера на ПК

Создание базы данных в PostgreSQL и создание нового пользователя

Подключение бота на работу с PostgreSQL

Финальные тесты

Setting Up the Connection

Sql Alchemy

What Is Sql Alchemy

Create a Session

Performing Crud Operations

The Create Operation

Create a Fast Api Endpoint

Implement the Read Operation

The Update Operation

Deleting the User

Introduction

Setting up the environment

Connecting to the database

Testing database connection

Define database tables

The metadata object

Create tables in the database

Insert statements

select statements

select-where

Update statements

delete statements

Conclusion

Intro — what we’ll build

Project setup & dependencies

Create fastAPI endpoint

Database models with SQLAlchemy

Pydantic Models

CRUD endpoints — Create / Read / Update / Delete

Testing Rest API's

Update a User

Final API Test and Check