class ExecuteSql::SqlQuery

Attributes

data[R]
explain[R]
query[R]
sql_explain[R]

Public Class Methods

new(query, sql_explain = false) click to toggle source
# File lib/execute_sql/sql_query.rb, line 7
def initialize(query, sql_explain = false)
  @query       = query
  @sql_explain = sql_explain
end

Public Instance Methods

execute() click to toggle source
# File lib/execute_sql/sql_query.rb, line 24
def execute
  if valid?
    load_data
    load_explain if sql_explain
  end
  self
end
load_data() click to toggle source
# File lib/execute_sql/sql_query.rb, line 20
def load_data
  @data    ||= SqlQueryData.new(self).load_data
end
load_explain() click to toggle source
# File lib/execute_sql/sql_query.rb, line 16
def load_explain
  @explain ||= SqlExplain.new(self).load_data
end
to_csv() click to toggle source
# File lib/execute_sql/sql_query.rb, line 32
def to_csv
  CSV.generate do |csv|
    csv << data.columns
    data.rows.each do |row|
      csv << row
    end
  end
end
valid?() click to toggle source
# File lib/execute_sql/sql_query.rb, line 12
def valid?
  query.present?
end