U:RDoc::NormalClass[iI" Database:ETI"SQLite3::Database;TI" Object;To:RDoc::Markup::Document: @parts[o;;[: @fileI"ext/sqlite3/database.c;T:0@omit_headings_from_table_of_contents_below0o;;[ o:RDoc::Markup::Paragraph;[I"PThe Database class encapsulates a single connection to a SQLite3 database. ;TI"'Its usage is very straightforward:;To:RDoc::Markup::BlankLineo:RDoc::Markup::Verbatim;[ I"require 'sqlite3' ;TI" ;TI"0SQLite3::Database.new( "data.db" ) do |db| ;TI"4 db.execute( "select * from table" ) do |row| ;TI" p row ;TI" end ;TI" end ;T: @format0o; ;[I"KIt wraps the lower-level methods provides by the selected driver, and ;TI"Jincludes the Pragmas module for access to various pragma convenience ;TI" methods.;T@o; ;[ I"MThe Database class provides type translation services as well, by which ;TI"Jthe SQLite3 data types (which are all represented as strings) may be ;TI"Iconverted into their corresponding types (as defined in the schemas ;TI"Mfor their tables). This translation only occurs when querying data from ;TI"Athe database--insertions and updates are all still typeless.;T@o; ;[ I"MFurthermore, the Database class has been designed to work well with the ;TI"HArrayFields module from Ara Howard. If you require the ArrayFields ;TI"Nmodule before performing a query, and if you have not enabled results as ;TI"Bhashes, then the results will all be indexible by field name.;T; I"lib/sqlite3/database.rb;T; 0; 0; 0[[ I"collations;TI"R;T: publicFI"lib/sqlite3/database.rb;T[ I"results_as_hash;TI"RW;T;F@6[U:RDoc::Constant[iI"NULL_TRANSLATOR;FI"'SQLite3::Database::NULL_TRANSLATOR;T00o;;[; @1; 0@1@cRDoc::NormalClass0[[I" Pragmas;To;;[; @1; 0@6[[I" class;T[[;[ [I" arity;F@6[I" finalize;F@6[I" name;F@6[I"new;T@6[I" quote;F@6[I" step;F@6[I" template;F@6[:protected[[: private[[I" instance;T[[;[1[I"authorizer;F@6[I"authorizer=;TI"ext/sqlite3/database.c;T[I"busy_handler;T@h[I"busy_timeout;T@6[I"busy_timeout=;T@h[I" changes;T@h[I" close;T@h[I" closed?;T@h[I"collation;T@h[I" commit;F@6[I"complete?;T@h[I"create_aggregate;F@6[I"create_aggregate_handler;F@6[I"create_function;F@6[I"define_aggregator;F@6[I"define_function;T@h[I"define_function_with_flags;T@h[I"enable_load_extension;T@h[I" encoding;T@h[I" errcode;T@h[I" errmsg;T@h[I" execute;F@6[I" execute2;F@6[I"execute_batch;F@6[I"execute_batch2;F@6[I"extended_result_codes=;T@h[I" filename;F@6[I" finalize;F@6[I"get_first_row;F@6[I"get_first_value;F@6[I"interrupt;T@h[I"last_insert_row_id;T@h[I"load_extension;T@h[I" prepare;F@6[I" query;F@6[I"readonly?;F@6[I" rollback;F@6[I" step;F@6[I"total_changes;T@h[I" trace;T@h[I"transaction;F@6[I"transaction_active?;T@h[I"translate_from_db;F@6[I"translator;F@6[;[[;[ [I"db_filename;T@h[I"exec_batch;T@h[I"make_type_translator;F@6[I" open16;T@h[I" open_v2;T@h[[U:RDoc::Context::Section[i0o;;[; 0; 0[I"ext/sqlite3/backup.c;T@1I" SQLite3;TcRDoc::NormalModule