class DBConnection

Public Class Methods

execute(*args) click to toggle source
# File lib/easy_save/db_connection.rb, line 33
def self.execute(*args)
  print_query(*args)
  instance.execute(*args)
end
execute2(*args) click to toggle source
# File lib/easy_save/db_connection.rb, line 38
def self.execute2(*args)
  print_query(*args)
  instance.execute2(*args)
end
instance() click to toggle source
# File lib/easy_save/db_connection.rb, line 28
def self.instance
  reset if @db.nil?
  @db
end
last_insert_row_id() click to toggle source
# File lib/easy_save/db_connection.rb, line 43
def self.last_insert_row_id
  instance.last_insert_row_id
end
open(db_file_name) click to toggle source
# File lib/easy_save/db_connection.rb, line 11
def self.open(db_file_name)
  @db = SQLite3::Database.new(db_file_name)
  @db.results_as_hash = true
  @db.type_translation = true

  @db
end
reset() click to toggle source
# File lib/easy_save/db_connection.rb, line 19
def self.reset
  commands = []
  commands << "rm '#{USERS_DB_FILE}'" if File.exist?(USERS_DB_FILE)
  commands << "cat '#{USERS_SQL_FILE}' | sqlite3 '#{USERS_DB_FILE}'"

  commands.each { |command| `#{command}` }
  DBConnection.open(USERS_DB_FILE)
end

Private Class Methods

print_query(query, *interpolation_args) click to toggle source