[EMAIL PROTECTED] wrote:
> I need a return array with START and LIMIT to create a pagination
> return in CLASS
>
> Who do its possible in elixir?
The SQLAlchemy Query object supports both `limit` and `offset` methods.
Here is an example for a "Person" entity:
class Person(Entity)
name = Field(Unicode)
age = Field(Integer)
... lets say you want to query for all people over the age of 21, but
you want to enforce a limit of 20 and and offset of 10:
people = Person.query.filter(Person.age>21).limit(20).offset(10)
Good luck. I suggest consulting the SQLAlchemy documentation at
sqlalchemy.org for more information on the Query object.
--
Jonathan LaCour
http://cleverdevil.org
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---
