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 Querying the Movie Database

Hi could you please help me with this code. I am struggling to print the movies in alphabetical order.

I THINK MY ERROR IS IN MY FIRST LINE(LINE 23) BUT I CAN'T SEEM TO FIND THE PROBLEM.

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)

romance_movies = session.query(Movie).filter_by(genre=="Romance")
for movie in romance_movies:
    print(movie)

all_movies = session.query(Movie).order_by(movie.movie_title=="Alphabetical Order")
for movie in all_movies:
    print(movie)

1 Answer

Chris Freeman
MOD
Chris Freeman
Treehouse Moderator 68,423 Points

Hey Danielle Murray, you are very close.

The order_by argument does not take a value assignment. The sort order is assumed to be alphabetical. The “Movie” reference needs to be capitalized. So the argument is Movie.movie_title

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

Thank you so much Chris Freeman that was very helpful.