Skip to main content

class  pixeltable.ResultCursor

Cursor that iterates over query results. Wraps a Query and yields Row objects one at a time, avoiding materializing all results into memory. A cursor transitions through three states: pending (created but not yet started), open (actively iterating), and closed (resources released). Iteration auto-opens and auto-closes the cursor, or you can use it as a context manager for explicit lifecycle control.

method  close()

Signature
close() -> None
Release the underlying database transaction and query resources. Safe to call multiple times. Once closed, the cursor cannot be reopened. Also called automatically via the context manager protocol and on garbage collection.

method  open()

Signature
open() -> None
Start the underlying query and prepare the cursor for iteration. Raises an error if the cursor is already open or has been closed. Called automatically when iterating if not already open.
Last modified on April 17, 2026