Flowdock
method

foreign_keys

Importance_0
v4.2.1 - Show latest stable - 0 notes - Class: AbstractMysqlAdapter
  • 1.0.0
  • 1.1.1
  • 1.1.6
  • 1.2.0
  • 1.2.6
  • 2.0.0
  • 2.0.3
  • 2.1.0
  • 2.2.1
  • 2.3.2
  • 2.3.8
  • 3.0.0
  • 3.0.5
  • 3.0.9
  • 3.1.0
  • 3.2.1
  • 3.2.3
  • 3.2.8
  • 3.2.13
  • 4.0.2
  • 4.1.8
  • 4.2.1 (0)
  • 4.2.7 (0)
  • What's this?
foreign_keys(table_name) public

No documentation

This method has no description. You can help the Ruby on Rails community by adding new notes.

Hide source
# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 532
      def foreign_keys(table_name)
        fk_info = select_all           SELECT fk.referenced_table_name as 'to_table'                ,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}'.strip_heredoc

        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']
          }

          options[:on_update] = extract_foreign_key_action(create_table_info, row['name'], "UPDATE")
          options[:on_delete] = extract_foreign_key_action(create_table_info, row['name'], "DELETE")

          ForeignKeyDefinition.new(table_name, row['to_table'], options)
        end
      end
Register or log in to add new notes.