cursor-illu

fetchmany.py

PAGINATION_COUNT = 5

with connect(**config) as conn:
    with conn.cursor() as cur:
        cur.execute(sql_query, ["John%"])
        res = cur.fetchmany(PAGINATION_COUNT):
        # You only get 5 rows at max