Skip to main content

Introduction

This module will help you paginate results from any database if you use the sqlalchemy object Query. The PageModel pydantic model can be easily integrated with FastAPI and swagger.

Getting Started

Here is a brief example of how to use this code.

from pygination import paginate
from pygination.models import PageModel

query = db.query(models.City)

if country_id is not None:
    query = query.filter(models.City.country_id == country_id)

page = paginate(query, offset, limit)

print(page)
# Previous page does not exist. Next page is 2. Total number of pages 4

page_model = PageModel.from_orm(page)

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pygination-0.0.6.tar.gz (3.6 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

pygination-0.0.6-py3-none-any.whl (4.4 kB view details)

Uploaded Python 3

File details

Details for the file pygination-0.0.6.tar.gz.

File metadata

  • Download URL: pygination-0.0.6.tar.gz
  • Upload date:
  • Size: 3.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.1 pkginfo/1.8.2 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.56.0 CPython/3.7.4

File hashes

Hashes for pygination-0.0.6.tar.gz
Algorithm Hash digest
SHA256 6c148c5017560799d0a0bee0d7ea7dc01e64110e9e1a721026dc653197233cb6
MD5 a72904b6f75c565d62ed3b0de5c028e1
BLAKE2b-256 59f654d3674eddce0869fecfb02b1ecef8d6ef89945a215ff5a644f99c584370

See more details on using hashes here.

File details

Details for the file pygination-0.0.6-py3-none-any.whl.

File metadata

  • Download URL: pygination-0.0.6-py3-none-any.whl
  • Upload date:
  • Size: 4.4 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.10.1 pkginfo/1.8.2 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.56.0 CPython/3.7.4

File hashes

Hashes for pygination-0.0.6-py3-none-any.whl
Algorithm Hash digest
SHA256 51f8f291838c156e9617c05eb87c876a6da2db9f57ee96cb39f0ad0b0f10cc72
MD5 43ebfc47e324ca470bd52f941726955d
BLAKE2b-256 6dba83b37c488a40dd9f3c73795650d07089e78b23758c7c919773149c2727aa

See more details on using hashes here.

Release history Release notifications | RSS feed

0.0.13

2 files

0.0.12

2 files

0.0.11

2 files

0.0.10

2 files

0.0.9

2 files

0.0.8

2 files

0.0.7

2 files

This release

0.0.6 This release

2 files

0.0.5

2 files

0.0.4

2 files

0.0.3

2 files

0.0.2

2 files

0.0.1

2 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page