Class: ActiveRecord::ColumnMetadata

Inherits:
Object
  • Object
show all
Defined in:
lib/active_record/column_metadata/read.rb,
lib/active_record/column_metadata/version.rb

Constant Summary collapse

VERSION =
"0.1.0"

Class Method Summary collapse

Class Method Details

.to_a(table_name) ⇒ Object

Retrieves metadata stored in the database for table_name as

[“col_name”, => “val”], …

ordered by col_name alphabetically



7
8
9
10
11
12
13
14
15
16
17
18
# File 'lib/active_record/column_metadata/read.rb', line 7

def self.to_a(table_name)
  res = ActiveRecord::Base.connection.query("    SELECT a.attname,\n           pg_catalog.col_description(a.attrelid, a.attnum)\n      FROM pg_catalog.pg_attribute a\n     WHERE a.attrelid = '\#{table_name}'::regclass\n       AND a.attnum > 0\n       AND NOT a.attisdropped\n  ORDER BY a.attname\n  END_SQL\n  res.map{ |tupple| [tupple.first, JSON.parse(tupple.last)] unless tupple.last.nil? }.compact\nend\n", 'Get comments')