SQLite3 is a wrapper around the popular database sqlite.\n
For an example of usage, see SQLite3::Database …\n"],["SQLite3::AbortException","","SQLite3/AbortException.html","",""],["SQLite3::AuthorizationException","","SQLite3/AuthorizationException.html","",""],["SQLite3::Backup","","SQLite3/Backup.html","",""],["SQLite3::Blob","","SQLite3/Blob.html","","
A class for differentiating between strings and blobs, when binding them\n\n
into statements.\n"],["SQLite3::BusyException","","SQLite3/BusyException.html","",""],["SQLite3::CantOpenException","","SQLite3/CantOpenException.html","",""],["SQLite3::Constants","","SQLite3/Constants.html","",""],["SQLite3::Constants::ColumnType","","SQLite3/Constants/ColumnType.html","",""],["SQLite3::Constants::ErrorCode","","SQLite3/Constants/ErrorCode.html","",""],["SQLite3::Constants::Open","","SQLite3/Constants/Open.html","","
sqlite3_open_v2 flags for Database::new\n"],["SQLite3::Constants::TextRep","","SQLite3/Constants/TextRep.html","",""],["SQLite3::ConstraintException","","SQLite3/ConstraintException.html","",""],["SQLite3::CorruptException","","SQLite3/CorruptException.html","",""],["SQLite3::Database","","SQLite3/Database.html","","
The Database class encapsulates a single connection to a SQLite3 database.\nIts usage is very straightforward: …\n"],["SQLite3::Database::FunctionProxy","","SQLite3/Database/FunctionProxy.html","","
A helper class for dealing with custom functions (see #create_function,\n#create_aggregate, and #create_aggregate_handler …\n"],["SQLite3::EmptyException","","SQLite3/EmptyException.html","",""],["SQLite3::Exception","","SQLite3/Exception.html","",""],["SQLite3::FormatException","","SQLite3/FormatException.html","",""],["SQLite3::FullException","","SQLite3/FullException.html","",""],["SQLite3::IOException","","SQLite3/IOException.html","",""],["SQLite3::InternalException","","SQLite3/InternalException.html","",""],["SQLite3::InterruptException","","SQLite3/InterruptException.html","",""],["SQLite3::LockedException","","SQLite3/LockedException.html","",""],["SQLite3::MemoryException","","SQLite3/MemoryException.html","",""],["SQLite3::MismatchException","","SQLite3/MismatchException.html","",""],["SQLite3::MisuseException","","SQLite3/MisuseException.html","",""],["SQLite3::NotADatabaseException","","SQLite3/NotADatabaseException.html","",""],["SQLite3::NotFoundException","","SQLite3/NotFoundException.html","",""],["SQLite3::PermissionException","","SQLite3/PermissionException.html","",""],["SQLite3::Pragmas","","SQLite3/Pragmas.html","","
This module is intended for inclusion solely by the Database class. It\ndefines convenience methods for …\n"],["SQLite3::ProtocolException","","SQLite3/ProtocolException.html","",""],["SQLite3::RangeException","","SQLite3/RangeException.html","",""],["SQLite3::ReadOnlyException","","SQLite3/ReadOnlyException.html","",""],["SQLite3::ResultSet","","SQLite3/ResultSet.html","","
The ResultSet object encapsulates the enumerability of a query's\noutput. It is a simple cursor over …\n"],["SQLite3::ResultSet::ArrayWithTypes","","SQLite3/ResultSet/ArrayWithTypes.html","",""],["SQLite3::ResultSet::ArrayWithTypesAndFields","","SQLite3/ResultSet/ArrayWithTypesAndFields.html","",""],["SQLite3::ResultSet::HashWithTypesAndFields","","SQLite3/ResultSet/HashWithTypesAndFields.html","",""],["SQLite3::SQLException","","SQLite3/SQLException.html","",""],["SQLite3::SchemaChangedException","","SQLite3/SchemaChangedException.html","",""],["SQLite3::Statement","","SQLite3/Statement.html","","
A statement represents a prepared-but-unexecuted SQL query. It will rarely\n(if ever) be instantiated …\n"],["SQLite3::TooBigException","","SQLite3/TooBigException.html","",""],["SQLite3::Translator","","SQLite3/Translator.html","","
The Translator class encapsulates the logic and callbacks necessary for\nconverting string data to a value …\n"],["SQLite3::UnsupportedException","","SQLite3/UnsupportedException.html","",""],["SQLite3::Value","","SQLite3/Value.html","",""],["SQLite3::VersionProxy","","SQLite3/VersionProxy.html","",""],["String","","String.html","",""],["[]","SQLite3::Database::FunctionProxy","SQLite3/Database/FunctionProxy.html#method-i-5B-5D","( key )","
Returns the value with the given key from the context. This is only\navailable to aggregate functions. …\n"],["[]=","SQLite3::Database::FunctionProxy","SQLite3/Database/FunctionProxy.html#method-i-5B-5D-3D","( key, value )","
Sets the value with the given key in the context. This is only available to\naggregate functions.\n"],["active?","SQLite3::Statement","SQLite3/Statement.html#method-i-active-3F","()","
Returns true if the statement is currently active, meaning it has an open\nresult set.\n"],["add_translator","SQLite3::Translator","SQLite3/Translator.html#method-i-add_translator","( type )","
Add a new translator block, which will be invoked to process type\ntranslations to the given type. The …\n"],["application_id","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-application_id","()",""],["application_id=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-application_id-3D","( integer )",""],["arity","SQLite3::Database","SQLite3/Database.html#method-c-arity","()",""],["authorizer","SQLite3::Database","SQLite3/Database.html#method-i-authorizer","( &block )","
Installs (or removes) a block that will be invoked for every access to the\ndatabase. If the block returns …\n"],["authorizer=","SQLite3::Database","SQLite3/Database.html#method-i-authorizer-3D","(p1)","
Set the authorizer for this database. auth must respond to\ncall, and call must take 5 arguments.\n
Installs …\n"],["auto_vacuum","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-auto_vacuum","()",""],["auto_vacuum=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-auto_vacuum-3D","( mode )",""],["automatic_index","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-automatic_index","()",""],["automatic_index=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-automatic_index-3D","( mode )",""],["bind_param","SQLite3::Statement","SQLite3/Statement.html#method-i-bind_param","(p1, p2)","
Binds value to the named (or positional) placeholder. If param\nis a Fixnum, it is treated as an index …\n"],["bind_parameter_count","SQLite3::Statement","SQLite3/Statement.html#method-i-bind_parameter_count","()","
Return the number of bind parameters\n"],["bind_params","SQLite3::Statement","SQLite3/Statement.html#method-i-bind_params","( *bind_vars )","
Binds the given variables to the corresponding placeholders in the SQL\ntext.\n
See Database#execute for …\n"],["busy_handler","SQLite3::Database","SQLite3/Database.html#method-i-busy_handler","(p1 = v1)","
Register a busy handler with this database instance. When a requested\nresource is busy, this handler …\n"],["busy_timeout","SQLite3::Database","SQLite3/Database.html#method-i-busy_timeout","(p1)",""],["busy_timeout","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-busy_timeout","()",""],["busy_timeout=","SQLite3::Database","SQLite3/Database.html#method-i-busy_timeout-3D","(p1)","
Indicates that if a request for a resource terminates because that resource\nis busy, SQLite should sleep …\n"],["busy_timeout=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-busy_timeout-3D","( milliseconds )",""],["cache_size","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-cache_size","()",""],["cache_size=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-cache_size-3D","( size )",""],["cache_spill","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-cache_spill","()",""],["cache_spill=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-cache_spill-3D","( mode )",""],["case_sensitive_like=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-case_sensitive_like-3D","( mode )",""],["cell_size_check","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-cell_size_check","()",""],["cell_size_check=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-cell_size_check-3D","( mode )",""],["changes","SQLite3::Database","SQLite3/Database.html#method-i-changes","()","
Returns the number of changes made to this database instance by the last\noperation performed. Note that …\n"],["checkpoint_fullfsync","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-checkpoint_fullfsync","()",""],["checkpoint_fullfsync=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-checkpoint_fullfsync-3D","( mode )",""],["clear_bindings!","SQLite3::Statement","SQLite3/Statement.html#method-i-clear_bindings-21","()","
Resets the statement. This is typically done internally, though it might\noccassionally be necessary to …\n"],["close","SQLite3::Database","SQLite3/Database.html#method-i-close","()","
Closes this database.\n"],["close","SQLite3::ResultSet","SQLite3/ResultSet.html#method-i-close","()","
Closes the statement that spawned this result set. Use with\ncaution! Closing a result set will automatically …\n"],["close","SQLite3::Statement","SQLite3/Statement.html#method-i-close","()","
Closes the statement by finalizing the underlying statement handle. The\nstatement must not be used after …\n"],["closed?","SQLite3::Database","SQLite3/Database.html#method-i-closed-3F","()","
Returns true if this database instance has been closed (see\n#close).\n"],["closed?","SQLite3::ResultSet","SQLite3/ResultSet.html#method-i-closed-3F","()","
Queries whether the underlying statement has been closed or not.\n"],["closed?","SQLite3::Statement","SQLite3/Statement.html#method-i-closed-3F","()","
Returns true if the statement has been closed.\n"],["collation","SQLite3::Database","SQLite3/Database.html#method-i-collation","(p1, p2)","
Add a collation with name name, and a comparator\nobject. The comparator object should implement a method …\n"],["collation_list","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-collation_list","( )",""],["column_count","SQLite3::Statement","SQLite3/Statement.html#method-i-column_count","()","
Returns the number of columns to be returned for this statement\n"],["column_decltype","SQLite3::Statement","SQLite3/Statement.html#method-i-column_decltype","(p1)","
Get the column type at index. 0 based.\n"],["column_name","SQLite3::Statement","SQLite3/Statement.html#method-i-column_name","(p1)","
Get the column name at index. 0 based.\n"],["columns","SQLite3::ResultSet","SQLite3/ResultSet.html#method-i-columns","()","
Returns the names of the columns returned by this result set.\n"],["columns","SQLite3::Statement","SQLite3/Statement.html#method-i-columns","()","
Return an array of the column names for this statement. Note that this may\nexecute the statement in order …\n"],["commit","SQLite3::Database","SQLite3/Database.html#method-i-commit","()","
Commits the current transaction. If there is no current transaction, this\nwill cause an error to be raised. …\n"],["compile_options","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-compile_options","( )",""],["complete?","SQLite3::Database","SQLite3/Database.html#method-i-complete-3F","(p1)","
Return true if the string is a valid (ie, parsable) SQL\nstatement, and false otherwise.\n"],["const_missing","SQLite3","SQLite3.html#method-c-const_missing","(name)",""],["count","SQLite3::Database::FunctionProxy","SQLite3/Database/FunctionProxy.html#method-i-count","()","
(Only available to aggregate functions.) Returns the number of rows that\nthe aggregate has processed …\n"],["count_changes","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-count_changes","()",""],["count_changes=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-count_changes-3D","( mode )",""],["create_aggregate","SQLite3::Database","SQLite3/Database.html#method-i-create_aggregate","( name, arity, step=nil, finalize=nil, text_rep=Constants::TextRep::ANY, &block )","
Creates a new aggregate function for use in SQL statements. Aggregate\nfunctions are functions that apply …\n"],["create_aggregate_handler","SQLite3::Database","SQLite3/Database.html#method-i-create_aggregate_handler","( handler )","
This is another approach to creating an aggregate function (see\n#create_aggregate). Instead of explicitly …\n"],["create_function","SQLite3::Database","SQLite3/Database.html#method-i-create_function","(name, arity, text_rep=Constants::TextRep::UTF8, &block)","
Creates a new function for use in SQL statements. It will be added as\nname, with the given arity. (For …\n"],["data_version","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-data_version","()",""],["database_list","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-database_list","( )",""],["database_name","SQLite3::Statement","SQLite3/Statement.html#method-i-database_name","(p1)","
Return the database name for the column at column_index\n"],["db_filename","SQLite3::Database","SQLite3/Database.html#method-i-db_filename","(p1)","
Returns the file associated with database_name. Can return\nnil or an empty string if the database is …\n"],["default_cache_size","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-default_cache_size","()",""],["default_cache_size=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-default_cache_size-3D","( size )",""],["default_synchronous","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-default_synchronous","()",""],["default_synchronous=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-default_synchronous-3D","( mode )",""],["default_temp_store","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-default_temp_store","()",""],["default_temp_store=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-default_temp_store-3D","( mode )",""],["defer_foreign_keys","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-defer_foreign_keys","()",""],["defer_foreign_keys=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-defer_foreign_keys-3D","( mode )",""],["define_aggregator","SQLite3::Database","SQLite3/Database.html#method-i-define_aggregator","( name, aggregator )","
Define an aggregate function named name using a object\ntemplate object aggregator. aggregator must\nrespond …\n"],["define_function","SQLite3::Database","SQLite3/Database.html#method-i-define_function","(p1)","
Define a function named name with args. The\narity of the block will be used as the arity for the function …\n"],["define_function_with_flags","SQLite3::Database","SQLite3/Database.html#method-i-define_function_with_flags","(p1, p2)","
Define a function named name with args using\nTextRep bitflags flags. The arity of the block will be …\n"],["done?","SQLite3::Statement","SQLite3/Statement.html#method-i-done-3F","()","
returns true if all rows have been returned.\n"],["each","SQLite3::ResultSet","SQLite3/ResultSet.html#method-i-each","()","
Required by the Enumerable mixin. Provides an internal iterator over the\nrows of the result set.\n"],["each","SQLite3::Statement","SQLite3/Statement.html#method-i-each","()",""],["each_hash","SQLite3::ResultSet","SQLite3/ResultSet.html#method-i-each_hash","()","
Provides an internal iterator over the rows of the result set where each\nrow is yielded as a hash.\n"],["enable_load_extension","SQLite3::Database","SQLite3/Database.html#method-i-enable_load_extension","(p1)","
Enable or disable extension loading.\n"],["encoding","SQLite3::Database","SQLite3/Database.html#method-i-encoding","()","
Fetch the encoding set on this database\n"],["encoding","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-encoding","()",""],["encoding=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-encoding-3D","( mode )",""],["eof?","SQLite3::ResultSet","SQLite3/ResultSet.html#method-i-eof-3F","()","
Query whether the cursor has reached the end of the result set or not.\n"],["errcode","SQLite3::Database","SQLite3/Database.html#method-i-errcode","()","
Return an integer representing the last error to have occurred with this\ndatabase.\n"],["errmsg","SQLite3::Database","SQLite3/Database.html#method-i-errmsg","()","
Return a string describing the last error to have occurred with this\ndatabase.\n"],["exec_batch","SQLite3::Database","SQLite3/Database.html#method-i-exec_batch","(p1, p2)","
Is invoked by calling db.execute_batch2(sql, &block)\n
Executes all statments in a given string separated …\n"],["execute","SQLite3::Database","SQLite3/Database.html#method-i-execute","(sql, bind_vars = [], *args, &block)","
Executes the given SQL statement. If additional parameters are given, they\nare treated as bind variables, …\n"],["execute","SQLite3::Statement","SQLite3/Statement.html#method-i-execute","( *bind_vars )","
Execute the statement. This creates a new ResultSet object for the\nstatement's virtual machine. …\n"],["execute!","SQLite3::Statement","SQLite3/Statement.html#method-i-execute-21","( *bind_vars, &block )","
Execute the statement. If no block was given, this returns an array of rows\nreturned by executing the …\n"],["execute2","SQLite3::Database","SQLite3/Database.html#method-i-execute2","( sql, *bind_vars )","
Executes the given SQL statement, exactly as with #execute. However, the\nfirst row returned (either via …\n"],["execute_batch","SQLite3::Database","SQLite3/Database.html#method-i-execute_batch","( sql, bind_vars = [], *args )","
Executes all SQL statements in the given string. By contrast, the other\nmeans of executing queries will …\n"],["execute_batch2","SQLite3::Database","SQLite3/Database.html#method-i-execute_batch2","(sql, &block)","
Executes all SQL statements in the given string. By contrast, the other\nmeans of executing queries will …\n"],["extended_result_codes=","SQLite3::Database","SQLite3/Database.html#method-i-extended_result_codes-3D","(p1)","
Enable extended result codes in SQLite. These result codes allow for more\ndetailed exception reporting, …\n"],["filename","SQLite3::Database","SQLite3/Database.html#method-i-filename","(db_name = 'main')","
Returns the filename for the database named db_name. \ndb_name defaults to “main”. Main return …\n"],["finalize","SQLite3::Database","SQLite3/Database.html#method-c-finalize","( &block )",""],["finalize","SQLite3::Database","SQLite3/Database.html#method-i-finalize","()",""],["finish","SQLite3::Backup","SQLite3/Backup.html#method-i-finish","()","
Destroy the backup object.\n"],["foreign_key_check","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-foreign_key_check","( *table )",""],["foreign_key_list","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-foreign_key_list","( table )",""],["foreign_keys","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-foreign_keys","()",""],["foreign_keys=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-foreign_keys-3D","( mode )",""],["freelist_count","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-freelist_count","()",""],["full_column_names","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-full_column_names","()",""],["full_column_names=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-full_column_names-3D","( mode )",""],["fullfsync","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-fullfsync","()",""],["fullfsync=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-fullfsync-3D","( mode )",""],["get_boolean_pragma","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-get_boolean_pragma","( name )","
Returns true or false depending on the value of\nthe named pragma.\n"],["get_enum_pragma","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-get_enum_pragma","( name )","
Return the value of the given pragma.\n"],["get_first_row","SQLite3::Database","SQLite3/Database.html#method-i-get_first_row","( sql, *bind_vars )","
A convenience method for obtaining the first row of a result set, and\ndiscarding all others. It is otherwise …\n"],["get_first_value","SQLite3::Database","SQLite3/Database.html#method-i-get_first_value","( sql, *bind_vars )","
A convenience method for obtaining the first value of the first row of a\nresult set, and discarding all …\n"],["get_int_pragma","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-get_int_pragma","( name )","
Returns the value of the given pragma as an integer.\n"],["get_metadata","SQLite3::Statement","SQLite3/Statement.html#method-i-get_metadata","()","
A convenience method for obtaining the metadata about the query. Note that\nthis will actually execute …\n"],["get_query_pragma","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-get_query_pragma","( name, *parms )","
Requests the given pragma (and parameters), and if the block is given, each\nrow of the result set will …\n"],["ignore_check_constraints=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-ignore_check_constraints-3D","( mode )",""],["incremental_vacuum","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-incremental_vacuum","( pages )",""],["index_info","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-index_info","( index )",""],["index_list","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-index_list","( table )",""],["index_xinfo","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-index_xinfo","( index )",""],["integrity_check","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-integrity_check","( *num_errors )",""],["interrupt","SQLite3::Database","SQLite3/Database.html#method-i-interrupt","()","
Interrupts the currently executing operation, causing it to abort.\n"],["journal_mode","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-journal_mode","()",""],["journal_mode=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-journal_mode-3D","( mode )",""],["journal_size_limit","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-journal_size_limit","()",""],["journal_size_limit=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-journal_size_limit-3D","( size )",""],["last_insert_row_id","SQLite3::Database","SQLite3/Database.html#method-i-last_insert_row_id","()","
Obtains the unique row ID of the last row to be inserted by this Database\ninstance.\n"],["legacy_file_format","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-legacy_file_format","()",""],["legacy_file_format=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-legacy_file_format-3D","( mode )",""],["length","SQLite3::Value","SQLite3/Value.html#method-i-length","( utf16=false )",""],["libversion","SQLite3","SQLite3.html#method-c-libversion","()",""],["load_extension","SQLite3::Database","SQLite3/Database.html#method-i-load_extension","(p1)","
Loads an SQLite extension library from the named file. Extension loading\nmust be enabled using db.enable_load_extension …\n"],["locking_mode","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-locking_mode","()",""],["locking_mode=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-locking_mode-3D","( mode )",""],["make_type_translator","SQLite3::Database","SQLite3/Database.html#method-i-make_type_translator","(should_translate)",""],["max_page_count","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-max_page_count","()",""],["max_page_count=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-max_page_count-3D","( size )",""],["mmap_size","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-mmap_size","()",""],["mmap_size=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-mmap_size-3D","( size )",""],["name","SQLite3::Database","SQLite3/Database.html#method-c-name","()",""],["new","SQLite3::Backup","SQLite3/Backup.html#method-c-new","(p1, p2, p3, p4)","
Initialize backup the backup.\n
dstdb:\n\n
the destination SQLite3::Database object.\n"],["new","SQLite3::Database","SQLite3/Database.html#method-c-new","(file, options = {})","
Create a new Database object that opens the given file. If utf16 is\ntrue, the filename is interpreted …\n"],["new","SQLite3::Database::FunctionProxy","SQLite3/Database/FunctionProxy.html#method-c-new","()","
Create a new FunctionProxy that encapsulates the given func\nobject. If context is non-nil, the functions …\n"],["new","SQLite3::ResultSet","SQLite3/ResultSet.html#method-c-new","(db, stmt)","
Create a new ResultSet attached to the given database, using the given sql\ntext.\n"],["new","SQLite3::Statement","SQLite3/Statement.html#method-c-new","(p1, p2)","
Create a new statement attached to the given Database instance, and which\nencapsulates the given SQL …\n"],["new","SQLite3::Translator","SQLite3/Translator.html#method-c-new","()","
Create a new Translator instance. It will be preinitialized with default\ntranslators for most SQL data …\n"],["new","SQLite3::Value","SQLite3/Value.html#method-c-new","( db, handle )",""],["next","SQLite3::ResultSet","SQLite3/ResultSet.html#method-i-next","()","
Obtain the next row from the cursor. If there are no more rows to be had,\nthis will return nil. If type …\n"],["next_hash","SQLite3::ResultSet","SQLite3/ResultSet.html#method-i-next_hash","()","
Return the next row as a hash\n"],["null?","SQLite3::Value","SQLite3/Value.html#method-i-null-3F","()",""],["open16","SQLite3::Database","SQLite3/Database.html#method-i-open16","(p1)",""],["open_v2","SQLite3::Database","SQLite3/Database.html#method-i-open_v2","(p1, p2, p3)",""],["page_count","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-page_count","()",""],["page_size","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-page_size","()",""],["page_size=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-page_size-3D","( size )",""],["pagecount","SQLite3::Backup","SQLite3/Backup.html#method-i-pagecount","()","
Returns the total number of pages in the source database file.\n
Note that the value is only updated after …\n"],["parser_trace=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-parser_trace-3D","( mode )",""],["prepare","SQLite3::Database","SQLite3/Database.html#method-i-prepare","(sql)","
Returns a Statement object representing the given SQL. This does not\nexecute the statement; it merely …\n"],["query","SQLite3::Database","SQLite3/Database.html#method-i-query","( sql, bind_vars = [], *args )","
This is a convenience method for creating a statement, binding paramters to\nit, and calling execute: …\n"],["query_only","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-query_only","()",""],["query_only=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-query_only-3D","( mode )",""],["quick_check","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-quick_check","( *num_errors )",""],["quote","SQLite3::Database","SQLite3/Database.html#method-c-quote","( string )","
Quotes the given string, making it safe to use in an SQL statement. It\nreplaces all instances of the …\n"],["read_uncommitted","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-read_uncommitted","()",""],["read_uncommitted=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-read_uncommitted-3D","( mode )",""],["readonly?","SQLite3::Database","SQLite3/Database.html#method-i-readonly-3F","()","
Returns true if the database has been open in readonly mode A\nhelper to check before performing any operation …\n"],["recursive_triggers","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-recursive_triggers","()",""],["recursive_triggers=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-recursive_triggers-3D","( mode )",""],["register_default_translators","SQLite3::Translator","SQLite3/Translator.html#method-i-register_default_translators","()","
Register the default translators for the current Translator instance. This\nincludes translators for most …\n"],["remaining","SQLite3::Backup","SQLite3/Backup.html#method-i-remaining","()","
Returns the number of pages still to be backed up.\n
Note that the value is only updated after step() is …\n"],["reset","SQLite3::ResultSet","SQLite3/ResultSet.html#method-i-reset","( *bind_params )","
Reset the cursor, so that a result set which has reached end-of-file can be\nrewound and reiterated.\n"],["reset!","SQLite3::Statement","SQLite3/Statement.html#method-i-reset-21","()","
Resets the statement. This is typically done internally, though it might\noccassionally be necessary to …\n"],["reverse_unordered_selects","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-reverse_unordered_selects","()",""],["reverse_unordered_selects=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-reverse_unordered_selects-3D","( mode )",""],["rollback","SQLite3::Database","SQLite3/Database.html#method-i-rollback","()","
Rolls the current transaction back. If there is no current transaction,\nthis will cause an error to be …\n"],["schema_cookie","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-schema_cookie","()",""],["schema_cookie=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-schema_cookie-3D","( cookie )",""],["schema_version","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-schema_version","()",""],["schema_version=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-schema_version-3D","( version )",""],["secure_delete","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-secure_delete","()",""],["secure_delete=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-secure_delete-3D","( mode )",""],["set_boolean_pragma","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-set_boolean_pragma","( name, mode )","
Sets the given pragma to the given boolean value. The value itself may be\ntrue or false, or any other …\n"],["set_enum_pragma","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-set_enum_pragma","( name, mode, enums )","
Set the value of the given pragma to mode. The\nmode parameter must conform to one of the values in the …\n"],["set_error","SQLite3::Database::FunctionProxy","SQLite3/Database/FunctionProxy.html#method-i-set_error","( error )","
Set the result of the function to the given error message. The function\nwill then return that error. …\n"],["set_int_pragma","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-set_int_pragma","( name, value )","
Set the value of the given pragma to the integer value of the\nvalue parameter.\n"],["short_column_names","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-short_column_names","()",""],["short_column_names=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-short_column_names-3D","( mode )",""],["shrink_memory","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-shrink_memory","()",""],["soft_heap_limit","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-soft_heap_limit","()",""],["soft_heap_limit=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-soft_heap_limit-3D","( mode )",""],["sqlcipher?","SQLite3","SQLite3.html#method-c-sqlcipher-3F","()",""],["stats","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-stats","( )",""],["step","SQLite3::Backup","SQLite3/Backup.html#method-i-step","(p1)","
Copy database pages up to nPage. If negative, copy all\nremaining source pages.\n
If all pages are copied, …\n"],["step","SQLite3::Database","SQLite3/Database.html#method-c-step","( &block )",""],["step","SQLite3::Database","SQLite3/Database.html#method-i-step","( *args )",""],["step","SQLite3::Statement","SQLite3/Statement.html#method-i-step","()",""],["synchronous","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-synchronous","()",""],["synchronous=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-synchronous-3D","( mode )",""],["table_info","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-table_info","(table)","
Returns information about table. Yields each row of table\ninformation if a block is provided.\n"],["temp_store","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-temp_store","()",""],["temp_store=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-temp_store-3D","( mode )",""],["template","SQLite3::Database","SQLite3/Database.html#method-c-template","()",""],["threads","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-threads","()",""],["threads=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-threads-3D","( count )",""],["threadsafe","SQLite3","SQLite3.html#method-c-threadsafe","()","
Returns the compile time setting of the SQLITE_THREADSAFE flag. See:\nwww.sqlite.org/c3ref/threadsafe.html …\n"],["threadsafe?","SQLite3","SQLite3.html#method-c-threadsafe-3F","()","
Was sqlite3 compiled with thread safety on?\n"],["to_blob","SQLite3::Value","SQLite3/Value.html#method-i-to_blob","()",""],["to_blob","String","String.html#method-i-to_blob","()",""],["to_f","SQLite3::Value","SQLite3/Value.html#method-i-to_f","()",""],["to_i","SQLite3::Value","SQLite3/Value.html#method-i-to_i","()",""],["to_int64","SQLite3::Value","SQLite3/Value.html#method-i-to_int64","()",""],["to_s","SQLite3::Value","SQLite3/Value.html#method-i-to_s","( utf16=false )",""],["total_changes","SQLite3::Database","SQLite3/Database.html#method-i-total_changes","()","
Returns the total number of changes made to this database instance since it\nwas opened.\n"],["trace","SQLite3::Database","SQLite3/Database.html#method-i-trace","(p1 = v1)","
Installs (or removes) a block that will be invoked for every SQL statement\nexecuted. The block receives …\n"],["transaction","SQLite3::Database","SQLite3/Database.html#method-i-transaction","( mode = :deferred )","
Begins a new transaction. Note that nested transactions are not allowed by\nSQLite, so attempting to nest …\n"],["transaction_active?","SQLite3::Database","SQLite3/Database.html#method-i-transaction_active-3F","()","
Returns true if there is a transaction active, and\nfalse otherwise.\n"],["translate","SQLite3::Translator","SQLite3/Translator.html#method-i-translate","( type, value )","
Translate the given string value to a value of the given type. In the\nabsense of an installed translator …\n"],["translate_from_db","SQLite3::Database","SQLite3/Database.html#method-i-translate_from_db","(types, row)","
Translates a row of data from the database with the given\ntypes\n"],["translator","SQLite3::Database","SQLite3/Database.html#method-i-translator","()","
Return the type translator employed by this database instance. Each\ndatabase instance has its own type …\n"],["tweak_default","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-tweak_default","(hash)","
Since SQLite 3.3.8, the table_info pragma has returned the default value of\nthe row as a quoted SQL value. …\n"],["type","SQLite3::Value","SQLite3/Value.html#method-i-type","()",""],["type_name","SQLite3::Translator","SQLite3/Translator.html#method-i-type_name","( type )","
A convenience method for working with type names. This returns the “base”\ntype name, without …\n"],["types","SQLite3::ResultSet","SQLite3/ResultSet.html#method-i-types","()","
Returns the types of the columns returned by this result set.\n"],["types","SQLite3::Statement","SQLite3/Statement.html#method-i-types","()","
Return an array of the data types for each column in this statement. Note\nthat this may execute the statement …\n"],["user_cookie","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-user_cookie","()",""],["user_cookie=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-user_cookie-3D","( cookie )",""],["user_version","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-user_version","()",""],["user_version=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-user_version-3D","( version )",""],["vdbe_addoptrace=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-vdbe_addoptrace-3D","( mode )",""],["vdbe_debug=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-vdbe_debug-3D","( mode )",""],["vdbe_listing=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-vdbe_listing-3D","( mode )",""],["vdbe_trace","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-vdbe_trace","()",""],["vdbe_trace=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-vdbe_trace-3D","( mode )",""],["version_compare","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-version_compare","(v1, v2)","
Compares two version strings\n"],["wal_autocheckpoint","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-wal_autocheckpoint","()",""],["wal_autocheckpoint=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-wal_autocheckpoint-3D","( mode )",""],["wal_checkpoint","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-wal_checkpoint","()",""],["wal_checkpoint=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-wal_checkpoint-3D","( mode )",""],["writable_schema=","SQLite3::Pragmas","SQLite3/Pragmas.html#method-i-writable_schema-3D","( mode )",""],["API_CHANGES","","API_CHANGES_rdoc.html","","
API Changes\n
SQLite3::Database#execute only accepts an array for bind parameters.\n
SQLite3::ResultSet used …\n"],["CHANGELOG","","CHANGELOG_rdoc.html","","
1.4.2\n
Travis: Drop unused setting “sudo: false”\n
The taint mechanism will be deprecated in Ruby …\n"],["Manifest","","Manifest_txt.html","","
.gemtest .travis.yml API_CHANGES.rdoc CHANGELOG.rdoc ChangeLog.cvs Gemfile\nLICENSE Manifest.txt README.rdoc …\n"],["README","","README_rdoc.html","","
SQLite3/Ruby Interface\n
github.com/sparklemotion/sqlite3-ruby\n
groups.google.com/group/sqlite3-ruby\n"],["Makefile","","ext/sqlite3/Makefile.html","","
SHELL = /bin/sh\n
# V=0 quiet, V=1 verbose. other values don't work. V = 1 Q1 = $(V:1=)\nQ = $(Q1:0=@) …\n"]]}}