Module: Foreigner::ConnectionAdapters::MysqlAdapter

Includes:
Sql2003
Defined in:
lib/foreigner/connection_adapters/mysql_adapter.rb

Instance Method Summary collapse

Methods included from Sql2003

#add_foreign_key, #supports_foreign_keys?

Instance Method Details

#foreign_keys(table_name) ⇒ Object 



16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
 
# File 'lib/foreigner/connection_adapters/mysql_adapter.rb', line 16

def foreign_keys(table_name)
  fk_info = select_all %{
    SELECT fk.referenced_table_name as 'to_table'
          ,fk.referenced_table_schema as 'to_database'
          ,fk.referenced_column_name as 'primary_key'
          ,fk.column_name as 'column'
          ,fk.constraint_name as 'name'
    FROM information_schema.key_column_usage fk
    WHERE fk.referenced_column_name is not null
      AND fk.table_schema = '#{@config[:database]}'
      AND fk.table_name = '#{table_name}'
  }

  create_table_info = select_one("SHOW CREATE TABLE #{quote_table_name(table_name)}")["Create Table"]

  fk_info.map do |row|
    options = {:column => row['column'], :name => row['name'], :primary_key => row['primary_key']}

    if create_table_info =~ /CONSTRAINT #{quote_column_name(row['name'])} FOREIGN KEY .* REFERENCES .* ON DELETE (CASCADE|SET NULL)/
      if $1 == 'CASCADE'
        options[:dependent] = :delete
      elsif $1 == 'SET NULL'
        options[:dependent] = :nullify
      end
    end
    
    if row['to_database'] != @config[:database]
      options[:database] = row['to_database']
    end
    
    ForeignKeyDefinition.new(table_name, row['to_table'], options)
  end
end

#remove_foreign_key(table, options) ⇒ Object 



6
7
8
9
10
11
12
13
14
 
# File 'lib/foreigner/connection_adapters/mysql_adapter.rb', line 6

def remove_foreign_key(table, options)
  if Hash === options
    foreign_key_name = foreign_key_name(table, options[:column], options)
  else
    foreign_key_name = foreign_key_name(table, "#{options.to_s.gsub(/^\w+\./, '').singularize}_id")
  end

  execute "ALTER TABLE #{quote_table_name(table)} DROP FOREIGN KEY #{quote_column_name(foreign_key_name)}"
end