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
# File lib/easy_save/db_connection.rb, line 49 def self.print_query(query, *interpolation_args) return unless PRINT_QUERIES puts '--------------------' puts query unless interpolation_args.empty? puts "interpolate: #{interpolation_args.inspect}" end puts '--------------------' end