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 Movie Database Continued

Ayjemal Gurbankulyyeva
Ayjemal Gurbankulyyeva
2,290 Points

how is this incorrect

models.py
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
Session=sessionmaker(bind=engine)
session=Session()


engine = create_engine(β€˜sqlite:///movies.db’, echo=False)
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(id=124, movie_title="New Day",genre="mystery")
    session.add(new_movie)
    session.commit()

2 Answers

Chris Freeman
MOD
Chris Freeman
Treehouse Moderator 68,441 Points

Hey Ayjemal Gurbankulyyeva, you appear to have an extra argument.

Remove the id=124 argument and it should pass Task 2.

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

Ayjemal Gurbankulyyeva
Ayjemal Gurbankulyyeva
2,290 Points

Question is:

Now you can create a movie to add to your database. Use a variable named new_movie. Create a Movie() with whatever movie_title and genre you want. Then add your movie to session.