This SQLAlchemy ORM crash course shows you how to use SQLAlchemy from beginning to end. In this course we cover setting up SQLAlchemy, creating models, relationships, querying the database, creating updating and deleting records from the database, eager loading as well as database transactions.
Chapters:
00:00:00 Intro
00:00:32 Tools used
00:01:09 Installing SQLAlchemy
00:02:08 Configuring SQLAlchemy
00:04:26 Creating Base Models
00:07:31 Creating a Model
00:11:03 One to One relationships
00:16:04 One to Many relationships
00:20:26 Many to Many relationships
00:26:00 Creating & Seeding the database
00:27:54 Querying the database
00:39:54 Inserting records into the database
00:45:40 Updating records from the database
00:49:35 Deleting records from the database
00:50:59 Eager loading related models
00:56:21 Database transactions
Code:
https://github.com/demoskp/sqlalchemy-crash-course
Personal website:
http://www.petsas.consulting
