Flask-SQLAlchemy - how to order a query object list?

Question

I have some files and info about them is in a SQL db. For a given group of files, they will all share a common gallery_id(text) and different upload_time(datetime). I'm trying to get a list of files that all share a common gallery id and then sort them by upload_time, but it isn't working. This is the syntax I used:

    >>> foo = Storedfile.query.filter_by(
        gallery_id ='kgLivY').all().order_by(Storedfile.upload_time)
        Traceback (most recent call last):
          File "<stdin>", line 1, in <module>
        AttributeError: 'list' object has no attribute 'order_by'

What am I doing wrong here?

rockingskier · Accepted Answer · 2014-02-28 02:40:39Z

8

You need to do the .all() last.

foo = Storedfile.query.filter_by(
    gallery_id='kgLivY').order_by(
        Storedfile.upload_time
    ).all()

all() returns a standard python list which then doesn't have the attribute/method order_by.

edited Feb 28, 2014 at 2:40

answered Feb 28, 2014 at 2:34

rockingskier

9,3763 gold badges42 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Flask-SQLAlchemy - how to order a query object list?

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