Module: ActiveRecord::PGEnum::PostgreSQLAdapter

Defined in:
lib/active_record/pg_enum/postgresql_adapter.rb

Instance Method Summary collapse

Instance Method Details

#enum_types ⇒ Object

Helper method used by the monkeypatch internals. Provides a hash of ENUM types as they exist currently.

Example:

{ "foo_type" => ["foo", "bar", "baz"] }



9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
# File 'lib/active_record/pg_enum/postgresql_adapter.rb', line 9

def enum_types
  res = exec_query(<<-SQL.strip_heredoc, "SCHEMA").cast_values
    SELECT t.typname AS enum_name, string_agg(e.enumlabel, ' ' ORDER BY e.enumsortorder) AS enum_value
    FROM pg_type t
    JOIN pg_enum e ON t.oid = e.enumtypid
    JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
    WHERE n.nspname = 'public'
    GROUP BY enum_name
  SQL

  res.inject({}) do |memo, (name, values)|
    memo[name] = values.split(" ")
    memo
  end
end