2

I'm trying to implement faster SQLalchemy query with limit and offset as proposed here: https://github.com/sqlalchemy/sqlalchemy/wiki/WindowFunctionsByDefault

to solve the problem described here: memory-efficient built-in SqlAlchemy iterator/generator?

Copied the code from: https://github.com/sqlalchemy/sqlalchemy/wiki/WindowFunctionsByDefault to local environment and try to change the query at the main to fit my situation

session.execute(select([TableObject.__table__])).fetchall() works for me.

When I try to add limit(integer).offset(integer) like session.execute(select([TableObject.__table__]).limit(integer).offset(3)).fetchall()

I get the following error {AttributeError}can't set attribute

How can I get the results of Select object query with these attributes?

user3652172
  • 263
  • 1
  • 10

0 Answers0