Module: SchemaPlus::ActiveRecord::ConnectionAdapters::Sqlite3Adapter

Defined in:
lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb

Overview

SchemaPlus includes an Sqlite3 implementation of the AbstractAdapter extensions.

Defined Under Namespace

Modules: AddColumnOptions

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.included(base) ⇒ Object

:enddoc:



19
20
21
22
23
24
25
26
27
28
29
30
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 19

def self.included(base)
  base.class_eval do
    alias_method_chain :indexes, :schema_plus
    alias_method_chain :rename_table, :schema_plus
  end

  if ::ActiveRecord::VERSION::MAJOR.to_i < 4
    ::ActiveRecord::ConnectionAdapters::SQLiteColumn.send(:include, SQLiteColumn) unless ::ActiveRecord::ConnectionAdapters::SQLiteColumn.include?(SQLiteColumn)
  else
    ::ActiveRecord::ConnectionAdapters::SQLite3Column.send(:include, SQLiteColumn) unless ::ActiveRecord::ConnectionAdapters::SQLite3Column.include?(SQLiteColumn)
  end
end

Instance Method Details

#add_foreign_key(table_name, column_names, references_table_name, references_column_names, options = {}) ⇒ Object

Raises:

  • (NotImplementedError) 


53
54
55
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 53

def add_foreign_key(table_name, column_names, references_table_name, references_column_names, options = {})
  raise NotImplementedError, "Sqlite3 does not support altering a table to add foreign key constraints (table #{table_name.inspect} column #{column_names.inspect})"
end

#drop_table(name, options = {}) ⇒ Object 



61
62
63
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 61

def drop_table(name, options={})
  super(name, options.except(:cascade))
end

#foreign_keys(table_name, name = nil) ⇒ Object 



65
66
67
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 65

def foreign_keys(table_name, name = nil)
  get_foreign_keys(table_name, name)
end

#indexes_with_schema_plus(table_name, name = nil) ⇒ Object 



37
38
39
40
41
42
43
44
45
46
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 37

def indexes_with_schema_plus(table_name, name = nil)
  indexes = indexes_without_schema_plus(table_name, name)
  exec_query("SELECT name, sql FROM sqlite_master WHERE type = 'index'").map do |row|
    if (desc_columns = row['sql'].scan(/['"`]?(\w+)['"`]? DESC\b/).flatten).any?
      index = indexes.detect{ |i| i.name == row['name'] }
      index.orders = Hash[index.columns.map {|column| [column, desc_columns.include?(column) ? :desc : :asc]}]
    end
  end
  indexes
end

#initialize(*args) ⇒ Object 



32
33
34
35
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 32

def initialize(*args)
  super
  execute('PRAGMA FOREIGN_KEYS = ON')
end

#remove_foreign_key(table_name, foreign_key_name) ⇒ Object

Raises:

  • (NotImplementedError) 


57
58
59
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 57

def remove_foreign_key(table_name, foreign_key_name)
  raise NotImplementedError, "Sqlite3 does not support altering a table to remove foreign key constraints (table #{table_name.inspect} constraint #{foreign_key_name.inspect})"
end

#rename_table_with_schema_plus(oldname, newname) ⇒ Object

:nodoc:



48
49
50
51
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 48

def rename_table_with_schema_plus(oldname, newname) #:nodoc:
  rename_table_without_schema_plus(oldname, newname)
  rename_indexes_and_foreign_keys(oldname, newname)
end

#reverse_foreign_keys(table_name, name = nil) ⇒ Object 



69
70
71
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 69

def reverse_foreign_keys(table_name, name = nil)
  get_foreign_keys(nil, name).select{|definition| definition.references_table_name == table_name}
end

#view_definition(view_name, name = nil) ⇒ Object 



77
78
79
80
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 77

def view_definition(view_name, name = nil)
  sql = execute("SELECT sql FROM sqlite_master WHERE type='view' AND name=#{quote(view_name)}", name).collect{|row| row["sql"]}.first
  sql.sub(/^CREATE VIEW \S* AS\s+/im, '') unless sql.nil?
end

#views(name = nil) ⇒ Object 



73
74
75
 
# File 'lib/schema_plus/active_record/connection_adapters/sqlite3_adapter.rb', line 73

def views(name = nil)
  execute("SELECT name FROM sqlite_master WHERE type='view'", name).collect{|row| row["name"]}
end