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 Working with SQLAlchemy Analyzing the Movie Database

Posted by Danielle Murray
.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

I think i'm missing something small and i can't pick it up. I'd really appreciate help on this one.

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)

the_movies = session.query(Movie).filter('Movie.movie_title').like('%The%')

1 Answer

Chris Freeman
MOD
Chris Freeman
Treehouse Moderator 68,457 Points
Chris Freeman
Chris Freeman
Treehouse Moderator 68,457 Points

The Movie.movie_title isn’t a string. It’s a model attribute reference. The like(“%The%”) is a method directly attached to the attribute reference with a dot. The add a count() method to the end of that.

All together it should pass.

Post back if you need more help. Good luck!!!