File: jruby_client.rb

package info (click to toggle)
ruby-riddle 2.3.1-2~deb10u1
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 10,752 kB
  • sloc: sql: 25,022; php: 5,992; ruby: 4,757; sh: 59; makefile: 5
file content (31 lines) | stat: -rw-r--r-- 699 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
# frozen_string_literal: true

class JRubyClient
  def initialize(host, username, password)
    address    = "jdbc:mysql://#{host}"
    properties = Java::JavaUtil::Properties.new
    properties.setProperty "user", username     if username
    properties.setProperty "password", password if password

    @client = Java::ComMysqlJdbc::Driver.new.connect address, properties
  end

  def query(statement)
    set     = client.createStatement.executeQuery(statement)
    results = []
    results << set.getString(1) while set.next
    results
  end

  def execute(statement)
    client.createStatement.execute statement
  end

  def close
    @client.close
  end

  private

  attr_reader :client
end