CODEWITHSUNDEEP
pythonsqlalchemy
Lucas Kauffman
Lucas Kauffman

Reputation: 6891

SQLAlchemy: get the object with the most recent date

How do I query a table for the object with the most recent table?

I've got a table which holds

class Ticker(Base):
    updated = Column('updated', DATETIME, index=False, nullable=False,primary_key=True)
    high = Column('high', FLOAT, index=False, nullable=False)

I'm trying to find out how I can get the object with the most recent updated field? Currently I'm doing the following:

maxdate = db_session.query(func.max(Ticker.updated)).first()[0]
Ticker.query.filter(Ticker.updated == maxdate).first()

I was wondering if there is a more efficient/shorter way to do this?

Upvotes: 15

Views: 24882

Answers (3)

MathKid
MathKid

Reputation: 2122

Same as this with a small variation in syntax:

session.query(Ticker).order_by(Ticker.updated.desc()).limit(1)

Upvotes: 1

MCH
MCH

Reputation: 1032

for version 1.2+: 

session.query(Ticker).order_by(desc('updated')).first()

desc

Upvotes: 22

Bibhas Debnath
Bibhas Debnath

Reputation: 14939

You need to order by updated and limit to one result. This should work(I haven't tested it, syntax might be wrong) - 

Ticker.query.order_by('updated desc').limit(1)

Upvotes: 20

Related Questions