Class: SqliteAdapter

Inherits:
Object show all
Defined in:
lib/jun/connection_adapters/sqlite_adapter.rb

Instance Method Summary collapse

Constructor Details

#initialize ⇒ SqliteAdapter

Returns a new instance of SqliteAdapter.



6
7
8
 
# File 'lib/jun/connection_adapters/sqlite_adapter.rb', line 6

def initialize
  @db = SQLite3::Database.new(Jun.root.join("db/app.db").to_s, results_as_hash: true)
end

Instance Method Details

#columns(table_name) ⇒ Object 



16
17
18
 
# File 'lib/jun/connection_adapters/sqlite_adapter.rb', line 16

def columns(table_name)
  @db.table_info(table_name).map { |info| info["name"].to_sym }
end

#execute(sql) ⇒ Object 



10
11
12
13
14
 
# File 'lib/jun/connection_adapters/sqlite_adapter.rb', line 10

def execute(sql)
  @db.execute(sql).each do |row|
    row.keys.each { |key| row[(key.to_sym rescue key) || key] = row.delete(key) }
  end
end