method

indexes

v4.2.9 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::SQLite3Adapter

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 (0)
4.1.8 (0)
4.2.1 (0)
4.2.7 (0)
4.2.9 (0)
5.0.0.1 (0)
5.1.7 (0)
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?

indexes(table_name, name = nil) public

Returns an array of indexes for the given table.

# File activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb, line 392
      def indexes(table_name, name = nil) #:nodoc:
        exec_query("PRAGMA index_list(#{quote_table_name(table_name)})", 'SCHEMA').map do |row|
          sql =             SELECT sql            FROM sqlite_master            WHERE name=#{quote(row['name'])} AND type='index'            UNION ALL            SELECT sql            FROM sqlite_temp_master            WHERE name=#{quote(row['name'])} AND type='index'
          index_sql = exec_query(sql).first['sql']
          match = /\sWHERE\s+(.+)$/.match(index_sql)
          where = match[1] if match
          IndexDefinition.new(
            table_name,
            row['name'],
            row['unique'] != 0,
            exec_query("PRAGMA index_info('#{row['name']}')", "SCHEMA").map { |col|
              col['name']
            }, nil, nil, where)
        end
      end

indexes

Related methods