class SQLite3::ResultSet
obtain a ResultSet instance via Statement#execute.
very rarely (if ever) be instantiated directly. Instead, clients should
It is a simple cursor over the data that the query returns. It will
The ResultSet object encapsulates the enumerability of a query’s output.
def close
Use with caution! Closing a result set will automatically
Closes the statement that spawned this result set.
def close @stmt.close end
def closed?
def closed? @stmt.closed? end
def columns
def columns @stmt.columns end
def each
Required by the Enumerable mixin. Provides an internal iterator over the
def each while (node = self.next) yield node end end
def each_hash
Provides an internal iterator over the rows of the result set where
def each_hash while (node = next_hash) yield node end end
def eof?
def eof? @stmt.done? end
def initialize db, stmt
Create a new ResultSet attached to the given database, using the
def initialize db, stmt @db = db @stmt = stmt end
def next
For hashes, the column names are the keys of the hash, and the column
and the column types are accessible via the +types+ property.
For arrays, the column names are accessible via the +fields+ property,
been set to +true+, in which case the returned value will be a hash.
The returned value will be an array, unless Database#results_as_hash has
had, this will return +nil+.
Obtain the next row from the cursor. If there are no more rows to be
def next @stmt.step end
def next_hash
def next_hash row = @stmt.step return nil if @stmt.done? @stmt.columns.zip(row).to_h end
def reset(*bind_params)
Reset the cursor, so that a result set which has reached end-of-file
def reset(*bind_params) @stmt.reset! @stmt.bind_params(*bind_params) end
def types
def types @stmt.types end