%SYS.Python.SQLResultSet

Class %SYS.Python.SQLResultSet Extends %RegisteredObject [ System = 4 ]

Implementation of SQL support

Properties

ResultSet

Property ResultSet As %SQL.StatementResult;

Wrapped ResultSet

IterationStarted

Property IterationStarted As %Boolean [ InitialExpression = 0 ];

Indicate if we're already started iteration

Methods

%OnNew

Method %OnNew(rs As %SQL.StatementResult) As %Status

Implement %OnNew handler

"iter"

Method "__iter__"()

Grab an iterator

"next"

Method "__next__"() As %String

"len"

Method "__len__"() As %Integer

We don't know the length/size of a result set ...

"contains"

Method "__contains__"() As %Boolean

We can't do a contains ...

dataframe

Method dataframe() As %SYS.Python

Convert resultset to a Pandas dataframe