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 trialDanielle Murray
Python Development Techdegree Graduate 7,755 PointsHi 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.
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
Treehouse Moderator 68,441 PointsHey 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!!!
Danielle Murray
Python Development Techdegree Graduate 7,755 PointsDanielle Murray
Python Development Techdegree Graduate 7,755 PointsThank you so much Chris Freeman that was very helpful.