Module: EnumKit::ActiveRecordExtensions::ConnectionAdapters::PostgreSQLAdapter

Defined in:
lib/enum_kit/active_record_extensions/connection_adapters/postgresql_adapter.rb

Overview

:nodoc:

Constant Summary collapse

ENUM_QUERY =

Returns An SQL query that returns all available enum types in the database.

Returns:

  • An SQL query that returns all available enum types in the database.

"SELECT\npg_type.OID,\npg_type.typname,\npg_type.typtype,\narray_to_string(array_agg(pg_enum.enumlabel ORDER BY pg_enum.enumsortorder), '\\t\\t', '') as values\nFROM pg_type\nLEFT JOIN pg_enum ON pg_enum.enumtypid = pg_type.oid\nWHERE pg_type.typtype = 'e'\nGROUP BY pg_type.OID, pg_type.typname, pg_type.typtype\nORDER BY pg_type.typname\n"

Instance Method Summary collapse

Instance Method Details

#create_enum(name, values) ⇒ Object

Create a new enum type in the database.

Parameters:

  • The name of the new enum type.

  • The enum’s acceptable values.



43
44
45
46
47
48
 
# File 'lib/enum_kit/active_record_extensions/connection_adapters/postgresql_adapter.rb', line 43

def create_enum(name, values)
  name   = EnumKit.sanitize_name!(name)
  values = EnumKit.sanitize_values!(values)

  execute "CREATE TYPE #{name} AS ENUM #{EnumKit.sqlize(values)}"
end

#drop_enum(name) ⇒ Object

Drop an existing enum type from the database.

Parameters:

  • The name of the existing enum type.



54
55
56
 
# File 'lib/enum_kit/active_record_extensions/connection_adapters/postgresql_adapter.rb', line 54

def drop_enum(name)
  execute "DROP TYPE #{name}"
end

#enums ⇒ Hash

Returns The enum types available in the database.

Returns:

  • The enum types available in the database.



32
33
34
35
36
 
# File 'lib/enum_kit/active_record_extensions/connection_adapters/postgresql_adapter.rb', line 32

def enums
  @enums ||= select_all(ENUM_QUERY.tr("\n", ' ').strip).each_with_object({}) do |row, enums|
    enums[row['typname'].to_sym] = row['values'].split("\t\t")
  end
end

#migration_keys ⇒ Object

:nodoc:



60
61
62
 
# File 'lib/enum_kit/active_record_extensions/connection_adapters/postgresql_adapter.rb', line 60

def migration_keys
  super + [:name]
end

#prepare_column_options(column, types) ⇒ Object

:nodoc:



66
67
68
69
70
 
# File 'lib/enum_kit/active_record_extensions/connection_adapters/postgresql_adapter.rb', line 66

def prepare_column_options(column, types)
  spec = super(column, types)
  spec[:name] = column.cast_type.type.inspect if column.type == :enum
  spec
end