Class GPUdbSqlIterator

class gpudb.GPUdbSqlIterator(db: GPUdb, sql: str, batch_size: int = 5000, sql_params=[], sql_opts: dict = {})

Iterates over the records of a given query.

Example

result_list = []
with GPUdbSqlIterator(db, sql,
                      batch_size=batch_size,
                      sql_opts=sql_opts) as sql_iter:

    for rec in tqdm(iterable=sql_iter,
                    total=sql_iter.total_count,
                    desc='Fetching Records',
                    disable=(not show_progress),
                    ncols=cls.TQDM_NCOLS):
        result_list.append(rec)