Intro

Tools used

Installing SQLAlchemy

Configuring SQLAlchemy

Creating Base Models

Creating a Model

One to One relationships

One to Many relationships

Many to Many relationships

Creating & Seeding the database

Querying the database

Inserting records into the database

Updating records from the database

Deleting records from the database

Eager loading related models

Database transactions

Introduction

Connecting to the database

Create Database models

Create database tables

Create and persist objects

Select statements

Using sessions to select

selects with join

Update records

Delete records

Conclusion

Intro

What Is SQLAlchemy?

Installing SQLAlchemy

Creating Database Engine

Different Types Of Databases

SQLite

Database Client

Creating a Table

Wrap Up

Outro

Introduction

Creating a Schema

Creating the database tables

Creating data in a database table (Creating data)

Reading from the database (Reading Data)

Limiting Number of Results

Filtering queries

Updating Data

Deleting Data

Ordering results of a query

Wrapping Up

Basics of Sql Alchemy

Commit to Persisted Changes

Remove the Database

Delete Statement

Connect these Two Tables with a Foreign Key

Outer Joint

Declarative Base

Querying Updating and Deleting

Joins

Use Case

Intro

SQLAlchemy Session

Createing a new User

Creating Database Engine

Reading Data

Updating Data

Deleting Data

Wrap Up

Outro

Configure Our Python Interpreter

Timestamp Model

Create a Relationship

Define the Concretion

Create the Relationships

Querying the Database

Join to the Drives Table

Outer Join

Sum

Recap

Intro

SQLAlchemy 2.0-style models with Mapped and mapped_column

Testing model refactor

Creating re-usable types with Annotated

Intro

Explanation

Start code

Class setup

Database viewer

See the relationship

Query example

Relationship to itself

Avoid circular dependency

Association table

Outro

Type Hint

Create a Session

Creating Posts

Queries

Add a Filter

Create Engine

Create a session in SQLAlchemy

How to create a table in SQLAlchemy?

How to define fields in SQLAlchemy?

Migrating the table

Execute the code

Intro

Functional Approach

Object-Oriented Approach

Relationships

Oso

Relationships part 2

Outro

Intro

Sqlite Connection

Dot Close Method

Chapter Two Table Metadata

Declarative Style

Execute Method

Data Types

Operators

Full Join

Extract the User Object from a Row

ORM Explained: SQLAlchemy Fundamentals

What is an ORM?

Why Choose SQLAlchemy?

Step 1: The Engine

Step 2: Defining Models

Step 3: Creating Tables

Step 4: The Session

Operation: CREATE

Operation: READ (Querying)

Recap

Outro

Intro

Setup

Non-Mapped method

Example

Backwards Relationship Access

Mapped Method

Self Relationship

Issue

Association Table

Outro

Intro

Setup

select

selectin

joined

raise

subquery

write_only

dynamic

Wrapping up

Outro

Create an instance of the table class

Running the program

How to add multiple records to a table in SQLAlchemy?

Conclusion

What is SQLAlchemy ORM

Creating Tables

Inserting a single

Inserting multiple

Select Queries

Update Records

Delete Records

Intro

Explanation

Setup code

Student and Course Example

Database client

Back to the example

Patients and Doctors Example

Self Many to Many Example

Outro

Intro

What is a Database

Primary & Foreign Keys

Database Relationships

Designing and Drawing Database using a Software

Installing SQLAlchemy

Social Media Users Table

Creating SQLite Database

Browsing Database

Database Commit

Social Media Posts Table

Populating Database with Data

Getting Started with Queries

More Queries

Social Media Likes Table

How a Post Like in Social Media Works

Counting Post Likes

Join Query