Contents

require 'clickhouse/cluster'
require 'clickhouse/connection'
require_relative 'exceptions'
require_relative 'prepared_statement'

module ActiveHouse
  class Connection
    attr_reader :config

    def initialize(config)
      config.assert_valid_keys(:url, :urls, :database, :username, :password, :host, :port, :scheme)
      @config = config
      @connection = nil
      ensure_connected!
    end

    def execute(sql, *bindings)
      prepared_sql = prepared_statement(sql, *bindings)
      connection.execute(prepared_sql)
    end

    def select_all(sql, *bindings)
      prepared_sql = prepared_statement(sql, *bindings)
      connection.query(prepared_sql)
    end

    def select_values(sql, *bindings)
      select_all(sql, *bindings).flatten
    end

    def select_value(sql, *bindings)
      select_all(sql, *bindings).flatten.first
    end

    def select_row(sql, *bindings)
      select_all(sql, *bindings).to_hashes.first
    end

    def select_rows(sql, *bindings)
      select_all(sql, *bindings).to_hashes
    end

    def raw_query(sql)
      connection.get(sql)
    end

    def connection_alive?
      return false if connection.nil?
      if connection.is_a?(Clickhouse::Cluster)
        !connection.pond.available.empty?
      else
        begin
          connection.ping!
          true
        rescue StandardError
          false
        end
      end
    end

    def reconnect!
      ensure_connected!
    end

    private

    def prepared_statement(sql, *bindings)
      ActiveHouse::PreparedStatement.prepare_sql(sql, *bindings)
    end

    attr_reader :connection

    def ensure_connected!
      @connection = establish_connection unless connection_alive?
      raise ActiveHouse::Exceptions::ConnectionError unless connection_alive?
    end

    def establish_connection
      if config.key?(:urls)
        Clickhouse::Cluster.new(config)
      else
        Clickhouse::Connection.new(config)
      end
    end
  end
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
active_house-0.6.6	lib/active_house/connection.rb
active_house-0.6.5	lib/active_house/connection.rb
active_house-0.6.4	lib/active_house/connection.rb
active_house-0.6.3	lib/active_house/connection.rb
active_house-0.6.2	lib/active_house/connection.rb
active_house-0.6.1	lib/active_house/connection.rb
active_house-0.6.0	lib/active_house/connection.rb
active_house-0.5.1	lib/active_house/connection.rb
active_house-0.5.0	lib/active_house/connection.rb