method

indexes

v5.1.7 - 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 287
      def indexes(table_name, name = nil) #:nodoc:
        if name
          ActiveSupport::Deprecation.warn(            Passing name to #indexes is deprecated without replacement..squish)
        end

        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