SQLA One To Many Relationship (Painters Painting)

Published: 30 October 2023
on channel: Thomas Blum

In this video we look at SQLAlchemy (SQLA) code to to define a simple two-table database that demonstrates a One-to-Many relationship between two entities. The example will have two entities: Painters and Paintings. Since

A Painter creates MANY Paintings
A Painting is made by ONE Painter

The relationship is a ONE-To-MANY relationship realized by having a Foreign Key in the Painting table which establishes which Painter made it. SQLA also allows us to express in code the other direction. So we denote in the Painter class that it has a relationship to the Painting entity.

We inset some data into each table and query each table individually.

Watch video SQLA One To Many Relationship (Painters Painting) online without registration, duration hours minute second in high quality. This video was added by user Thomas Blum 30 October 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 48 once and liked it 1 people.