method

pk_and_sequence_for

v1.2.6 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::OracleAdapter

1.0.0
1.1.0
1.1.1
1.1.6
1.2.0 (0)
1.2.6 (0)
2.0.0
2.0.1
2.0.3
2.1.0
2.2.1
2.3.2
2.3.8
3.0.0
3.0.5
3.0.7
3.0.9
3.1.0
3.2.1
3.2.3
3.2.8
3.2.13
What's this?

pk_and_sequence_for(table_name) public

Find a table’s primary key and sequence. Note: Only primary key is implemented - sequence will be nil.

# File activerecord/lib/active_record/connection_adapters/oracle_adapter.rb, line 395
        def pk_and_sequence_for(table_name)
          (owner, table_name) = @connection.describe(table_name)

          pks = select_values("select cc.column_name\nfrom all_constraints c, all_cons_columns cc\nwhere c.owner = '\#{owner}'\nand c.table_name = '\#{table_name}'\nand c.constraint_type = 'P'\nand cc.owner = c.owner\nand cc.constraint_name = c.constraint_name\n", 'Primary Key')

          # only support single column keys
          pks.size == 1 ? [oracle_downcase(pks.first), nil] : nil
        end

pk_and_sequence_for

Related methods

Flowdock - Team Inbox With Chat for Software Developers