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
Jake Williams
2,925 PointsSQLAlchemy movie database challenge
I don't know why this isn't working. Even Gemini was having a hard time. So what am I missing?
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)
if __name__ == '__main__':
Base.metadata.create_all(engine)
new_movie = Movie(movie_title = "LOTR", genre = "Fantasy")
session.add(new_movie)
session.commit()
1 Answer
Laura Coronel
Treehouse TeacherHey Jake Williams! Thanks for your patience on this one. I took a close look at your solution, and your code is actually correct 👍
What’s happening here is that our test for Task 2 is a bit too strict about formatting, so it’s flagging your answer even though the logic is right. That’s on us, and we’ll get it fixed.
In the meantime, there’s a small tweak you can make so it passes right away: remove the spaces around the = when you create your movie. For example:
new_movie = Movie(movie_title="LOTR", genre="Fantasy")
That should satisfy the test as it’s currently written.
Thanks again for sticking with it, you’re definitely on the right track! 🚀