8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
# File 'lib/dynamic_migrations/postgres/server/database/enums_loader.rb', line 8
def fetch_enums
rows = connection.exec(" SELECT\n n.nspname AS schema_name,\n t.typname AS enum_name,\n e.enumlabel AS enum_value,\n obj_description(e.enumtypid, 'pg_type') as enum_description\n FROM pg_type t\n JOIN pg_enum e ON t.oid = e.enumtypid\n JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace\n ORDER BY enumsortorder\n SQL\n\n schemas = {}\n rows.each do |row|\n schema_name = row[\"schema_name\"].to_sym\n enum_name = row[\"enum_name\"].to_sym\n enum_value = row[\"enum_value\"]\n\n schema = schemas[schema_name] ||= {}\n enum = schema[enum_name] ||= {\n values: [],\n description: row[\"enum_description\"]\n }\n enum[:values] << enum_value\n end\n schemas\nend\n")
|