Class: LogStash::Inputs::Jdbc

Inherits:
Base
  • Object
show all
Extended by:
PluginMixins::ValidatorSupport::FieldReferenceValidationAdapter
Includes:
PluginMixins::ECSCompatibilitySupport::TargetCheck, PluginMixins::EventSupport::EventFactoryAdapter, PluginMixins::Jdbc::Common, PluginMixins::Jdbc::Jdbc, PluginMixins::Scheduler
Defined in:
lib/logstash/inputs/jdbc.rb

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from PluginMixins::Jdbc::Jdbc

#close_jdbc_connection, #execute_statement, #get_column_value, included, #prepare_jdbc_connection, #setup_jdbc_config

Methods included from PluginMixins::Jdbc::ValueHandler

#decorate_value, #extract_values_from

Instance Attribute Details

#database ⇒ Object (readonly)

for test mocking/stubbing



250
251
252
 
# File 'lib/logstash/inputs/jdbc.rb', line 250

def database
  @database
end

#last_run_metadata_file_path ⇒ Object (readonly)

path to the file used as last run storage



251
252
253
 
# File 'lib/logstash/inputs/jdbc.rb', line 251

def last_run_metadata_file_path
  @last_run_metadata_file_path
end

Instance Method Details

#register ⇒ Object 



255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
 
# File 'lib/logstash/inputs/jdbc.rb', line 255

def register
  @logger = self.logger

  if [@interval, @schedule, @period].compact.size > 1
    raise LogStash::ConfigurationError.new("Use only one of: interval, period, schedule.")
  end


  if @record_last_run
    if @last_run_metadata_path.nil?
      logstash_data_path = LogStash::SETTINGS.get_value("path.data")
      logstash_data_path = Pathname.new(logstash_data_path).join("plugins", "inputs", "jdbc")
      # Ensure that the filepath exists before writing, since it's deeply nested.
      logstash_data_path.mkpath
      logstash_data_file_path = logstash_data_path.join("logstash_jdbc_last_run")

      ensure_default_metadatafile_location(logstash_data_file_path)

      @last_run_metadata_file_path = logstash_data_file_path.to_path
    else
      #  validate the path is a file and not a directory
      if Pathname.new(@last_run_metadata_path).directory?
        raise LogStash::ConfigurationError.new("The \"last_run_metadata_path\" argument must point to a file, received a directory: \"#{last_run_metadata_path}\"")
      end
      @last_run_metadata_file_path = @last_run_metadata_path
    end
  end

  prepare_jdbc_connection

  if @use_column_value
    # Raise an error if @use_column_value is true, but no @tracking_column is set
    if @tracking_column.nil?
      raise(LogStash::ConfigurationError, "Must set :tracking_column if :use_column_value is true.")
    end
  end

  unless @statement.nil? ^ @statement_filepath.nil?
    raise(LogStash::ConfigurationError, "Must set either :statement or :statement_filepath. Only one may be set at a time.")
  end

  @statement = ::File.read(@statement_filepath) if @statement_filepath

  # must validate prepared statement mode after trying to read in from @statement_filepath
  if @use_prepared_statements
    validation_errors = validate_prepared_statement_mode
    unless validation_errors.empty?
      raise(LogStash::ConfigurationError, "Prepared Statement Mode validation errors: " + validation_errors.join(", "))
    end
  end

  set_value_tracker LogStash::PluginMixins::Jdbc::ValueTracking.build_last_value_tracker(self)
  set_statement_handler LogStash::PluginMixins::Jdbc::StatementHandler.build_statement_handler(self)

  @enable_encoding = !@charset.nil? || !@columns_charset.empty?

  if (@jdbc_password_filepath and @jdbc_password)
    raise(LogStash::ConfigurationError, "Only one of :jdbc_password, :jdbc_password_filepath may be set at a time.")
  end

  @jdbc_password = LogStash::Util::Password.new(::File.read(@jdbc_password_filepath).strip) if @jdbc_password_filepath

  if enable_encoding?
    encodings = @columns_charset.values
    encodings << @charset if @charset

    @converters = encodings.each_with_object({}) do |encoding, converters|
      converter = LogStash::Util::Charset.new(encoding)
      converter.logger = self.logger
      converters[encoding] = converter
    end
  end
  load_driver
end

#run(queue) ⇒ Object 



339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
 
# File 'lib/logstash/inputs/jdbc.rb', line 339

def run(queue)
  if @schedule
    # scheduler input thread name example: "[my-oracle]|input|jdbc|scheduler"
    scheduler.cron(@schedule) { execute_query(queue) }
    scheduler.join
  elsif @interval
    scheduler.interval(@interval) { execute_query(queue) }
    scheduler.join
  elsif @period
    scheduler.every(@period) { execute_query(queue) }
    scheduler.join
  else
    execute_query(queue)
  end
end

#set_statement_handler(handler) ⇒ Object

test injection points



331
332
333
 
# File 'lib/logstash/inputs/jdbc.rb', line 331

def set_statement_handler(handler)
  @statement_handler = handler
end

#set_value_tracker(instance) ⇒ Object 



335
336
337
 
# File 'lib/logstash/inputs/jdbc.rb', line 335

def set_value_tracker(instance)
  @value_tracker = instance
end

#stop ⇒ Object

def run



355
356
357
 
# File 'lib/logstash/inputs/jdbc.rb', line 355

def stop
  close_jdbc_connection
end