class SQLite3::ResultSet

Overview

The ResultSet object encapsulates the enumerability of a query’s output. It is a simple cursor over the data that the query returns.

Typical usage is:

require "sqlite3"

db = SQLite3::Database.new("foo.db")
stmt = db.prepare("select * from person")
result_set = stmt.execute
while result_set.next
  p result_set.to_a
end
stmt.close
db.close

Superclass hierarchy

Instance Method Summary

• #[](index_or_name)

  Returns the value of a column by index or name.

• #close

  Closes this result set, closing the associated statement.

• #closed?

  Returns true if the associated statement is closed.

• #column_count

  Returns the number of columns.

• #columns

  Returns the names of the columns, an Array(String).

• #next

  Advances to the next row.

• #to_a

  Return the current row's value as an Array(Value).

• #types

  Returns the types of the columns, an Array(Type).

Instance Method Detail