WinterFramework / winter

Web Framework with focus on python typing, dataclasses and modular design
MIT License
17 stars 18 forks source link

Add paginate to winter_sqlalchemy #194

Closed pristupa closed 3 years ago

pristupa commented 3 years ago
from sqlalchemy import select
from winter.data.pagination import PagePosition
from winter_sqlalchemy import paginate

query = select([table.c.id, table.c.name]).where(table.c.id < 100)
query = paginate(query, PagePosition(3, 5, Sort.by('id').desc()))
result = connection.execute(query)