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

Relationships & Source Files
Namespace Children
Exceptions: `IntegerOutOf64BitRange`
Extension / Inclusion / Inheritance Descendants
Included In: `::ActiveRecord::ConnectionAdapters::PostgreSQLAdapter`
Defined in:	activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb

Constant Summary

COLUMN_NAME = private
# File 'activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb', line 95

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

COLUMN_NAME_WITH_ORDER = private
# File 'activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb', line 108

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

Instance Method Summary

#column_name_matcher
#column_name_with_order_matcher
#escape_bytea(value)

Escapes binary strings for bytea input to the database.
#quote_schema_name(name)

Quotes schema names for use in SQL queries.
#quote_table_name_for_assignment(table, attr)
#unescape_bytea(value)

Unescapes bytea output from a database to the binary string it represents.

Instance Method Details

#column_name_matcher

[ GitHub ]

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


def column_name_matcher
  COLUMN_NAME
end

#column_name_with_order_matcher

[ GitHub ]

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


def column_name_with_order_matcher
  COLUMN_NAME_WITH_ORDER
end

#escape_bytea(value)

Escapes binary strings for bytea input to the database.

[ GitHub ]

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


def escape_bytea(value)
  @connection.escape_bytea(value) if value
end

#quote_schema_name(name)

Quotes schema names for use in SQL queries.

[ GitHub ]

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


def quote_schema_name(name)
  PG::Connection.quote_ident(name)
end

#quote_table_name_for_assignment(table, attr)

[ GitHub ]

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


def quote_table_name_for_assignment(table, attr)
  quote_column_name(attr)
end

#unescape_bytea(value)

Unescapes bytea output from a database to the binary string it represents. NOTE: This is NOT an inverse of escape_bytea! This is only to be used on escaped binary output from database drive.

[ GitHub ]

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


def unescape_bytea(value)
  @connection.unescape_bytea(value) if value
end