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

Shadrach Anwhere
seal-mask
.a{fill-rule:evenodd;}techdegree
Shadrach Anwhere
Data Analysis Techdegree Student 4,272 Points
Posted by Shadrach Anwhere
.a{fill-rule:evenodd;}techdegree
Shadrach Anwhere
Data Analysis Techdegree Student 4,272 Points

Great! Now you can create a movie to add to your database. Use a variable named new_movie. Create a Movie() with whateve

i have done what is expected but im still getting an error

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)

1 Answer

Steven Parker
Steven Parker
243,160 Points
Steven Parker
Steven Parker
243,160 Points

It doesn't look like the task 2 code has been added yet.

The complete task 2 instructions are: "Great! Now you can create a movie to add to your database. Use a variable named new_movie. Create a Movie() with whatever movie_title and genre you want. Then add your movie to session."

But in the code above, I'm not seeing a variable named "new_movie" being created and then assigned using "Movie()", nor any code to add it to "session".