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