Contents

module ActsAsArchive
  module Base
    module Adapters
      module PostgreSQL

        private

        def archive_table_indexed_columns
          # This query comes courtesy of cope360:
          # http://stackoverflow.com/questions/2204058/show-which-columns-an-index-is-on-in-postgresql/2213199#2213199
          index_query = <<-SQL
select
    t.relname as table_name,
    i.relname as index_name,
    array_to_string(array_agg(a.attname), ', ') as column_names
from
    pg_class t,
    pg_class i,
    pg_index ix,
    pg_attribute a
where
    t.oid = ix.indrelid
    and i.oid = ix.indexrelid
    and a.attrelid = t.oid
    and a.attnum = ANY(ix.indkey)
    and t.relkind = 'r'
    and t.relname = 'archived_#{table_name}'
group by
    t.relname,
    i.relname
order by
    t.relname,
    i.relname
SQL

          indexes = connection.select_all(index_query).collect do |r|
            r["column_names"].split(", ").size > 1 ? r["column_names"].split(", ") : r["column_names"]
          end
        end
      end
    end
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
gravis-acts_as_archive-0.2.6	lib/acts_as_archive/base/adapters/postgresql.rb