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