Skip to main content

NOTICE: On Friday Nov 6, Workspaces will be temporarily unavailable for maintenance.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Join the Treehouse affiliate program and earn 25% recurring commission! 🤑

  • Treehouse Logo
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
    • All Courses
    • Tracks
    • AI Bootcamp
    • College Credit
    • Techdegree Bootcamps
    • Front End Development
    • Full Stack JavaScript
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
    • Explore
    • Career Toolbox
    • Free Treehouse Near Me
    • Affiliates
    • Blog
    • Support
    • About
    • Learn
    • Beginner's Guide to Coding
    • Data Analysis with SQL & Python
    • Front-End Web Development
    • Python Programming Basics
    • Techdegree Bootcamp Overview
    • UX Design Fundamentals
    • AI Tools for Beginners
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks AI Bootcamp College Credit
  • Techdegree Bootcamps Front End Web Development Full Stack JavaScript
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Explore Career Toolbox Free Treehouse Near Me Affiliates Blog Support About
    Learn Beginner's Guide to Coding Data Analysis with SQL & Python Front-End Web Development Python Programming Basics Techdegree Bootcamp Overview UX Design Fundamentals AI Tools for Beginners
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
Loading banner... Start your free trial at Treehouse
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
      • • Vibe Coding
  • David Hultén
    David Hultén
    8,424 Points

    The ValueError message is not showing up from the clean_id() function even after being called

    Posted March 24, 2026 2:15pm by David Hultén
    David Hultén
    8,424 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Search for a Book

    1 Answer

  • Luis Gutierrez
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Luis Gutierrez
    Python Development Techdegree Graduate 8,323 Points

    clean_id()

    Posted September 4, 2025 3:56am by Luis Gutierrez
    .a{fill-rule:evenodd;}techdegree seal-36
    Luis Gutierrez
    Python Development Techdegree Graduate 8,323 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Search for a Book

    1 Answer

  • Luis Gutierrez
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Luis Gutierrez
    Python Development Techdegree Graduate 8,323 Points

    I get a nameerror name 'book' is not defined. under the add_csv() function??

    Posted August 13, 2025 3:23am by Luis Gutierrez
    .a{fill-rule:evenodd;}techdegree seal-36
    Luis Gutierrez
    Python Development Techdegree Graduate 8,323 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Cleaning Data

    2 Answers

  • Luis Gutierrez
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Luis Gutierrez
    Python Development Techdegree Graduate 8,323 Points

    library hint in vscode

    Posted August 11, 2025 2:31am by Luis Gutierrez
    .a{fill-rule:evenodd;}techdegree seal-36
    Luis Gutierrez
    Python Development Techdegree Graduate 8,323 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Import Book CSV

    1 Answer

  • Madison Butler
    Madison Butler
    17,773 Points

    Not sure whats going on...

    Posted December 6, 2024 6:01pm by Madison Butler
    Madison Butler
    17,773 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Analyzing the Movie Database

    2 Answers

  • Kevin Martinez
    Kevin Martinez
    7,711 Points

    Uploading from Pycharm to GitHub

    Posted December 30, 2023 10:55pm by Kevin Martinez
    Kevin Martinez
    7,711 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Project Overview

    1 Answer

  • Joshua Faisal
    Joshua Faisal
    4,493 Points

    Its not giving me an error message when I enter in the wrong date.

    Posted July 23, 2023 7:13pm by Joshua Faisal
    Joshua Faisal
    4,493 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Update and Delete Books

    1 Answer

  • Kiefer H
    Kiefer H
    5,665 Points

    Can we use match instead of if-else for Menu Options?

    Posted November 27, 2022 10:19pm by Kiefer H
    Kiefer H
    5,665 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Update and Delete Books

    1 Answer

  • Sean Timmons
    seal-mask
    .a{fill-rule:evenodd;}techdegree
    Sean Timmons
    Data Analysis Techdegree Student 4,138 Points

    App returns memory location for Book Object, instead of string containing book info.

    Posted July 1, 2022 9:19pm by Sean Timmons
    .a{fill-rule:evenodd;}techdegree
    Sean Timmons
    Data Analysis Techdegree Student 4,138 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Cleaning Data

    2 Answers

  • Andras Andras
    Andras Andras
    8,230 Points

    App returns strange list of items.

    Posted February 26, 2022 4:38pm by Andras Andras
    Andras Andras
    8,230 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Cleaning Data

    1 Answer

  • Anthony Dills
    seal-mask
    .a{fill-rule:evenodd;}techdegree
    Anthony Dills
    Python Development Techdegree Student 5,336 Points

    I have an issue in my code when trying to input a published date for a new book entry

    Posted February 22, 2022 1:37am by Anthony Dills
    .a{fill-rule:evenodd;}techdegree
    Anthony Dills
    Python Development Techdegree Student 5,336 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Create and Read Books

    1 Answer

  • S M Tasfiqul Asif
    S M Tasfiqul Asif
    11,514 Points

    Getting AttributeError: 'Query' object has no attribute 'title https://github.com/Tasfiq23/library_database.git

    Posted December 2, 2021 12:43pm by S M Tasfiqul Asif
    S M Tasfiqul Asif
    11,514 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Search for a Book

    3 Answers

  • Medhanit Endale
    Medhanit Endale
    6,419 Points

    Challenge Task 1 of 1 The movie theater wants to know how many movies they have in their database

    Posted November 12, 2021 4:46am by Medhanit Endale
    Medhanit Endale
    6,419 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Analyzing the Movie Database

    1 Answer

  • Neana Del Rio
    Neana Del Rio
    4,770 Points

    Challenge Task 1 of 1 The movie theater wants to know how many movies they have in their database

    Posted November 8, 2021 1:29am by Neana Del Rio
    Neana Del Rio
    4,770 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Analyzing the Movie Database

    2 Answers

  • amandae
    amandae
    15,727 Points

    For further learning...

    Posted September 2, 2021 7:55pm by amandae
    amandae
    15,727 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Analyze Books

    1 Answer

  • amandae
    amandae
    15,727 Points

    While True clause causes an infinite loop.

    Posted August 31, 2021 7:28pm by amandae
    amandae
    15,727 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Setting Up Our App

    3 Answers

  • Andy McDonald
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points

    How to use like() method?

    Posted August 20, 2021 5:34am by Andy McDonald
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Analyzing the Movie Database

    1 Answer

  • Andy McDonald
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points

    Why do I query the class name?

    Posted August 19, 2021 6:08am by Andy McDonald
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Analyze Books

    1 Answer

  • Andy McDonald
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points

    Why is she using RegEx? Why wouldnt she just use strptime?

    Posted August 15, 2021 5:10am by Andy McDonald
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Import Book CSV

    1 Answer

  • Andy McDonald
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points

    How to turn a query object into a dictionary?

    Posted August 4, 2021 5:27am by Andy McDonald
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Creating Our Book Database

    1 Answer

  • Andy McDonald
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points

    How to identify empty query object when empty query is truthy?

    Posted August 1, 2021 6:09am by Andy McDonald
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Creating Our Book Database

    1 Answer

  • Andy McDonald
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points

    Using variable as attribute

    Posted August 1, 2021 5:29am by Andy McDonald
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Creating Our Book Database

    1 Answer

  • Andy McDonald
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points

    Why am I getting 2 different results with a query depending on whether I run it as a script or in the consel?

    Posted July 31, 2021 6:25am by Andy McDonald
    .a{fill-rule:evenodd;}techdegree seal-36
    Andy McDonald
    Python Development Techdegree Graduate 13,801 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Creating Our Book Database

    1 Answer

  • Chris Hummel
    Chris Hummel
    13,960 Points

    Is there a reason we don't import the entire sqlalchemy base?

    Posted July 27, 2021 7:41pm by Chris Hummel
    Chris Hummel
    13,960 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Creating Our Book Database

    2 Answers

  • Jonathan Grieve
    Jonathan Grieve
    91,254 Points

    TypeError: str is not callable

    Posted July 23, 2021 8:49am by Jonathan Grieve
    Jonathan Grieve
    91,254 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Create and Read Books

    1 Answer

  • Jonathan Ramirez
    Jonathan Ramirez
    5,002 Points

    Am I missing something??

    Posted June 10, 2021 10:31am by Jonathan Ramirez
    Jonathan Ramirez
    5,002 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Analyzing the Movie Database

    1 Answer

  • Danielle Murray
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Danielle Murray
    Python Development Techdegree Graduate 7,755 Points

    Hi Please can you help me with this task. I think my code is correct for this one but

    Posted June 9, 2021 1:22am by Danielle Murray
    .a{fill-rule:evenodd;}techdegree seal-36
    Danielle Murray
    Python Development Techdegree Graduate 7,755 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Analyzing the Movie Database

    1 Answer

  • Ozzy Robledo
    Ozzy Robledo
    6,288 Points

    clean_date() function

    Posted June 7, 2021 8:59am by Ozzy Robledo
    Ozzy Robledo
    6,288 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Cleaning Data

    2 Answers

  • Hanwen Zhang
    Hanwen Zhang
    20,084 Points

    What does app_running mean in this video? Can I just name it any other name or it is a built-in function?

    Posted April 20, 2021 11:09pm by Hanwen Zhang
    Hanwen Zhang
    20,084 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Setting Up Our App

    1 Answer

  • Callum Anderson
    seal-mask
    .a{fill-rule:evenodd;}techdegree
    Callum Anderson
    Data Analysis Techdegree Student 10,200 Points

    Ignored acception in console, continues to loop - SQLAlchemy/Pyhton

    Posted March 11, 2021 8:48am by Callum Anderson
    .a{fill-rule:evenodd;}techdegree
    Callum Anderson
    Data Analysis Techdegree Student 10,200 Points
    • Python
    • SQLAlchemy Basics
    • Working with SQLAlchemy
    • Create and Read Books

    2 Answers

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
SEE ALL

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
SEE ALL

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
SEE ALL

About Us

  • About
  • Blog
  • Community
  • Stories
  • Contact
  • Gift Card

Explore

  • Plans
  • Affiliates
  • Perks
  • Shop
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses

Treehouse is an online technology education platform founded in 2011. Treehouse offers more than 700 self-paced, video-based courses in web development, programming, data analysis, design, and AI, plus two project-based bootcamp programs in Front End Web Development and Full Stack JavaScript. Individual Treehouse plans start at $25 per month and include a 7-day free trial. Treehouse serves individual learners, businesses, schools, and public libraries. Cardholders at participating U.S. public libraries can use Treehouse for free. Select Treehouse courses, offered with University Pathways International, are recommended for college credit by ACE and NCCRS. Treehouse learners earn digital certificates for completed Tracks.

Terms & Conditions · Privacy · © 2026 Treehouse Island, Inc.
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
  • Discord