123456789_123456789_123456789_123456789_123456789_

Module: ActiveRecord::ConnectionAdapters::PostgreSQL::Quoting::ClassMethods

Do not use. This module is for internal use only.

Instance Method Summary

Instance Method Details

#column_name_matcher

[ GitHub ]

  
# File 'activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb', line 13

def column_name_matcher
  /
    \A
    (
      (?:
        # "schema_name"."table_name"."column_name"::type_name | function(one or no argument)::type_name
        ((?:\w\.|"\w"\.){,2}(?:\w|"\w")(?:::\w+)? | \w\((?:|\g<2>)\)(?:::\w)?)
      )
      (?:(?:\sAS)?\s(?:\w|"\w"))?
    )
    (?:\s*,\s*\g<1>)*
    \z
  /ix
end

#column_name_with_order_matcher

[ GitHub ]

  
# File 'activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb', line 28

def column_name_with_order_matcher
  /
    \A
    (
      (?:
        # "schema_name"."table_name"."column_name"::type_name | function(one or no argument)::type_name
        ((?:\w\.|"\w"\.){,2}(?:\w|"\w")(?:::\w+)? | \w\((?:|\g<2>)\)(?:::\w)?)
      )
      (?:\sCOLLATE\s"\w+")?
      (?:\sASC|\sDESC)?
      (?:\sNULLS\s(?:FIRST|LAST))?
    )
    (?:\s*,\s*\g<1>)*
    \z
  /ix
end

#quote_column_name(name)

Quotes column names for use in SQL queries.

[ GitHub ]

  
# File 'activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb', line 46

def quote_column_name(name) # :nodoc:
  QUOTED_COLUMN_NAMES[name] ||= PG::Connection.quote_ident(name.to_s).freeze
end

#quote_table_name(name)

Checks the following cases:

  • table_name

  • “table.name”

  • schema_name.table_name

  • schema_name.“table.name”

  • “schema.name”.table_name

  • “schema.name”.“table.name”

[ GitHub ]

  
# File 'activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb', line 58

def quote_table_name(name) # :nodoc:
  QUOTED_TABLE_NAMES[name] ||= Utils.extract_schema_qualified_name(name.to_s).quoted.freeze
end