Class: ActiveRecord::ConnectionAdapters::PostgreSQLAdapter

Inherits:
Object
  • Object
show all
Includes:
selfself::Utils
Defined in:
lib/core_ext/active_record/connection_adapters/postgresql_adapter.rb

Overview

Patched version: 3.1.3

Patched methods

  • indexes

Constant Summary collapse

INDEX_COLUMN_EXPRESSION =

Regex to find columns used in index statements

/ON \w+(?: USING \w+ )?\((.+)\)/
INDEX_WHERE_EXPRESION =

Regex to find where clause in index statements

/WHERE (.+)$/

Instance Method Summary collapse

Instance Method Details

#find_column_names(table_name, index) ⇒ Array

Find column names from index attributes. If the columns are virtual (ie this is an expression index) then it will try to return the functions that represent each column

Parameters:

  • table_name (String) —

    the name of the table

  • index (Hash) —

    index attributes

Returns:

  • (Array) 


85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
 
# File 'lib/core_ext/active_record/connection_adapters/postgresql_adapter.rb', line 85

def find_column_names(table_name, index)
  columns = Hash[query("    SELECT a.attnum, a.attname\n    FROM pg_attribute a\n    WHERE a.attrelid = \#{index[:id]}\n    AND a.attnum IN (\#{index[:keys].join(\",\")})\n  SQL\n\n  column_names = columns.values_at(*index[:keys]).compact\n\n  if column_names.empty?\n    definition = index[:definition].sub(INDEX_WHERE_EXPRESION, '')\n    if column_expression = definition.match(INDEX_COLUMN_EXPRESSION)[1]\n      column_names = split_expression(column_expression).map do |functional_name|\n        remove_type(functional_name)\n      end\n    end\n  end\n\n  column_names\nend\n", "Columns for index #{index[:name]} on #{table_name}")]

#find_lengths(index) ⇒ Array

Find length of index TODO Update lengths once we merge in ActiveRecord code that supports it. -dresselm 20120305

Parameters:

  • index (Hash) —

    index attributes

Returns:

  • (Array) 


147
148
149
 
# File 'lib/core_ext/active_record/connection_adapters/postgresql_adapter.rb', line 147

def find_lengths(index)
  []
end

#find_where_statement(index) ⇒ String

Find where statement from index definition

Parameters:

  • index (Hash) —

    index attributes

Returns:

  • (String) —

    where statement



138
139
140
 
# File 'lib/core_ext/active_record/connection_adapters/postgresql_adapter.rb', line 138

def find_where_statement(index)
  index[:definition].scan(INDEX_WHERE_EXPRESION).flatten[0]
end

#indexes(table_name, name = nil) ⇒ Object

Returns an array of indexes for the given table.

Patch 1 reason:

Since SchemaDumper#tables is patched to process tables with a schema prefix, the #indexes method receives table_name as “<schema>.<table>”. This patch allows it to handle table names with a schema prefix.

Patch 1:

Search using provided schema if table_name includes schema name.

Patch 2 reason:

#indexes is patched to support partial indexes using :where clause.

Patch 2:

Search the postgres indexdef for the where clause and pass the output to the custom PgPower::ConnectionAdapters::IndexDefinition



40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
 
# File 'lib/core_ext/active_record/connection_adapters/postgresql_adapter.rb', line 40

def indexes(table_name, name = nil)
  schema, table = extract_schema_and_table(table_name)
  schemas = schema ? "ARRAY['#{schema}']" : 'current_schemas(false)'

  result = query("    SELECT distinct i.relname, d.indisunique, d.indkey,  pg_get_indexdef(d.indexrelid), t.oid, am.amname\n    FROM pg_class t\n    INNER JOIN pg_index d ON t.oid = d.indrelid\n    INNER JOIN pg_class i ON d.indexrelid = i.oid\n    INNER JOIN pg_am    am ON i.relam = am.oid\n    WHERE i.relkind = 'i'\n      AND d.indisprimary = 'f'\n      AND t.relname = '\#{table}'\n      AND i.relnamespace IN (SELECT oid FROM pg_namespace WHERE nspname = ANY (\#{schemas}) )\n   ORDER BY i.relname\n  SQL\n\n  result.map do |row|\n    index = {\n      :name          => row[0],\n      :unique        => row[1] == 't',\n      :keys          => row[2].split(\" \"),\n      :definition    => row[3],\n      :id            => row[4],\n      :access_method => row[5]\n    }\n\n    column_names = find_column_names(table_name, index)\n\n    unless column_names.empty?\n      where   = find_where_statement(index)\n      lengths = find_lengths(index)\n\n      PgPower::ConnectionAdapters::IndexDefinition.new(table_name, index[:name], index[:unique], column_names, lengths, where, index[:access_method])\n    end\n  end.compact\nend\n", name)

#remove_type(column_with_type) ⇒ String

Remove type specification from stored Postgres index definitions

Examples:

remove_type("((col)::text")
=> "col"

Parameters:

  • column_with_type (String) —

    the name of the column with type

Returns:

  • (String) 


159
160
161
 
# File 'lib/core_ext/active_record/connection_adapters/postgresql_adapter.rb', line 159

def remove_type(column_with_type)
  column_with_type.sub(/\((\w+)\)::\w+/, '\1')
end

#split_expression(expression) ⇒ Object

Splits only on commas outside of parens



108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
 
# File 'lib/core_ext/active_record/connection_adapters/postgresql_adapter.rb', line 108

def split_expression(expression)
  result = []
  parens = 0
  buffer = ""

  expression.chars do |char|
    case char
    when ','
      if parens == 0
        result.push(buffer)
        buffer = ""
        next
      end
    when '('
      parens += 1
    when ')'
      parens -= 1
    end

    buffer << char
  end

  result << buffer unless buffer.empty?
  result
end