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
-
#add_foreign_key(table_name, column_names, references_table_name, references_column_names, options = {}) ⇒ Object
-
#drop_table(name, options = {}) ⇒ Object
-
#foreign_keys(table_name, name = nil) ⇒ Object
-
#indexes_with_schema_plus(table_name, name = nil) ⇒ Object
-
#initialize(*args) ⇒ Object
-
#remove_foreign_key(table_name, foreign_key_name) ⇒ Object
-
#rename_table_with_schema_plus(oldname, newname) ⇒ Object
-
#reverse_foreign_keys(table_name, name = nil) ⇒ Object
-
#view_definition(view_name, name = nil) ⇒ Object
-
#views(name = nil) ⇒ Object
Class Method Details
.included(base) ⇒ Object
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
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
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
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) 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
|