Sqlalchemy Movie challenge

Question

HI there Any idea why I don't pass this challenge, I get the error message: 'You should have a variable called new_movie that creates an instance of Movie().'

Thanks!

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)

    def __repr__(self):
        return f'<User(movie_title={self.movie_title}, genre={self.genre})>'


if __name__ == "__main__":
    Base.metadata.create_all(engine)

    new_movie = Movie(movie_title = "Lord of the rings", genre = "Fantasy")
    session.add(new_movie)
    session.commit()

Answer 1 · 2023-01-23T22:12:15Z

January 23, 2023 10:12pm

The challenge seems to be a stickler for "best practice" syntax, and apparently doesn't like the spaces around the equal signs where named arguments are being passed.

Also, it looks like you did a few extra things like adding a "__repr__" method to the Movie, a call to a create_all method, and adding a test for "__main__". As a general rule to avoid confusing the challenge checker, do only what the instructions ask for.

Answer 2 · 2023-01-23T15:24:23Z

January 23, 2023 3:24pm

HI Steven For sure, it's coding Challenge number 2: https://teamtreehouse.com/library/sqlalchemy-basics/introduction-to-sqlalchemy/movie-database-continued Lg Gabriel

Welcome to the Treehouse Community

Looking to learn something new?

Gabriel Guerra

Gabriel Guerra

Sqlalchemy Movie challenge

Steven Parker

Steven Parker

2 Answers

Steven Parker

Steven Parker

Gabriel Guerra

Gabriel Guerra