SQLAlchemy for Python, 'Query' object has no attribute 'fetchone'

Question

I'm working on a database-centric project with a fellow programmer. We have the following code for retrieving information from our database:

# create connection to database
engine = create_engine(URL(**DATABASE))
Session = sessionmaker(bind=engine)
session = Session()
# construct query
query = session.query(MediaText.line_number, MediaText.start_time_stamp, MediaText.end_time_stamp).\
    filter(MediaText.oclc_id == oclcId)

# get info about first line to snapshot
line_to_snapshot = query.fetchone()

When I try to run the code, I get the following error:

AttributeError: 'Query' object has no attribute 'fetchone'

What's confusing is that my partner can run the code just fine. We're both running Python 3.4 and have version 1.0.9 of the SQLAlchemy library on our systems. Does anyone know what could be going wrong here?

wilfo · Accepted Answer · 2016-02-08 09:02:35Z

3

From SQLALchemy's Query API and from what I know (Python 2.7 and sqlalchemy 1.0.4) fetchone is not part of the Query API, although one is.

How about changing it to:

line_to_snapshot = query.one() and see if it works?

answered Feb 8, 2016 at 9:02

wilfo

7151 gold badge6 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLAlchemy for Python, 'Query' object has no attribute 'fetchone'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related