Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Python SQLAlchemy Basics Introduction to SQLAlchemy Movie Database Continued

kindly assist. i keep on getting this msgYou should have a variable called new_movie that creates an instance of Movie()

kindly assist on this challenge my code is failing

models.py
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

engine = create_engine(β€˜sqlite:///movies.db’, echo=False)
Session = sessionmaker(bind=engine)
session = Session()
Base = declarative_base()

class Movie(Base):
    __tablename__ = β€˜movies’

    id = Column(Integer, primary_key=True)
    movie_title = Column(String)
    genre = Column(String)

    def __repr__(self):
        return f'<Movie(movie_title={self.movie_title}, genre={self.genre})>'  

if __name__ = '__main__':
    Base.metadata.create_all(engine)
    new_movie = Movie(movie_title = 'ben', genre = 'ben')
    session.add(new_movie)
    session.commit()
Chris Freeman
Chris Freeman
Treehouse Moderator 68,454 Points

Flagging as feedback since an actual error (assignment in if statement) was ignored and passes the challenge, and a simple style preference was flagged as non-passing code. The Regex for challenge checker needs updating.

1 Answer

Chris Freeman
MOD
Chris Freeman
Treehouse Moderator 68,454 Points

Looks like you have a typo in if __name__ = '__main__':. This should be a comparison == instead of an assignment =. But this isn't what the checker complaining about.

The checker seems to require no spaces surrounding the = sign in the parameter list. Remove those spaces and it will pass Task 2, though it ignores the syntax error.

Post back if you have more issues. Good luck!!

thank you. I managed to complete all the stages of the challenge