inspectomop.results.Results¶
-
class
inspectomop.results.
Results
(results_proxy)¶ A cursor-like object with methods such as fetchone, fetchmany etc. that can be used to retrieve rows of results from query execution.
A subclass of sqlalchemy.engine.result.ResultProxy that adds additional methods for retreving query results as Pandas DataFrames.
See also
-
__init__
(results_proxy)¶ Initialize self. See help(type(self)) for accurate signature.
Methods
__init__
(results_proxy)Initialize self. as_pandas
()Return all rows from a results object as a pandas DataFrame as_pandas_chunks
(chunksize)Yields a pandas DataFrame with n_rows = chunksize close
()Close this ResultProxy. fetchall
()Fetch all rows, just like DB-API cursor.fetchall()
.fetchmany
([size])Fetch many rows, just like DB-API cursor.fetchmany(size=cursor.arraysize)
.fetchone
()Fetch one row, just like DB-API cursor.fetchone()
.first
()Fetch the first row and then close the result set unconditionally. keys
()Return the list of string keys that would represented by each RowProxy
.last_inserted_params
()Return the collection of inserted parameters from this execution. last_updated_params
()Return the collection of updated parameters from this execution. lastrow_has_defaults
()Return lastrow_has_defaults()
from the underlyingExecutionContext
.next
()Implement the Python next() protocol. postfetch_cols
()Return postfetch_cols()
from the underlyingExecutionContext
.prefetch_cols
()Return prefetch_cols()
from the underlyingExecutionContext
.process_rows
(rows)scalar
()Fetch the first column of the first row, and close the result set. supports_sane_multi_rowcount
()Return supports_sane_multi_rowcount
from the dialect.supports_sane_rowcount
()Return supports_sane_rowcount
from the dialect.Attributes
closed
inserted_primary_key
Return the primary key for the row just inserted. is_insert
True if this _engine.ResultProxy
is the result of a executing an expression language compiled_expression.insert()
construct.lastrowid
return the ‘lastrowid’ accessor on the DBAPI cursor. out_parameters
returned_defaults
Return the values of default columns that were fetched using the ValuesBase.return_defaults()
feature.returns_rows
True if this _engine.ResultProxy
returns rows.rowcount
Return the ‘rowcount’ for this result. -