Class: SqlWrangler::SqLiteConnection

Inherits:

SqlConnection

• Object
• SqlConnection
• SqlWrangler::SqLiteConnection

Defined in:

lib/sql_wrangler.rb

Instance Method Summary

• #close ⇒ Object
• #command(sql_string) ⇒ Object
• #execute_sql(sql_string, params = {}) ⇒ Object
• #initialize(db_path) ⇒ SqLiteConnection constructor

  A new instance of SqLiteConnection.

Methods inherited from SqlConnection

#query

Constructor Details

#initialize(db_path) ⇒ SqLiteConnection

Returns a new instance of SqLiteConnection.

# File 'lib/sql_wrangler.rb', line 15

def initialize(db_path)
  @db = SQLite3::Database.new db_path
end

Instance Method Details

#close ⇒ Object

# File 'lib/sql_wrangler.rb', line 27

def close
  @db.close
end

#command(sql_string) ⇒ Object

# File 'lib/sql_wrangler.rb', line 23

def command(sql_string)
  @db.execute_batch(sql_string)
end

#execute_sql(sql_string, params = {}) ⇒ Object

# File 'lib/sql_wrangler.rb', line 19

def execute_sql(sql_string, params={})
  @db.execute2(sql_string, params)
end