Using the OVER window function in SQLAlchemy

Question

How would I get the total count of a limited result with SQLAlchemy. I am currently using Postgres so I know I can use windowed functions. I basically want to know how I would write the following in SQLAlchemy:

SELECT foo
  ,count(*) OVER() AS full_count
FROM   bar
ORDER  BY <some col>
LIMIT  <pagesize>
OFFSET <offset>

sayap · Accepted Answer · 2013-01-30 08:58:15Z

3

Something like:

select(
    [
        bar.c.foo,
        func.count().over().label('full_count'),
    ],
    ...
)

Ticket where this was introduced: http://www.sqlalchemy.org/trac/ticket/1844#comment:9

answered Jan 30, 2013 at 8:58

sayap

6,2852 gold badges38 silver badges40 bronze badges

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

1 Comment

Vincent Catalano Over a year ago

Thanks! That's exactly what I was looking for. I would also add that the following imports were needed: from sqlalchemy.sql.expression import select and from sqlalchemy import func.

Collectives™ on Stack Overflow

Using the OVER window function in SQLAlchemy

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related