SQLAlchemy ORM crash course - Learn SQLAlchemy in 1 hour

SQLAlchemy ORM crash course - Learn SQLAlchemy in 1 hour

Demos Petsas

1 год назад

18,912 Просмотров

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

Тэги:

#sqlalchemy_orm #sqlalchemy #one_to_one_sqlalchemy #one_to_many_sqlalchemy #many_to_many_sqlalchemy #sqlalchemy_eager_loading #sqlalchemy_n+1 #sqlalchemy_database_transactions #sqlalchemy_update #sqlalchemy_add #sqlalchemy_query #sqlalchemy_object_relational_mapper #sqlalchemy_join #sqlalchemy_contains_eager #sqlalchemy_joinedload #sqlalchemy_subqueryload
Ссылки и html тэги не поддерживаются


Комментарии:

Georgiy Veter
Georgiy Veter - 12.10.2023 20:00

Sqlalchemy orm is too slow, it's better to use sqlalchemy core

Ответить
KwangOh Moon
KwangOh Moon - 03.10.2023 16:05

The best tutorial of sqlAlchemy. Perfect combination of nicely organized content, clear voice and detail explanation. Thanks!

Ответить
TASC Solutions
TASC Solutions - 24.09.2023 23:41

Nice tutorial. I like that you kept the code and files to a minimum while still showing core concepts. I am newish to OOP and SQLAlchemy 2.0 so it helps with the learning curve.

Ответить
ms394
ms394 - 15.09.2023 08:17

Hi @Demos.. How can we add ondelete constraint after we have already created the table, without having to delete the tables and the records.

Ответить
ms394
ms394 - 10.09.2023 14:56

Top quality content❤❤!! Can you also make a detailed video on flask-sqlalchemy... or is it same

Ответить
Man Vs man
Man Vs man - 30.08.2023 02:00

It's really good
Please guide me to next step what should I learn after this course

Ответить
Roman Tretyakov
Roman Tretyakov - 21.08.2023 03:41

If I could I would give 100 likes on this video

Ответить
Minh Phuc Dong
Minh Phuc Dong - 17.08.2023 18:41

this is very easy to understand, you made it easy to be precise, please keep up the good work.

Ответить
Chris Keo
Chris Keo - 10.08.2023 14:32

What we don't need is another intro to Sqlalchemy

What we do need is a tutorial on how to write advanced Sqlalchemy queries using window functions (rank, dense, row number), etc.

Ответить
Hussain Ali
Hussain Ali - 22.07.2023 18:14

Nice tutorial! That really helped me to understand db queries 👍

Ответить