class Makanai::Dbms::Mysql

Attributes

db[R]

Public Class Methods

new(config) click to toggle source
Calls superclass method
# File lib/makanai/dbms/mysql.rb, line 8
def initialize(config)
  super()
  @db = Mysql2::Client.new(config || default_config)
end

Public Instance Methods

execute_sql(sql) click to toggle source
# File lib/makanai/dbms/mysql.rb, line 15
def execute_sql(sql)
  db.query(sql).to_a.tap { close_db }
end

Private Instance Methods

close_db() click to toggle source
# File lib/makanai/dbms/mysql.rb, line 31
def close_db
  db.close
end
default_config() click to toggle source
# File lib/makanai/dbms/mysql.rb, line 21
def default_config
  {
    host: '0.0.0.0',
    username: 'root',
    password: 'password',
    database: 'makanai',
    port: 3306
  }
end