cursor-illu

serversidebatch200.py

def main():
    sql_query = 'SELECT * FROM film'
    with connect(**config) as conn:
        with conn.cursor("film") as cur:
            # This fetches only 200 records from DB as batches
            # If you don't specify, the default value is 2000
            cur.itersize = 200
            cur.execute(sql_query)

            for row in cur:
                print(row) # Use row