Contents

require 'mysql2'

class DBClient
  private_class_method :new
  @instance_mutex = Mutex.new

  def initialize
    db_config = YAML.load_file('./lib/db_config/library_config.yaml').transform_keys(&:to_sym)
    @client = Mysql2::Client.new(db_config)
    @client.query_options.merge!(symbolize_keys: true)
  end

  def self.instance
    return @instance if @instance

    @instance_mutex.synchronize do
      @instance ||= new
    end

    @instance
  end

  def prepare_exec(statement, *params)
    @client.prepare(statement).execute(*params)
  end

  def query(statement)
    print statement
    @client.query(statement)
  end

  def last_id
    @client.last_id
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
papaSquidLib-0.1.0	lib/data_sources/db_client.rb