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

SQLAlchemy Basics

Well done!

You have completed SQLAlchemy Basics!

Sign up for Treehouse Back to Library

Querying

15:18 with Megan Amendola

Access items in the database by creating queries.

Slice Review

Slice Documentation

Querying
all(), first(), one(), one_or_none()

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

    We're going to work in the shell again to see the results of our queries right away. 0:00
    If you closed your terminal, 0:00
    you probability need to activate your environment again. 0:01
    I'm on a Mac, so I'll type the source./env/bin/activate command. 0:05
    And you can see I now have this end here that tells me my environment is activated. 0:11
    Now, queries are how we access the entries we want in our database. 0:17
    We'll be using Python with SQLAlchemy, which is then converted into a SQL 0:22
    statement to grab the correct entries and return them to us. 0:26

    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