Class ActiveRecord::ConnectionAdapters::SQLiteAdapter
In: lib/active_record/connection_adapters/sqlite_adapter.rb
Parent: AbstractAdapter

The SQLite adapter works with both the 2.x and 3.x series of SQLite with the sqlite-ruby drivers (available both as gems and from rubyforge.org/projects/sqlite-ruby/).

Options:

  • :database - Path to the database file.

Methods

Classes and Modules

Class ActiveRecord::ConnectionAdapters::SQLiteAdapter::StatementPool
Class ActiveRecord::ConnectionAdapters::SQLiteAdapter::Version

External Aliases

insert_sql -> create
remove_column -> remove_columns

Public Class methods

Public Instance methods

Clears the prepared statements cache.

Disconnects from the database if already connected. Otherwise, this method does nothing.

DATABASE STATEMENTS ======================================

exec_update(sql, name = 'SQL', binds = [])

Alias for exec_delete

Renames a table.

Example:

  rename_table('octopuses', 'octopi')

Returns true if SQLite version is ‘3.1.6’ or greater, false otherwise.

Returns true if SQLite version is ‘2.0.0’ or greater, false otherwise.

Returns true if SQLite version is ‘3.6.8’ or greater, false otherwise.

Returns true, since this connection adapter supports prepared statement caching.

See: www.sqlite.org/lang_altertable.html SQLite has an additional restriction on the ALTER TABLE statement

Protected Instance methods

[Validate]