Why are session methods unbound in sqlalchemy using sqlite?

Question

Code replicating the error:

from sqlalchemy import create_engine, Table, Column, Integer
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class Message(Base):
    __tablename__ = 'messages'

    id = Column(Integer, primary_key=True)
    message = Column(Integer)


engine = create_engine('sqlite:///' + filename_of_your_choice)
session = sessionmaker(bind=engine)

newmessage = Message()
newmessage.message = "Hello"

messages = session.query(Message).all()

Running this code yields:

Traceback (most recent call last):
  File "C:/aaron/test.py", line 20, in <module>
    session.commit()
TypeError: unbound method commit() must be called with Session instance as first argument (got nothing instead)

I'm 95% positive that the filename isn't the issue as I can connect to it from the shell

any ideas?

Ignacio Vazquez-Abrams · Accepted Answer · 2012-04-22T00:59:49.700

12

The return value from sessionmaker() is a class. You need to instantiate it before using methods on the instance.

edited Apr 22 '12 at 00:59

answered Jul 11 '10 at 04:36

Ignacio Vazquez-Abrams

776,304
153
1,341
1,358

@Jay: Same way I instantiate any class in Python. – Ignacio Vazquez-Abrams Apr 22 '12 at 00:39
@ignacio - hey, thanks for coming back. Please forgive my ignorance, but I am trying to fix the same error, but can't see from this answer *how* to fix, just what I need to do! – Jay Gattuso Apr 22 '12 at 00:42
1

@Jay: It's a class. You call it. `sc = SomeClass()` – Ignacio Vazquez-Abrams Apr 22 '12 at 00:58

Why are session methods unbound in sqlalchemy using sqlite?

1 Answers1

Linked