Module: Foreigner::ConnectionAdapters::Sql2003

Included in:
Mysql2Adapter, PostgreSQLAdapter
Defined in:
lib/foreigner/connection_adapters/sql2003.rb

Instance Method Summary collapse

Instance Method Details

#add_foreign_key(from_table, to_table, options = {}) ⇒ Object 



23
24
25
26
 
# File 'lib/foreigner/connection_adapters/sql2003.rb', line 23

def add_foreign_key(from_table, to_table, options = {})
  sql = "ALTER TABLE #{quote_table_name(from_table)} #{add_foreign_key_sql(from_table, to_table, options)}"
  execute(sql)
end

#add_foreign_key_sql(from_table, to_table, options = {}) ⇒ Object 



28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
 
# File 'lib/foreigner/connection_adapters/sql2003.rb', line 28

def add_foreign_key_sql(from_table, to_table, options = {})
  column  = options[:column] || "#{to_table.to_s.singularize}_id"
  foreign_key_name = options.key?(:name) ? options[:name].to_s : foreign_key_name(from_table, column)
  primary_key = options[:primary_key] || "id"
  dependency = dependency_sql(options[:dependent])

  proper_name = proper_table_name(to_table)

  sql =
    "ADD CONSTRAINT #{quote_column_name(foreign_key_name)} " +
    "FOREIGN KEY (#{quote_column_name(column)}) " +
    "REFERENCES #{quote_table_name(proper_name)}(#{primary_key})"
  sql << " #{dependency}" if dependency.present?
  sql << " #{options[:options]}" if options[:options]

  sql
end

#drop_table(*args) ⇒ Object 



8
9
10
11
12
13
14
15
 
# File 'lib/foreigner/connection_adapters/sql2003.rb', line 8

def drop_table(*args)
  options = args.extract_options!
  if options[:force]
    disable_referential_integrity { super }
  else
    super
  end
end

#foreign_key_exists?(from_table, options) ⇒ Boolean

Returns:

  • (Boolean) 


17
18
19
20
21
 
# File 'lib/foreigner/connection_adapters/sql2003.rb', line 17

def foreign_key_exists?(from_table, options)
  foreign_key_name = decipher_foreign_key_name(from_table, options)

  foreign_keys(from_table).any? { |fk| fk.name == foreign_key_name }
end

#proper_table_name(to_table) ⇒ Object 



46
47
48
49
50
51
52
 
# File 'lib/foreigner/connection_adapters/sql2003.rb', line 46

def proper_table_name(to_table)
  if ActiveRecord::Migration.instance_methods(false).include? :proper_table_name
    ActiveRecord::Migration.new.proper_table_name(to_table)
  else
    ActiveRecord::Migrator.proper_table_name(to_table)
  end
end

#remove_foreign_key(table, options) ⇒ Object 



54
55
56
 
# File 'lib/foreigner/connection_adapters/sql2003.rb', line 54

def remove_foreign_key(table, options)
  execute "ALTER TABLE #{quote_table_name(table)} #{remove_foreign_key_sql(table, options)}"
end

#remove_foreign_key_sql(table, options) ⇒ Object 



58
59
60
61
 
# File 'lib/foreigner/connection_adapters/sql2003.rb', line 58

def remove_foreign_key_sql(table, options)
  foreign_key_name = decipher_foreign_key_name(table, options)
  "DROP CONSTRAINT #{quote_column_name(foreign_key_name)}"
end

#supports_foreign_keys? ⇒ Boolean

Returns:

  • (Boolean) 


4
5
6
 
# File 'lib/foreigner/connection_adapters/sql2003.rb', line 4

def supports_foreign_keys?
  true
end