SQLite3::Database class of PicoRuby

Include

Pragmas

Type aliases

sqlite3_row_t

Hash[String, String] | Array[String]

Singleton methods

__store

SQLite3::Database.__store() -> untyped

new

SQLite3::Database.new(String filename, ?results_as_hash: bool) ?{ (SQLite3::Database) -> void } -> void

open

SQLite3::Database.open(String filename) ?{ (SQLite3::Database) -> void } -> SQLite3::Database

Instance methods

_restore_from_store

instance._restore_from_store(String name) -> SQLite3::Database

backup

instance.backup(SQLite3::Database dst, ?srcname: String, ?dstname: String) -> bool

changes

instance.changes() -> Integer

close

instance.close() -> void

closed?

instance.closed?() -> bool

commit

instance.commit() -> bool

deserialize

instance.deserialize(String bytes) -> SQLite3::Database

execute

instance.execute(String sql, ?Array[sqlite3_bind_t] bind_vars) -> Array[Array[sqlite3_var_t] | Hash[String, sqlite3_var_t]]
instance.execute(String sql, ?Array[sqlite3_bind_t] bind_vars) { (Array[sqlite3_var_t])        -> Array[sqlite3_var_t]        } -> nil
instance.execute(String sql, ?Array[sqlite3_bind_t] bind_vars) { (Hash[String, sqlite3_var_t]) -> Hash[String, sqlite3_var_t] } -> nil
instance.execute(String sql, ?Array[sqlite3_bind_t] bind_vars) { (untyped) -> untyped } -> nil

execute_batch

instance.execute_batch(String sql) -> nil

filename

instance.filename() -> String?

get_first_row

instance.get_first_row(String sql, ?Array[sqlite3_bind_t] bind_vars) -> (Array[sqlite3_var_t] | Hash[String, sqlite3_var_t])?

get_first_value

instance.get_first_value(String sql, ?Array[sqlite3_bind_t] bind_vars) -> sqlite3_var_t

last_insert_row_id

instance.last_insert_row_id() -> Integer

persist

instance.persist() -> bool

prepare

instance.prepare(String sql) { (SQLite3::Statement) -> untyped } -> nil
instance.prepare(String sql) -> SQLite3::Statement

query

instance.query(String sql, ?Array[sqlite3_bind_t] bind_vars) -> SQLite3::ResultSet
instance.query(String sql, ?Array[sqlite3_bind_t] bind_vars) { (SQLite3::ResultSet) -> untyped } -> untyped

readonly?

instance.readonly?() -> bool

rollback

instance.rollback() -> bool

serialize

instance.serialize() -> String

total_changes

instance.total_changes() -> Integer

transaction

instance.transaction(?Symbol mode) -> bool
instance.transaction(?Symbol mode) { (SQLite3::Database) -> untyped } -> untyped

transaction_active?

instance.transaction_active?() -> bool

Attr accessors

results_as_hash (accessor)

instance.results_as_hash -> bool
Tags: class