Class: NewRelic::Agent::Database::Obfuscator

Inherits:
Object
  • Object
show all
Includes:
Singleton
Defined in:
lib/new_relic/agent/database.rb

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initializeObfuscator

Returns a new instance of Obfuscator.



158
159
160
# File 'lib/new_relic/agent/database.rb', line 158

def initialize
  reset
end

Instance Attribute Details

#obfuscatorObject (readonly)

Returns the value of attribute obfuscator.



156
157
158
# File 'lib/new_relic/agent/database.rb', line 156

def obfuscator
  @obfuscator
end

Instance Method Details

#default_sql_obfuscator(sql) ⇒ Object



189
190
191
192
193
194
195
196
197
198
199
# File 'lib/new_relic/agent/database.rb', line 189

def default_sql_obfuscator(sql)
  stmt = sql.kind_of?(Statement) ? sql : Statement.new(sql)
  adapter = stmt.adapter
  obfuscated = remove_escaped_quotes(stmt)
  obfuscated = obfuscate_single_quote_literals(obfuscated)
  if !(adapter.to_s =~ /postgres/ || adapter.to_s =~ /sqlite/)
    obfuscated = obfuscate_double_quote_literals(obfuscated)
  end
  obfuscated = obfuscate_numeric_literals(obfuscated)
  obfuscated.to_s # return back to a regular String
end

#obfuscate_double_quote_literals(sql) ⇒ Object



209
210
211
# File 'lib/new_relic/agent/database.rb', line 209

def obfuscate_double_quote_literals(sql)
  sql.gsub(/"(?:[^"]|"")*"/, '?')
end

#obfuscate_numeric_literals(sql) ⇒ Object



213
214
215
# File 'lib/new_relic/agent/database.rb', line 213

def obfuscate_numeric_literals(sql)
  sql.gsub(/\b\d+\b/, "?")
end

#obfuscate_single_quote_literals(sql) ⇒ Object



205
206
207
# File 'lib/new_relic/agent/database.rb', line 205

def obfuscate_single_quote_literals(sql)
  sql.gsub(/'(?:[^']|'')*'/, '?')
end

#remove_escaped_quotes(sql) ⇒ Object



201
202
203
# File 'lib/new_relic/agent/database.rb', line 201

def remove_escaped_quotes(sql)
  sql.gsub(/\\"/, '').gsub(/\\'/, '')
end

#resetObject



162
163
164
# File 'lib/new_relic/agent/database.rb', line 162

def reset
  @obfuscator = method(:default_sql_obfuscator)
end

#set_sql_obfuscator(type, &block) ⇒ Object

Sets the sql obfuscator used to clean up sql when sending it to the server. Possible types are:

:before => sets the block to run before the existing obfuscators

:after => sets the block to run after the existing obfuscator(s)

:replace => removes the current obfuscator and replaces it with the provided block



177
178
179
180
181
182
183
184
185
186
187
# File 'lib/new_relic/agent/database.rb', line 177

def set_sql_obfuscator(type, &block)
  if type == :before
    @obfuscator = NewRelic::ChainedCall.new(block, @obfuscator)
  elsif type == :after
    @obfuscator = NewRelic::ChainedCall.new(@obfuscator, block)
  elsif type == :replace
    @obfuscator = block
  else
    fail "unknown sql_obfuscator type #{type}"
  end
end