Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Relational Databases With SQLAlchemy

Well done!

You have completed Relational Databases With SQLAlchemy!

Sign up for Treehouse Back to Library

Cascade

9:11 with Megan Amendola

Learn how to have more control over your relational database with cascade.

SQLAlchemy Docs

Relational DB Ideas -

Create a small app to complete all CRUD actions

  • E-Commerce: Table for customers and a table for purchases - customer id is the foreign key
  • Food: Table for brands and a table for products - brand id is the foreign key
  • Doggy Daycare: Table for pet parents and a table for pets - parent id is the foreign key

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    There's this cascade option that has this all, delete, and delete-orphan. 0:00
    If I scroll down a bit, I see there's a little more information about cascades. 0:06
    So let's traverse to this new land of knowledge. 0:11
    Okay, I'm going to give you the cliff notes version of what's on the page here. 0:15
    So take some time to read through the details if you want more specifics. 0:20
    Essentially, this option tells SQL Alchemy what to do with the children when 0:24
    a parent is deleted. 0:29

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up