Python SQLAlchemy Basics Working with SQLAlchemy Analyzing the Movie Database

Jonathan Ramirez
Jonathan Ramirez
5,002 Points

Am I missing something??

This is my code, can anybody help?

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)

# Write your code below
the_movies = session.query(Movie).filter(Movie.movie_title).like('%The%')

1 Answer

Chris Freeman
MOD
Chris Freeman
Treehouse Moderator 65,310 Points

Hey Jonathan Ramirez, you are very close. like is an method of the Movie.movie_title attribute. It is not method of the query results.

:point_right: move like inside the parens and attach directly to movie_title

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