Module: ActiveRecord::ConnectionAdapters::SQLServer::Quoting

Included in:
ActiveRecord::ConnectionAdapters::SQLServerAdapter
Defined in:
lib/active_record/connection_adapters/sqlserver/quoting.rb

Constant Summary collapse

QUOTED_COLUMN_NAMES =

:nodoc:

Concurrent::Map.new
QUOTED_TABLE_NAMES =

:nodoc:

Concurrent::Map.new

Instance Method Summary collapse

Instance Method Details

#column_name_matcherObject



79
80
81
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 79

def column_name_matcher
  COLUMN_NAME
end

#column_name_with_order_matcherObject



83
84
85
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 83

def column_name_with_order_matcher
  COLUMN_NAME_WITH_ORDER
end

#fetch_type_metadata(sql_type, sqlserver_options = {}) ⇒ Object



10
11
12
13
14
15
16
17
18
19
20
21
22
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 10

def (sql_type, sqlserver_options = {})
  cast_type = lookup_cast_type(sql_type)

  simple_type = SqlTypeMetadata.new(
    sql_type:  sql_type,
    type:      cast_type.type,
    limit:     cast_type.limit,
    precision: cast_type.precision,
    scale:     cast_type.scale
  )

  SQLServer::TypeMetadata.new(simple_type, **sqlserver_options)
end

#quote(value) ⇒ Object



117
118
119
120
121
122
123
124
125
126
127
128
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 117

def quote(value)
  case value
  when Type::Binary::Data
    "0x#{value.hex}"
  when ActiveRecord::Type::SQLServer::Data
    value.quoted
  when String, ActiveSupport::Multibyte::Chars
    "N#{super}"
  else
    super
  end
end

#quote_column_name(name) ⇒ Object



36
37
38
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 36

def quote_column_name(name)
  QUOTED_COLUMN_NAMES[name] ||= SQLServer::Utils.extract_identifiers(name).quoted
end

#quote_default_expression(value, column) ⇒ Object



44
45
46
47
48
49
50
51
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 44

def quote_default_expression(value, column)
  cast_type = lookup_cast_type(column.sql_type)
  if cast_type.type == :uuid && value.is_a?(String) && value.include?('()')
    value
  else
    super
  end
end

#quote_string(s) ⇒ Object



24
25
26
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 24

def quote_string(s)
  SQLServer::Utils.quote_string(s)
end

#quote_string_single(s) ⇒ Object



28
29
30
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 28

def quote_string_single(s)
  SQLServer::Utils.quote_string_single(s)
end

#quote_string_single_national(s) ⇒ Object



32
33
34
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 32

def quote_string_single_national(s)
  SQLServer::Utils.quote_string_single_national(s)
end

#quote_table_name(name) ⇒ Object



40
41
42
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 40

def quote_table_name(name)
  QUOTED_TABLE_NAMES[name] ||= SQLServer::Utils.extract_identifiers(name).quoted
end

#quoted_date(value) ⇒ Object



69
70
71
72
73
74
75
76
77
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 69

def quoted_date(value)
  if value.acts_like?(:time)
    Type::DateTime.new.serialize(value)
  elsif value.acts_like?(:date)
    Type::Date.new.serialize(value)
  else
    value
  end
end

#quoted_falseObject



61
62
63
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 61

def quoted_false
  '0'
end

#quoted_trueObject



53
54
55
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 53

def quoted_true
  '1'
end

#type_cast(value) ⇒ Object



130
131
132
133
134
135
136
137
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 130

def type_cast(value)
  case value
  when ActiveRecord::Type::SQLServer::Data
    value.to_s
  else
    super
  end
end

#unquoted_falseObject



65
66
67
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 65

def unquoted_false
  0
end

#unquoted_trueObject



57
58
59
# File 'lib/active_record/connection_adapters/sqlserver/quoting.rb', line 57

def unquoted_true
  1
end