Sha256: 0990162d6db1c999afcc625015d2b324dd3413d656cbe5003e2536dcac8869fd
Contents?: true
Size: 1.04 KB
Versions: 6
Compression:
Stored size: 1.04 KB
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(", ").map(&:to_sym) : r["column_names"].to_sym
end
end
end
end
end
end
Version data entries
6 entries across 6 versions & 2 rubygems