class SQLite3::Statement

Overview

A statement represents a prepared-but-unexecuted SQL query.

Superclass hierarchy

Instance Method Summary

• #[](index : Int)

  Returns the value of the given column by index (1-based).

• #[](name : String)

  Returns the value of the given column by name.

• #[]=(index : Int, value : Int64)

  Binds the parameter at the given index to an Int64.

• #[]=(index : Int, value : Int32)

  Binds the parameter at the given index to an Int32.

• #[]=(index : Int, value : Nil)

  Binds the parameter at the given index to an Int.

• #[]=(name : String | Symbol, value)

  Binds a named parameter, using the :AAAA naming scheme for parameters.

• #[]=(index : Int, hash : Hash)

  Binds a hash to this statement (the index is ignored).

• #[]=(index : Int, value : Slice(UInt8))

  Binds the parameter at the given index to a BLOB.

• #[]=(index : Int, value : Float)

  Binds the parameter at the given index to a Float.

• #[]=(index : Int, value : String)

  Binds the parameter at the given index to a String.

• #close

  Closes this statement.

• #closed?

  Returns true if this statement is closed.

• #column_count

  Returns the number of columns in this statement.

• #column_name(index)

  Returns the name of the column at the given index.

• #column_type(index : Int)

  Returns the Type of the column at the given index.

• #columns

  Returns the column names of this statement.

• #execute(*binds, &block)

  Executes this statement with the given binds and yields a ResultSet that will be closed at the end of the block.

• #execute(binds : Enumerable | Slice(UInt8), &block)

  Executes this statement with the given binds and yields a ResultSet that will be closed at the end of the block.

• #execute(binds : Slice(UInt8))

  Executes this statement with a single BLOB bind and returns a ResultSet.

• #execute(binds : Enumerable)

  Executes this statement with the given binds and returns a ResultSet.

• #execute(*binds)

  Executes this statement with the given binds and returns a ResultSet.

• #reset

  Reset this statment, allowing to re-execute it with new binds.

• #types

  Returns an Array(Type) of this statement's columns.

Instance Method Detail