gistfile1

#!/usr/bin/env ruby
require 'mysql'

class DatabaseController
  attr_reader :dbh, :connected

  def initialize(hostname, user, password, db, table)
    @hostname, @user, @password, @db, @table = hostname, user, password, db, table
    @connected = false
  end

  def close
    @dbh.close if @dbh
    @connected = false
  end

  def open
  # Initiates connection to database
    begin
      @dbh = Mysql.real_connect(@hostname, @user, @password, @db)
      @connected = true
    rescue Mysql::Error => e
     puts "Error code: #{e.errno}"
     puts "Error message: #{e.error}"
     puts "Error SQLSTATE: #{e.sqlstate}" if e.respond_to?("sqlstate")
   end
  end

  def store_guest(first_name, last_name, address, phone_no, arrival_date, place, power_usage, type)
    open unless @connected
    ## Ändra så den tar ett guest objekt ist
    begin
      @dbh.query("""INSERT INTO #{@table} (first_name, last_name, address, phone_no, arrival_date, place, power_usage, type) VALUES (#{first_name}, #{last_name}, #{address}, #{phone_no.to_s}, #{arrival_date.to_s}, #{place.to_s}, #{power_usage}, #{type});""")
    ensure
      close
    end
  end
end