Class: DBWrapper

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

Instance Method Summary collapse

Constructor Details

#initialize(database) ⇒ DBWrapper

Returns a new instance of DBWrapper.



4
5
6
 
# File 'lib/bukalapak_db_wrapper.rb', line 4

def initialize(database)
  @db = database
end

Instance Method Details

#delete(id) ⇒ Object 



26
27
28
29
30
 
# File 'lib/bukalapak_db_wrapper.rb', line 26

def delete(id)
  @db.execute('DELETE FROM test WHERE id = ?', [id])
rescue SQLite3::Exception
  prepare()
end

#execute(query) ⇒ Object 



32
33
34
35
36
 
# File 'lib/bukalapak_db_wrapper.rb', line 32

def execute(query)
  @db.execute(query)
rescue => exception
  $stderr.print exception.backtrace.join("\n");
end

#insert(id, value) ⇒ Object 



14
15
16
17
18
 
# File 'lib/bukalapak_db_wrapper.rb', line 14

def insert(id, value)
  @db.execute('INSERT INTO test VALUES (?, ?)', [id, value])
rescue SQLite3::Exception
  prepare()
end

#select ⇒ Object 



8
9
10
11
12
 
# File 'lib/bukalapak_db_wrapper.rb', line 8

def select
  @db.execute('SELECT * FROM test')
rescue SQLite3::Exception
  prepare()
end

#update(id, value) ⇒ Object 



20
21
22
23
24
 
# File 'lib/bukalapak_db_wrapper.rb', line 20

def update(id, value)
  @db.execute('UPDATE test SET value = ? WHERE id = ?', [value, id])
rescue SQLite3::Exception
  prepare()
end