method

pk_and_sequence_for

v3.2.13 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::PostgreSQLAdapter

1.0.0 (0)
1.1.6 (0)
1.2.6 (0)
2.0.3
2.1.0 (9)
2.2.1 (0)
2.3.8 (0)
3.0.0 (0)
3.0.9 (-2)
3.1.0 (0)
3.2.1 (0)
3.2.8 (0)
3.2.13 (0)
4.0.2
4.1.8
4.2.1
4.2.7
4.2.9
5.0.0.1
5.1.7
5.2.3
6.0.0
6.1.3.1
6.1.7.7
7.0.0
7.1.3.2
7.1.3.4
What's this?

pk_and_sequence_for(table) public

Returns a table’s primary key and belonging sequence.

# File activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb, line 942
      def pk_and_sequence_for(table) #:nodoc:
        # First try looking for a sequence with a dependency on the
        # given table's primary key.
        result = query(          SELECT attr.attname, seq.relname          FROM pg_class      seq,               pg_attribute  attr,               pg_depend     dep,               pg_namespace  name,               pg_constraint cons          WHERE seq.oid           = dep.objid            AND seq.relkind       = 'S'            AND attr.attrelid     = dep.refobjid            AND attr.attnum       = dep.refobjsubid            AND attr.attrelid     = cons.conrelid            AND attr.attnum       = cons.conkey[1]            AND cons.contype      = 'p'            AND dep.refobjid      = '#{quote_table_name(table)}'::regclass, 'SCHEMA')[0]

        if result.nil? or result.empty?
          result = query(            SELECT attr.attname,              CASE                WHEN split_part(pg_get_expr(def.adbin, def.adrelid), '''', 2) ~ '.' THEN                  substr(split_part(pg_get_expr(def.adbin, def.adrelid), '''', 2),                         strpos(split_part(pg_get_expr(def.adbin, def.adrelid), '''', 2), '.')+1)                ELSE split_part(pg_get_expr(def.adbin, def.adrelid), '''', 2)              END            FROM pg_class       t            JOIN pg_attribute   attr ON (t.oid = attrelid)            JOIN pg_attrdef     def  ON (adrelid = attrelid AND adnum = attnum)            JOIN pg_constraint  cons ON (conrelid = adrelid AND adnum = conkey[1])            WHERE t.oid = '#{quote_table_name(table)}'::regclass              AND cons.contype = 'p'              AND pg_get_expr(def.adbin, def.adrelid) ~* 'nextval', 'SCHEMA')[0]
        end

        [result.first, result.last]
      rescue
        nil
      end

pk_and_sequence_for

Related methods