Class: Timelog::Database

Inherits:
Object
  • Object
show all
Defined in:
lib/timelog/database.rb

Instance Method Summary collapse

Constructor Details

#initialize(configuration) ⇒ Database

Returns a new instance of Database.



5
6
7
8
9
 
# File 'lib/timelog/database.rb', line 5

def initialize(configuration)
  @configuration = configuration
  @database = SQLite3::Database.new @configuration.database
  update_to_latest_version!
end

Instance Method Details

#execute(sql, bind_vars = [], *args, &block) ⇒ Object 



11
12
13
 
# File 'lib/timelog/database.rb', line 11

def execute(sql, bind_vars = [], *args, &block)
  @database.execute(sql, bind_vars, *args, &block)
end

#first_column(sql, *bind_vars) ⇒ Object 



23
24
25
 
# File 'lib/timelog/database.rb', line 23

def first_column(sql, *bind_vars)
  @database.execute(sql, *bind_vars).map {|row| row.first}
end

#first_row(sql, *bind_vars) ⇒ Object 



15
16
17
 
# File 'lib/timelog/database.rb', line 15

def first_row(sql, *bind_vars)
  @database.get_first_row(sql, *bind_vars)
end

#first_value(sql, *bind_vars) ⇒ Object 



19
20
21
 
# File 'lib/timelog/database.rb', line 19

def first_value(sql, *bind_vars)
  @database.get_first_value(sql, *bind_vars)
end