Class: GitoriousMuninPlugins::Database

Inherits:
Object
  • Object
show all
Defined in:
lib/gitorious-munin-plugins/database.rb

Instance Method Summary collapse

Constructor Details

#initialize ⇒ Database

Returns a new instance of Database.



3
4
5
 
# File 'lib/gitorious-munin-plugins/database.rb', line 3

def initialize
  @config = Config.new
end

Instance Method Details

#database_configuration ⇒ Object 



7
8
9
 
# File 'lib/gitorious-munin-plugins/database.rb', line 7

def database_configuration
  @database_configuration ||= load_database_configuration
end

#database_connection ⇒ Object 



15
16
17
18
19
20
 
# File 'lib/gitorious-munin-plugins/database.rb', line 15

def database_connection
    @database_connection ||= Mysql.new(database_configuration["host"],
                     database_configuration["username"],
                     database_configuration["password"],
                     database_configuration["database"])
end

#load_database_configuration ⇒ Object 



11
12
13
 
# File 'lib/gitorious-munin-plugins/database.rb', line 11

def load_database_configuration
  YAML::load_file(@config.database_yaml)[@config.rails_env]
end

#select(sql) ⇒ Object 



22
23
24
25
26
27
28
29
 
# File 'lib/gitorious-munin-plugins/database.rb', line 22

def select(sql)
  conn = database_connection
  begin
    conn.query(sql)
  ensure
    conn.close
  end
end