SQLAlchemy | One To Many Relationships

SQLAlchemy | One To Many Relationships.
In this video, I walk through how to create one to many relationships between two models using SQLAlchemy. One-to-many relationships are one of the most common database relationships. If you want to learn how to use one-to-many relationships using SQLAlchemy, then this video is a great starting point.
I walk through how to create database tables and the different ways to create a relationship between two models.
I also explain how to configure delete behaviour using cascade.
SOURCE CODE:
github.com/jod35/sqlalchemy_o...
SUBSCRIBE:
ruclips.net/user/SsaliJonathan...
Please donate to my channel:
www.buymeacoffee.com/jod35
GITHUB:
github.com/jod35
TWITTER:
/ jod35_
Timestamps
00:00 Introduction
01:17 Configuring the database
01:17 Creating the data models
04:36 Creating the database tables
12:12 Foreign keys
13:19 Creating a relationship with a backref
14:50 Creating the database tables
16:16 Populating the database
24:06 Querying related objects using backref
27:09 Querying related objects using back_populates
28:37 backref vs back_populates
28:44 Configuring delete behaviour
35:55 Wrapping Up

[@SsaliJonathan]

Here is an updated version with better audio using SQLAlchemy 2.0. You can check it out when done here. Thanks for watching. ruclips.net/video/wvQJzMrKy9E/видео.htmlsi=r0cpXV8dZ1Hf9WYY

[@tomasbenjaminastrada4040]

Thanks! You explained the difference between backred and back_populates very clearly

[@SsaliJonathan]

Thanks for watching.

[@vecroun]

Great video, thank you!

[@braxtonshaffie]

your explanations are really great , good work !

[@SsaliJonathan]

I am really glad it helped

[@user-gh7sh4ip3q]

Thank you so much! Really helped :)

[@nachiket9857]

Many thanks for your tutorials : ) Easily one of the best yt tuts!

[@SsaliJonathan]

Glad it helped

[@emilvulkov]

Very nice demo!

[@SsaliJonathan]

Thanks for watching

[@user-cw7xd6de2l]

thx good video~!! it helps a lot :)

[@Amapramaadhy]

Amazing content!

[@SsaliJonathan]

I am glad my video helped.

[@adamsekyanzi9975]

when i found Jonathan i found a savior big up bro

[@SsaliJonathan]

Thanks for watching man. I am glad I helped.

[@ongayijohnian8787]

Thanks a lot mahn, 💯

[@SsaliJonathan]

Welcome

[@aruncanra2084]

You are awesome. Thank you.

[@SsaliJonathan]

Thanks for watching.

[@bitflop]

Thank you! better than the docs!

[@SsaliJonathan]

Glad it helped

[@aldrickdev]

Great video, I believe what happened towards the end was that you have created multiple of the same user by accident.

[@SsaliJonathan]

Yeah. Thanks for watching

[@andrewvelez7068]

Great content Jonathan, really helpful! Do you have a way to accept donations from the US? I'd love to help you upgrade your microphone!

[@SsaliJonathan]

I really appreciate your support and I am glad my video helped. I would like to discuss this with you via email if you are fine with it.

[@SsaliJonathan]

Please visit
www.buymeacoffee.com/jod35

[@mostafaalayesh2803]

Thank you, I have understood that `backref` is actually the name of a newly created member variable (that holds the related rows from the second table), inside the class specified for the `relationship`, and at the same time, the result of calling `relationship` is also a member variable (which holds the related rows from the first table).
Am I correct?
Thanks for the video
And good luck in the next videos
Subscribed 👌

[@SsaliJonathan]

That’s exactly what it is. How to Access the related table from another table. Thanks for watching

[@Fantasia1013]

hello bro how you have auto complet in vscode for sqlalchemy ?

[@SsaliJonathan]

I have the VSCode extension that allows this to happens

[@SsaliJonathan]

It is called the Python extension. Search it in your extensions and install

[@tabs_spaces]

also instal tabnine extension for smart autocompletion

[@ruoyamwangi]

i dont know what sounds worse, the quality of my earphones or your microphone😬

[@SsaliJonathan]

My microphone. Hadn’t yet figured out audio. Thanks for watching though

[@ruoyamwangi]

@@SsaliJonathan great content,thanks

[@francogutierreztamayo475]

Can't 'backref' have the same name of the table??

[@SsaliJonathan]

It can have the same name. Depends on what you’re trying to do. I always prefer to use a name that really describes the relationship

[@adamgerber7824]

If anyone is getting an error AttributeError: 'Connection' object has no attribute '_instantiate_plugins',
You have to replace conn in engine= create_engine(conn, echo=True) with the actual URI so for example Im using Sqlite3 so for me it would be:
engine = create_engine('sqlite:///databasename.db', echo=True)

[@SsaliJonathan]

same thing. if conn = the db connection string

[@adamgerber7824]

@@SsaliJonathan Thats what i did, but even with setting the URI to conn, and then using "conn" , I was getting this error. Only after using the URI directly did it work