Module: Csvsql

Extended by:

Csvsql

Included in:

Csvsql

Defined in:

lib/csvsql.rb,
lib/csvsql/version.rb

Defined Under Namespace

Classes: CommandRunner, Db, Tracker

Constant Summary

CACHE_DIR =

File.join(Dir.home, '.csvsql_cache')

VERSION =

"0.2.0"

Class Method Summary

• .clear_cache! ⇒ Object

Instance Method Summary

• #execute(sql, csv_data, opts = {}) ⇒ Object

Class Method Details

.clear_cache! ⇒ Object

# File 'lib/csvsql.rb', line 32

def self.clear_cache!
  FileUtils.rm_f(Dir.glob(File.join(CACHE_DIR, '*')))
end

Instance Method Details

#execute(sql, csv_data, opts = {}) ⇒ Object

# File 'lib/csvsql.rb', line 20

def execute(sql, csv_data, opts = {})
  csvdb = init_data(csv_data, opts)
  pst = Csvsql::Tracker.commit(:execute_query_sql) do
    csvdb.prepare(sql)
  end
  Csvsql::Tracker.commit(:output_format)
  CSV.generate do |csv|
    csv << pst.columns.zip(pst.types).map { |c| c.compact.join(':') }
    pst.each { |line| csv << line }
  end.tap { Csvsql::Tracker.commit(:output_format) }
end