method

foreign_keys

v5.1.7 - Show latest stable - 0 notes - Class: SchemaStatements

1.0.0
1.1.6
1.2.6
2.0.3
2.1.0
2.2.1
2.3.8
3.0.0
3.0.9
3.1.0
3.2.1
3.2.8
3.2.13
4.0.2
4.1.8
4.2.1 (0)
4.2.7 (0)
4.2.9 (0)
5.0.0.1 (0)
5.1.7 (0)
5.2.3 (0)
6.0.0 (0)
6.1.3.1 (0)
6.1.7.7 (0)
7.0.0 (0)
7.1.3.2 (0)
7.1.3.4 (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.

# File activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb, line 520
        def foreign_keys(table_name)
          scope = quoted_scope(table_name)
          fk_info = exec_query(            SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete            FROM pg_constraint c            JOIN pg_class t1 ON c.conrelid = t1.oid            JOIN pg_class t2 ON c.confrelid = t2.oid            JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid            JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid            JOIN pg_namespace t3 ON c.connamespace = t3.oid            WHERE c.contype = 'f'              AND t1.relname = #{scope[:name]}              AND t3.nspname = #{scope[:schema]}            ORDER BY c.conname.strip_heredoc, "SCHEMA")

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

            options[:on_delete] = extract_foreign_key_action(row["on_delete"])
            options[:on_update] = extract_foreign_key_action(row["on_update"])

            ForeignKeyDefinition.new(table_name, row["to_table"], options)
          end
        end

foreign_keys

Related methods

No documentation